【 Abstract 】 This paper introduces the design idea and main technologies of the WEB-based tourism e-commerce website, discusses the basic modules of the system, such as user management, product management, shopping management and order management, and analyzes the concrete implementation method of accessing the Web database by combining ASP technology and ADO.
[Keywords:] tourism e-commerce website database ADO
With the maturity of e-commerce, a new business operation mode, tourism e-commerce websites have developed rapidly and have begun to take shape in terms of quantity. Looking at the development of tourism e-commerce in China in recent years, tourism e-commerce is developing from a simple information service mode of online information browsing, searching and broadcasting to a real-time online transaction and payment service mode. In order to better conduct online transactions, it is necessary for us to carefully design the whole website.
First, the system design of tourism e-commerce website
Before the system is implemented, it needs to be planned. First of all, it is necessary to determine the basic functional structure of a tourism e-commerce website system and consider the design scheme of the database system.
1. System functional structure
Usually, on the tourism e-commerce website, tourists can browse and inquire about tourism products and learn the detailed information of tourism products, such as tourist routes, scenic spots, catering, accommodation, prices and so on. If you are satisfied, after registration, you can log in with your user name and password, fill in the order and pay, and then you can order the travel product. Based on the above shopping process, a typical B2C tourism e-commerce website can be divided into four basic functional modules: user management, product management, shopping management and order management. Each module is independent of each other and can complete its own functions independently. These modules are closely related and indispensable. For example, order management needs to record product information and user information, and these modules are inseparable from user management and product management. The basic functional structure of the system is as follows.
Website functional structure diagram
2. Database design
Database design is very important in the design of website system. Database is the core of the website, and it is also the link between various functional modules. If the design is improper, the performance of the website will also be affected.
According to the function of the system, the entities in the tourism e-commerce system can be determined as members, products and orders. An entity set composed of similar entities is designed as a corresponding table. Therefore, at least the following three types of tables should be established in the database:
(1) member information table: it mainly stores personal information of members, such as member number, name, date of birth, contact phone number, email address, grade, etc.
(2) Tourism product information table info: it mainly stores the detailed information of tourist routes, hotels and flights. These three types of information can be stored in three tables, namely travelinfo, hotelinfo and airlineinfo. Travelinfo includes line number, line name, starting point, destination, number of days of sightseeing, price, number of participants, itinerary, supply standard, departure date, etc. Hotel information table hotelinfo includes number, name, city, address, star rating, room type, price, hotel profile, etc. The flight information table airlineinfo includes flight number, flight number, departure city, arrival city, flight company, aircraft type, departure date, departure time, arrival time, departure airport and landing airport.
(3) Order Information Table Order: It mainly stores the customer's order information, including the fields of order number, member number, payment method, payment status, order processing status, order receipt date, tourism product number, quantity and unit price. The member number can be linked with the member information table, and the tourism product number can be linked with the tourism product information table.
Second, the realization of tourism e-commerce website
According to the function of the system, the tourism e-commerce website can be divided into four basic functional modules: user management, product management, shopping management and order management, which run through the general processing flow of the current tourism e-commerce website.
1. Member management
Member management mainly includes three functions: user registration, login and information modification.
User registration is a basic channel for websites to obtain user information, which not only facilitates the management of users, but also provides better services for users through this information. A site cannot have two identical users, so it needs a key information, such as user name, to uniquely distinguish different users. Therefore, after the user is registered and submitted, it is necessary to check whether the user already exists in the website database. If so, return and re-enter, otherwise, after the system verifies the information, connect to the database and add it to the database by using the insert statement. The submission of data is in the form of form, and the transmission of data is in the POST method. When the submit button of the form is triggered, the objects in the form will be verified one by one to see if they meet the specifications, and if they are illogical, they will be returned and re-entered. Verification code can be defined as a process.
User login only needs to verify whether the user is the correct user through the database, that is, whether the entered user name and password are correct.
In general, personal information can only be modified after the user successfully logs in. Firstly, the user's information is displayed in the form of a table by querying the database, and then the user is allowed to modify it. After submitting the modified data, connect to the database and update the data in the database with the update statement.
2. Tourism product management
Tourism product management is mainly to show all kinds of tourism product information to tourists by establishing good classification and search methods of tourism products, so that tourists can browse products and buy them conveniently and quickly in various ways, and reduce unnecessary time waste of customers.
Tourist routes, hotels, flights and other information. It can be displayed to tourists from the aspects of price classification display, popular product display, recommended product display, new product display and inquiry display. From the perspective of database technology, almost all forms of product display are based on certain conditions to query the database and display the query results. Among them, query display is a complex product display mode, which allows multiple conditions to be entered for query, and then the qualified tourism products are displayed. Generally, fuzzy query like can display all products that meet the query conditions.
3. Shopping management
The shopping management module is actually a shopping process design from tourism product display to order generation. The shopping process can include many steps, which are not necessary. They exist only for one purpose, that is, to ensure that a complete order is generated correctly. Visitors need to log in before booking travel products, especially before settlement. The purpose of logging in is to obtain and record the relevant information of tourists. When tourists book tourism products, the system will automatically call the order generation module to generate the actual order, and the information of the order will be added to the order information table in the database. The generated order should include information such as order number, member number, payment method, payment status, order processing status, order receiving date, number, quantity, unit price and contact number of tourism products. Therefore, it is very important to obtain order information when implementing this module. For the user's content, the member number can be obtained from the data saved in the session object when the member logs in, and for the tourism product content, the product number can be obtained by clicking "Book" when the tourist selects the product. The content of payment needs temporary input from users, and data can be obtained by designing a form. After obtaining the necessary data, the system can generate orders according to these data and save the order data in the order data table.
4. Order management
Visitors can order multiple tourism products, generate multiple orders and manage their own orders. Visitors can check all orders and know the name and price of the purchased products at any time, and whether the orders have been paid and processed. Visitors can also delete some orders, such as unpaid and unprocessed orders, but paid orders cannot be deleted directly from the internet, so they must contact the staff.
From the order generation to the end of the transaction, the order must go through at least three states: unprocessed, being processed and processed. These state changes should be reflected in the order. Therefore, when designing an order table, in addition to the basic fields such as buyer, purchased product and order number, an order status field needs to be added to save the status of the current order.
Thirdly, using ADO to access the database.
The system adopts ADO (Active Data Object) as the database solution. ADO is an important built-in ActiveX component of ASP, which can provide powerful functions for database operation on the server side. In ASP pages, you can call ADO objects to operate the database. Through the combination of ODBC or the corresponding database engine and ADO and ASP, a web page providing database information can be established, allowing visitors to query, insert, update and delete the database information of the site server on the browser page. Its working process is: when the browser of the client fills in the form and presses the OK button, it sends an HTTP request to the WEB server through the Internet or Intranet, and the WEB server executes the ASP document specified by the request, uses ADO objects, calls ODBC drivers, connects to the database, executes the SQL instructions specified by the ASP document, and finally sends the execution results to the user's browser in HTML format.
ADO component defines three basic and core objects, namely connection object, command object and recordset object. The connection object is mainly used to establish and manage the connection with the database; Command command objects can provide flexible queries for the database through established connections; Recordset Recordset object is mainly used to represent the results returned by accessing the database query, through which operations such as adding, deleting and modifying data in the database can be realized. Through these three objects, users can easily establish database connections, execute SQL queries and complete database access.
Accessing the database with ASP and ADO can be realized according to the following steps:
(1) create a connection object instance, set the conn = server.create.ob object ("adodb.connection"), and use the Open method to open the database to be accessed, Conn.open "database name".
(2) Set the operation command on the database, that is, specify the SQL command to be executed on the database.
(3) Using the result set returned by the Execute () method of the Connection object, a Recordset object is automatically created, with set RS = conn.execute ("SQL "statement), and the query results are displayed by using the properties and methods provided by the Recordsets object.
(4) Close the result set object RS.close and disconnect Conn. Close from the database.
Four. Concluding remarks
The technology of developing and establishing e-commerce websites by using ASP and SQL Server is very mature. It is a good choice for small and medium-sized tourism enterprises to establish a website to realize the dynamic release of information and data. According to the running situation of general tourism e-commerce WEBsite, based on the three-tier browser/server structure based on web, IIS5.0 supporting ASP is adopted as the middle-tier web server, and ADO component is used to access SQL database, so as to realize the construction of dynamic tourism e-commerce website system based on Internet. At the same time, modular development is adopted to increase the maintainability and expansibility of the system, which provides a feasible scheme for general tourism e-commerce website system.