The inevitable result of industry development. This new form of book sales has many advantages compared with the traditional way of selling books in bookstores: first, it reduces the sales cost; The second is to use the network as a trading platform to change the traditional trading methods so that trading activities are not limited by space and time; Third, the transmission of information is faster and more flexible. After the new book information is uploaded, customers can immediately see that the transaction can be conducted online immediately, which greatly improves the transaction efficiency. It is precisely because of these advantages that online bookstores can develop rapidly. The main function of the online bookstore system is to use the website as a trading platform to publish some basic information of books on the Internet in the form of a website. Customers can log on to the book sales website through the Internet, check the book sales information, submit orders to order books, and realize online transactions.
1, system function introduction
1. 1 Basic function introduces users to enter the system homepage according to the specified IP address or domain name. Register first, become a legal user, and then log in. The user selects the query method through the drop-down list box, including book title, publishing house and author. Then enter keywords in the corresponding text box, and click "Query" to display the basic information of books that meet the requirements. Users can add books to the shopping cart by clicking "Add to Shopping cart" of the corresponding books, and provide order information to the merchants through the shopping cart. Merchants regularly process the customer's order information and feed back the corresponding information to customers. The system counts the sales of books according to the order information, and displays the sales ranking of books on the home page.
1.2 function module introduction
1.2. 1 User management There are three types of users: ordinary users, merchants and system administrators. Ordinary users must register to query, browse, order and feedback books. Merchants need to register and get the approval and confirmation of system management. The main function is to manage the basic information of books. The system administrator is the only super user in the system, and does not need to register and maintain the system, but also manages the basic information of ordinary users and businesses.
1.2.2 The book management module is operated by the merchant, including adding, deleting and modifying basic information such as title, publisher, price, author, introduction and quantity.
1.2.3 Shopping cart management The purpose of using shopping carts is to store the names, quantities and total prices of books ordered by users. When the user enters the page where the book is displayed, click the "Join Shopping Cart" hyperlink.
& lt Youmai E-commerce Paper > At this time, the system will add the title, price, quantity and other information of the book corresponding to the current "Add to Shopping Cart" to the shopping cart. The default number of books is 1. On the shopping cart browsing page, users can modify the number of books or delete the book information in the shopping cart. The system calculates the total price according to the quantity and price of books purchased by users.
1.2.4 message management for legal users of the system, you can leave messages on the message board provided by the system. Once the message information is submitted, it can only be deleted and modified by the administrator.
2. System related technologies
This system is an online book sales system based on B/S structure, which is realized by ASP technology. Therefore, the foreground page and background management of this system are realized by HTML and ASP technology. Contains HTML markup language, embedded VB seript and JavaScript script code, SQL statements, and the background database is built with Access. B/S structure, that is, browser/server structure. This structure is a change or improvement of C/S structure with the rise of Internet technology. In this structure, users only need to install a browser. The user interface is completely realized through the browser, and part of the transaction logic is realized at the front end, but the main transaction logic is realized at the server end, forming a three-tier structure of C/S structure to sell books.
3. Design and implementation of online bookstore management system.
3. 1 project planning The online bookstore management system is a typical JSP database development application, which consists of two parts: foreground management and background website management. The front desk management part mainly includes the functions of book stand, shopping cart, cashier, member management, book city announcement and order inquiry, book inquiry and so on. The backstage management part mainly manages some basic data in the book mall effectively, including backstage login, book setting, membership setting, order setting, backstage administrator setting, friendship link setting, announcement setting and other functions.
3.2 System architecture design and class distribution architecture design Before coding, create folders that may be used in the website to facilitate future development work, and also standardize the overall architecture of the website. Using Servlet technology to realize the function of the whole website is basically in the form of "class".
3.3 The realization of shopping cart uses the Session object embedded in PHP and writes the corresponding PHP application to realize the shopping cart function. The session object is mainly used to store the information needed by a specific user session, which can overcome the shortcoming that the protocol has no "memory" function and can realize that all information will not be lost when jumping between pages. The main functions of the shopping cart are: displaying the information of purchasing books, adding books, changing the purchase quantity, canceling a book, canceling this order, and settling accounts, in which the corresponding pricing information will be automatically updated every time the order information is modified.
3.4 After the settlement customer clicks the "Settlement" button on the shopping cart page, the settlement page appears, and the "View Shopping Cart" button is also provided on the settlement page, which is convenient for the customer to check the purchased books and fees again before settlement. In addition, the customer is also required to fill in some necessary information, such as the customer's membership code, consignee, consignee address, delivery method, payment method, etc. If the consignee and the receiving address fields are blank, the name and address provided by the customer at the time of registration will be automatically used. After filling in the information, click the "Submit" button, and the system will check the correctness and legality of the information provided by the customer.
After that, immediately add relevant information to the server-side database, that is, add a record in the order table and one or more records in the order list.
3.5 Collecting customer information In order to realize normal transactions, we must know some customer information, such as consignee's name, consignee's address, consignee's telephone number, consignee's mailbox, delivery date, etc. In order to collect this information, we designed a user registration interface, and used the POST method of FORM form to send the customer information to the server and store it in the corresponding database. Of course, before that, we should check the legality of user registration information.
3.6 Online Payment In order to enable customers to pay online, bookstore operators must contact the bank in advance and apply for online payment function. With the approval of the bank, customers can pay online with their credit card number or bank account number. In order to ensure the security of operation, we must also rely on digital vouchers, digital signatures, encryption and other means to ensure the security and reliability of information transmission.
References:
[1] Zhang et al. Design and Implementation of Online Shopping System [M]. Computer Application Research, 2002.8
[2] Deng, Chen, Chen Junrong. ASP and network database technology [M]. China Railway Press, 2006.
Science and technology exploration, No.5, 20 10