E-commerce website construction graduation thesis website design graduation thesis summary: This website uses the new Internet e-commerce technology and adopts the Microsoft ASP/ADO network database solution to achieve e-commerce management based on the B/S model. . Relying on the web server and the customer's browser, and taking advantage of the high efficiency and low cost of electronic tools, we provide customers with a trading platform, publish business information and product advertisements on the Internet, so that users can check products, search for products, order products, and provide customers with Provide all-weather, better and faster business activity space and realize the basic functions of online transactions. Based on the current design principles of commercial websites, the website is mainly based on online transaction functions, supplemented by entertainment, advertising, shopping guide and other functions. It is a comprehensive e-commerce website. This article mainly explains how to use ASP/ADO network database solution to complete the design of member community and back-end database management, and introduces its functions and implementation technology. Keywords: e-commerce, website, database, ASP/ADO 1. Foreword In order to meet the needs of internationalization, informatization and paperlessness in the field of international trade and commerce, e-commerce makes full use of computer technology, network communication technology and the Internet. In just a few years, it has rapidly developed into a pillar industry in the world, giving Bring comprehensive innovation to the economy, life, and work. Taking advantage of the opportunity of our graduation project, we try to build an all-day online shopping plaza in the form of online shopping to provide high-quality business services, reliable business information, and the latest business opportunities to any customer who visits this website. This website is divided into four major modules: shopping mall, member community, shopping cart, and data management. The structural relationship between them is as follows: Customers first enter the homepage of this website, that is, the shopping mall part, to purchase goods and read news. After registering as a member, you can log in to the member community module. Here, members can enjoy community functions such as chat rooms and flea markets designed specifically for members. You can also choose products in the shopping mall, put them in the shopping cart, fill in the relevant information, select the payment method, and after the order is confirmed, you can place a shopping order on this website. The data of these modules - product data, login data, customer data, member data, order data, etc. are all stored in the database management system, and the database administrator operates the database management program for system management. 2. The overall function of the website This website is an e-commerce shopping website developed with the online shopping function as the focus, supplemented by functions such as making friends, chatting, advertising, and shopping guides. 2.1 Online Shopping Guide Guide customers to purchase the required products through detailed descriptions of the origin, functions, prices, etc. of the displayed products in the product display area. Through product search on the site, customers can easily find the products they need. 2.2 Online ordering After customers understand the product, they can directly check the price, determine the quantity, and select the payment method to order the product on the web page. This website will deliver the goods and collect the payment in accordance with the agreed method. 2.3 Consultation and Negotiation You can use the electronic bulletin board, chat room or email advertisement on the website to learn about products, discuss problems, negotiate business, and realize merchant-to-merchant bulk commodity transactions. 3.1 Opinion solicitation Through the message board on the website, customers can directly express their opinions on the website and products, and put forward more and more practical suggestions and opinions. The website can also get more direct and faster feedback here, and improve the website better and faster to serve customers. 2.4 Transaction management Use database management to process orders in transactions, print out order reports, price lists, count the number of transactions, transaction amounts, and print billing reports. 2.5 Data Management Use web pages to systematically manage many data tables involved in the website and perform some background data operations, such as determining preferential membership, sending email advertisements, etc. 2.6 Investment board is used to contact merchants and purchase advertisements. Here are some investment treaties and examples of successful merchants. 2.7 Advertising: Provide customers with colorful product introductions through text, icons, pictures, titles, animations, etc., establish the website image, and promote product culture.
3． Member Community Function Customers can register as members in the community and enjoy membership prices for shopping. Members can make friends, chat, discuss problems, negotiate business, post purchase information in the community, and can also buy and sell second-hand goods at the flea market. In short, the membership community provides content Create a richer and more humane virtual space. 3.1 Introduction to community functions 3.1.1 Registered members Registered customers submit their personal information to the server to check the integrity and legality of their data, and then write the data into the database. ① Flow chart (see flow chart 1) ② Function implementation a. String length check Check whether the length of a certain character meets the required length. function ValidLength(item,len) { return (item.length >= len); } b. Empty field check If the required fields are not filled in, such as nickname, home address and other required fields, the program will remind the user to ensure Data integrity. For example, when checking the nickname column, if its length is less than 1, it is judged that the customer has not entered a nickname. The example program is as follows: if (! ValidLength(document.regfile.ni.value,1)) error(document.regfile.ni,"Please enter your nickname!"); c. Data check to check phone number, postal code, mobile phone Check whether the lengths of fields such as numbers and addresses meet the requirements to initially determine the correctness of their contents. For example, the phone number and mobile phone number should be 11 digits. If there are insufficient inputs, an input error will be prompted. The example program is as follows: if (! ValidLength(document.regfile.pho.value,11)) error(document.regfile.pho,"Please enter your phone number!"); 3.1.2 Member login customers who have registered as members , you can use this function to log in to the community webpage and communicate with netizens using their nicknames. This feature is also used for identity verification when filling out shopping orders. ① Flow chart (see flow chart 2) ② Function implementation a. Empty field check If the required fields are not filled in, the program will remind the user to ensure the integrity of the data. b. Password matching: Compare the password when logging in with the password when registering in the database. Only if they match completely will they be allowed to enter. 3.1.3 Modification of member information After logging in, members can re-modify their information on this web page. Function implementation: Data echo: Read customer information from the database and display it. Set the attributes that are not allowed to be modified as Read only for customers to browse and modify. After that, re-enter the database. For example, when text box data is echoed, you only need to pay the "value" of the text box as the string to be displayed. The example program is as follows: Nickname read only > 3.1.4 Members who have logged in to the chat room can enter the chat Room chatting, making friends, and negotiating business are the main parts of the real-time interaction on the website, providing members with more community space and more flexible transaction methods. ①Working principle: ②Function implementation a. Member entry: Members can enter the chat room after selecting their representative header and entering their nickname. Before entering the chat room, the program first writes the nickname and header into the database, and then assigns the data to the session object after entering. b. Expression selection You can choose different sentences to express the speaker's mood and attitude. Just save the string in the drop-down menu to the database and then display it on the chat board. c. Color selection Change the font color of the sent sentence. Just store the color value or letter corresponding to the string in the drop-down menu into the database first, and then display it in the color attribute of the FONT statement according to the syntax. 3.1.5 The flea market is an auction board. Here you can register the goods you want to transfer, indicate the price, quantity, brand and related introduction, and wait for the buyer to visit; you can also search for the items you need here and check the seller's information. Information and contact the seller to buy your favorite items; or, register your needs on the auction board and wait for the owner to contact you.
① Function realization a. Page function When a data table is too large to be displayed on a web page, we generally use page turning technology. set rs=server.createobject("adodb.recordset") rs.open sqlcmd,conn,adopenstatic,adlockpessimistic Use the rs.open method to connect the recordset object variable rs to the database and generate a record pointer that can be moved up and down. And use adlockpessimistic to perform pessimistic locking to prevent errors caused by multiple people changing data at the same time. page=clng(request("txtpage")) returns the page number to be turned to in the web page. rs.pagesize=5 sets the maximum number of records displayed on each page. if page<>1 then response.write"
Only the administrator with the highest authority has the authority to change administrator data. ① Administrator data table browsing: Read the administrator's information from the database and display it in table form for query and browsing. ② Administrator data table modification allows supervisors to modify the administrator password, name, and permissions. ③ Administrator data table addition allows supervisors to add new administrator data. ④ Administrator data table deletion Allows supervisors to delete old administrator data. 4.1.2 Member data management After registering as a member in the registration module, the data will be added to the member data table. The management of member data is conducive to viewing the basic situation of members, improving the running speed of the website and formulating preferential memberships. ① Member data browsing reads member information from the database and displays it in table form for query and browsing. ② Member data deletion will conditionally delete some members, such as members who have not logged in for too long, or whose information is consistent except for their nickname, or members who have lost necessary data during registration, and delete them through query statements to reduce the data in the database. Redundancy, speed up the website running speed ③ Determination of preferential membership. Some members who frequently visit the website will be graded according to their login times or frequency, and certain discounts will be given for shopping. Some members whose one-time shopping on the website exceeds a certain amount will be given Discount card for discounts on your next purchase. ④ Send advertising emails. Send electronic leaflets for the latest product promotions or exhibitions and sales activities to members through the email addresses filled in by members to promote products. 4.1.3 Product data management ① Product data browsing Read product data from the database and display it in a table for query and browsing. ② Incoming goods processing: Fill in the form with various information about the new goods and store them in the database. ③ Removal processing: Delete the record items of products that are not popular or outdated to reduce data redundancy. ④ Hot-selling judgment: Identify the products that have been clicked more often or the most purchased products, and recommend them to customers as hot-selling products. 4.1.4 Order data management ① Order list reads the administrator's information from the database and displays it in a table for query and browsing. ② Process orders. Review unprocessed orders, confirm the source of goods, payment form, and then print the shopping list. ③ Eliminate orders. Accumulate statistics on the orders that have been processed and then delete the records. ④ Send confirmed order. Send order copy file to customer to notify customer of successful purchase. 4.2 Database function implementation 4.2.1 Database connection When we want to access data, we must first connect to the database. We generally use ADO objects to complete. set newconn=server.createobject("ADODB.Connection") Use createobject to create a connection object. dbpath = server.mappath("..\dc\dc.mdb") Use mappath to obtain the actual path of the database. newconn.open"driver={Microsoft Access Driver (*.mdb)};dbq="&DBPath Use the open method to open a database with a dbpath path using the Access data source. 4.2.2 Data browsing List all data, or display data according to certain conditions. sqlcmd=”select * from data table where condition order by index” set rs=newconn.execute(sqlcmd) Select records that meet the conditions in the data table, then arrange them by index, use the execute method to execute them, and assign them to the rs record pointer . 4.2.3 Data addition Add new data to the data table. sqlcmd="insert into data table field values ??value" newconn.execute sqlcmd adds a new record in the data table and adds the field value to the corresponding field. 4.2.4 Data deletion Delete redundant data records in the database.
sqlcmd="delete from data table where condition " newconn.execute sqlcmd deletes records that meet the conditions in the data table and uses execute to execute the command. 4.2.5 Data query Search the database to find the record you want to query. sqlcmd=”select * from data table where condition order by index” set rs=newconn.execute(sqlcmd) Select records that meet the conditions in the data table, then arrange them by index, use the execute method to execute them, and assign them to the rs record pointer . 4.2.6 Data modification Update and modify the data, and then store it in the database. sqlcmd="update data table set field = new value where condition" newconn.execute sqlcmd retrieves records that meet the conditions, assigns new values ??to their corresponding fields, and uses execute to execute the command. 5. System database development instructions 5.1 Comparison between CGI and ASP/ADO This system adopts B/S mode and is based on NT network database development. It has many solutions, among which CGI is the traditional solution. In the CGI mode, after receiving the request, the web server calls the CGI program to analyze the content of the form, accesses the database if necessary, and finally transmits the query results to the browser in HTML format. Although CGI once played a great role in solving dynamic web pages, it has many shortcomings, such as being difficult to develop and change, having limited functions, and being difficult to find errors. Moreover, CGI is less efficient. Therefore, this system adopts a new network database solution, namely Microsoft's ASP/ADO network database solution. Using this solution basically solves the shortcomings of CGI. But it requires a certain execution environment, namely Microsoft's Internet Information Server (IIS for short) or Personal Web Server (PWS for short). The files executed in this environment are all files with the .asp suffix. IIS provides WWW, FTP, SMTP and other service functions for the Internet. IIS via embedded ActiveX. Data Object (ie ActiveX database control, referred to as ADO), for database access. In this mode, when the user requests a new ASP file, the network server will use IIS to call the corresponding ASP file. At this time, ASP uses the built-in object to receive the content of the user's form. At the same time, the asp document is translated into standard HTML tags. During the translation process, when it is necessary to access the database, ASP will use the ADO control to connect and access the corresponding database, and convert the query results into HTML tags. Finally, IIS will translate the ASP document into standard HTML tags and send them to the user's browser. 5.2 Using this model basically solves the problems of CGI: ① Using embedded objects in IIS makes development easy and changes simple. ② Using ASP's session object and application object, users can share information between different pages. ③ It has high operating efficiency. As long as an ASP program exists in the memory, it can be accessed by multiple users without copying its copy. ④ Using the embedded ADO control, you can easily access all databases supported by ODBC through ODBC, such as Oracle, SQL Server, ACCESS and other databases. 5.3 Introduction to related technologies: ① The internet information server (IIS for short) included in Microsoft's IIS Window NT server provides network service functions such as WWW, FTP, and Gopher for the internet or the internet. Through it, you can manage network servers and create virtual directories.
② Active Server pages (ASP for short): The ASP embedded in IIS allows you to develop dynamic web pages by combining Script languages ??such as HTML, Vbscript/Jscript and ActiveX Server Compement (ActiveX server control). ③ ActiveX Data Object (ActiveX Data Object, ADO for short): ASP links and accesses the database through its own ADO control, and the ADO control uses the ODBC database driver to implement the operation of re-accessing the database. ④ ODBC, its full name is (Open Database Connectivity): it is a database standard interface set by Microsoft, and applications can use Structured Query Language (Structured Query Language, SQL for short) through the ODBC programs of various databases provided. Access data from a variety of different databases. 6． Conclusion After more than a month of hard work, I finally realized the basic functions of an e-commerce website and achieved the expected goals. The use of web pages as back-end database management is also a special feature of this system. It is not only easy to create and highly interactive, but also conducive to future website expansion and increased functionality. However, this can only provide simple management of data and does not meet the needs of complex databases. At this time, Foxpro, Dephi, VC, VB, etc. need to be used to develop background database management programs. In addition, due to the limitations of objective conditions and limited knowledge, this system cannot provide complete business website functions, such as online payment, data encryption, network security, electronic accounts and other functions. But we are already aware of these and have reserved their functional interfaces in the system. As long as the conditions are mature, they can be put into use with slight modifications. References 1 Xu Tingrong, Huang Fei. Principles and Technology of E-Commerce [M]. Beijing: Science Press, 2001, 8. 2 Lin Yizheng, Huang Shiyang. HTML & ASP Web Page Production Tutorial [M]. Beijing: China Railway Press, 2000, 8. 3 Chen Mengjian. Basics of e-commerce [M]. Beijing: Electronic Industry Press, 2001, 6. 4 Li Bo, Yu Qian. ASP Application Development Guide [M]. Beijing: Science Press, 2000, 9. 5 Shan Yingen, Wang Changfu, Li Lianye. Basic e-commerce tutorials and application examples [M]. Beijing: Science Press, 2001, 8. 6 Lin Jinlin. ASP Practical Classics [M]. Beijing: China Railway Press, 1999, 12. 7 Shen Yifei. Dynamic HTML, from beginner to master[M]. Shanghai: Fudan University Press, 1999, 8. 8 Yang Jiping, Wu Hua. SQL SERVER2000 self-study tutorial[M]. Beijing: Tsinghua University Press, 2000, 11. 9 Website construction. www.25175.com