This system is a multi-functional query application based on ASP language foundation and Access database. It has ultra-high-speed query, accurate and convenient; supports fuzzy query to expand the scope and accuracy of query; automatically generates data to simplify the management of huge data in the background; and can open messages. The board function provides functions such as communication between users and administrators. This system started production on November 9, 2007. After nearly a month of production, it was completed on December 1, 2007. During the testing process, many errors were found, and the database was redesigned and some programs were improved.
Super high-speed query:
Because everyone knows that the execution speed of JS is faster than that of ASP, most bus query systems use JS program segments to obtain query results by parsing a large amount of data. Although doing it this way is fast, it takes up a lot of time to analyze the data. If the data is larger. Furthermore, if there are multiple users using this system at the same time, it will give them a feeling that the refresh is very slow. In order to satisfy more users online at the same time. There are only two methods: one is to optimize the JS program segment to reduce its running time, that is, the time to search in the vast ocean of data is reduced, and some unnecessary programs are removed; the other is to reduce the amount of reading from the database and The number of reads means that the amount of data processing in any language is less than before, and the speed will naturally increase. Let’s analyze the previous solution. This solution is advisable, but the previous systems all use similar methods and have been improved. It can be seen that the optimization in this area has reached a relatively extreme level. So I used the second solution: reducing the amount of database reads and the number of reads. We generate SQL strings through loops instead of generating multiple SQL statements through loops. In this way, you only need to open the database once for reading under the same conditions. Instead of opening it multiple times. This saves a lot of time in database linking, opening, closing, etc. This enables high-speed querying.
Fuzzy query:
This system supports fuzzy query, which can provide users with a larger search space. If some users only know individual words of some information but do not know all the information they are looking for, the system will automatically execute fuzzy query and find out all the relevant information in the database. Information related to the information entered by the user is available for the user to select for re-query. In this way, users don't have to worry about finding the site or line they need. Gives users more space.
Multiple data tables are automatically generated:
Querying these lines, stations and transfers requires a lot of information tables to be completed in cooperation. So it is inevitable to add more information. This leads to difficulties in managing huge data information in the background. For this purpose, all functions related to the automatic generation of data tables have been specially developed. The so-called automatic generation does not require the administrator to add relevant information multiple times, but by adding a basic line information, the system will submit it through the administrator. Information generates all other relevant information and adds it to the corresponding data table. Therefore, the management of such a huge database is simplified to directly managing a data table. The same goes for modifying data. When modifying a line information, all other related information will be changed accordingly with the modification information submitted by the administrator. This simplifies the administrator's heavy management burden, is simple, and avoids many errors in which sites and lines do not correspond. Ensure data accuracy...
Adding a message board is an additional section in the system. The purpose is just to allow all users to supervise the accuracy and reliability of our system. If there is an error in the data or the data is updated but the administrator does not update it in time, the user can contact the administrator through the message board and provide it to the administrator. Corresponding information. It is impossible for just a few administrators to complete the update of such a huge database in a timely and accurate manner, so this function is specially enabled to allow everyone to work together to complete this meaningful project. The management message also adds functions such as batch deletion to facilitate administrator management...
Administrator permissions: The system can set up 3 administrators with permissions. The first type is an administrator who only has permission to view information. The second type is an administrator who has permission to add routes. The third type is a super administrator who has all operations. Permissions!
Started production on 2007-11-9
Completed on 2007-12-1 and repaired on 2008-1-19
Yanlang revised July 13, 2008
Jing Hua Mu Mu was last modified on October 30, 2008
Backend address: admin
Backend login:
Username: admin
Password:admin
Database path: data/busdata.mdb
If you want to modify the database, be sure to modify the database connection in inc/conn.asp. Remember to modify this path when you use it for the first time and change it to your own database path.
Expand
