E-commerce website construction graduation thesis website design graduation thesis abstract: This website uses the new technology of Internet network e-commerce and adopts Microsoft ASP/ADO network database solution to realize e-commerce management based on B/S mode. With the help of the web server and the browser of the client, and with the characteristics of high efficiency and low cost of electronic tools, we can provide customers with a trading platform, publish business information and advertisements on the Internet, let users consult, search and order goods, provide customers with all-weather, better and faster business activity space, and realize the basic functions of online trading. According to the current design principles of commercial websites, the website is a comprehensive e-commerce website, with online trading functions as the main function, supplemented by entertainment, advertising, shopping guide and other functions. This paper mainly expounds how to use ASP/ADO network database solution to complete the design of member community and background database management, and introduces its function and implementation technology. Key words: e-commerce, website, database, ASP/ADO 1. In order to meet the needs of internationalization, informationization and paperless of international trade and commerce, e-commerce has made full use of computer technology, network communication technology and Internet, and rapidly developed into a global pillar industry in just a few years, bringing comprehensive innovation to economy, life and work. With the help of the graduation project, we try to build a full-time online shopping plaza in the form of online shopping, providing high-quality business services, reliable business information and the latest business opportunities for any customer who visits this website. This website is divided into four modules: shopping mall, member community, shopping cart and data management. The structural relationship between them is as follows: customers first enter the home page of this website, that is, the shopping plaza, buy goods and read news. After registering as a member, you can log in and enter the member community module. Here, members can enjoy community functions such as chat rooms and flea markets specially designed for members. You can also buy goods in the shopping mall, put them in the shopping cart, fill in the relevant information, choose the payment method, and after the order is confirmed, you can use this website to place an order for shopping. Data of these modules-commodity data, login data, customer data, membership data, order data, etc. Are stored in the database management system, and the database administrator operates the database management program to manage the system. 2. The overall function of the website This website is an e-commerce shopping website with online shopping as the main function, supplemented by functions such as making friends, chatting, advertising and shopping guide. 2. 1 online shopping guide guides customers to buy the required goods through the detailed explanation of the place of origin, function and price of the displayed goods in the commodity display area. Customers can easily find the goods they need by searching for goods in the station. 2.2 After ordering goods online, customers can directly check the price, determine the quantity, and choose the payment method to order goods. This website will deliver the goods and collect the payment according to the agreed way. 2.3 Consultation and negotiation: You can learn about goods, discuss problems and negotiate business with the help of electronic bulletin boards in business stations, chat rooms or e-mail advertisements on websites, which can realize business-to-business commodity transactions. 3. 1 Consultation Through the message board in the website, customers can directly express their views 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, improve the website better and faster, and serve customers. 2.4 Transaction management uses database management to process the orders in the transaction, print out the order report and price list, count the number of transactions and the transaction amount, and print the bill report. 2.5 Data management systematically manages many data tables involved in the website in the form of web pages, and carries out some background data operations, such as determining preferential members and sending emails and advertisements. 2.6 Merchants Board is used to contact merchants and buy advertisements. Here are some examples of investment treaties and successful enterprises. 2.7 Advertisements provide customers with colorful product introductions through words, icons, pictures, titles, animations and other forms, establish a website image and publicize product culture. 3. Member Community Function Customers can register as members in the community and enjoy the membership price when shopping. Members can make friends, chat, discuss problems, negotiate business, release purchase information, or buy and sell second-hand goods in flea markets. In short, the content of the member community provides a richer and more humanized virtual space. 3. 1 Introduction to community functions 3. 1. 1 Registered members Registered customers submit their personal data to the server, check the integrity and legality of their data, and then write the data into the database. ① Flow chart (see flow chart 1) ② Function realization A. String length check to see if the length of a character meets the required length. Function ValidLength(item, len) {return (item.length >; = len)； B. Blank field check If the required fields are not filled in, such as nickname and home address, the program will remind the user to ensure the integrity of the data. For example, if the length of the nickname column is less than 1, it is judged that the customer has not entered a nickname. The procedure is as follows: If (! Error in effective length (document.regfile.ni.value, 1)) (document.regfile.ni, "Please enter your nickname!" ); C data check: check whether the length of telephone number, postal code, mobile phone number, address and other fields meets the requirements, so as to preliminarily determine the correctness of its contents. For example, the telephone number and mobile phone number should be 1 1 digit. If the input is insufficient, you will be prompted that the input is wrong. The procedure is as follows: If (! Error in effective length (document.regfile.pho.value, 1 1)) (document.regfile.pho, "Please enter your phone number!" ); 3. 1.2 members can use this function to log in to community web pages and communicate with netizens through nicknames when logging in to customers who have registered as members. This function is also used to confirm the identity when filling out the shopping list. ① Flow chart (see flow chart 2) ② Function realization A. Blank 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: Compare the password when logging in with the password when registering in the database, and only when they are completely matched can they be allowed to enter. 3. 1.3 Modification of Member Information Members can modify their information again on this webpage after logging in. The function of data echo is to read and display the customer's data from the database, and set the properties that cannot be modified as read-only for the customer to browse and modify, and then re-enter the database. For example, for the echo of text box data, just pay the "value" of the text box as the string to be displayed. The example process is as follows: Nickname