asp+access general query system can add, delete, modify and query paging v20221024
20221024
asp+access general query system can add, delete, modify and query pagination
The editor of Source Code Network brings you a practical asp+access universal query system. This system supports addition, deletion, modification, query and paging functions. It is very suitable for careful users who have an asp website environment and are skilled in operating access software.
System features:
1. Strong versatility: Flexible support for any number of data fields, and the query results are completely determined by your data.
2. Flexible settings: Query conditions, hidden fields, and modifiable columns can be flexibly set.
3. Ajax technology: Ajax technology is used to implement the query before addition, deletion, and modification operations occur, and only the setting fields of the current page can be modified.
4. Multi-page content paging: When the query results exceed one page, the system will automatically generate a paging function.
Special note: This is for learning reference only. Please do not use this system for purposes not permitted by laws and regulations.
User Guide:
1. Test usability: It is recommended to directly upload the system files to your website space for testing without modifying any content.
2. Access the query page: You can access the query page by visiting http://website/directory/.
3. Observe the pattern: Carefully observe the correspondence between the query page and the parameters. You can open the inc/conn.Asp file (open with notepad++) for research.
4. Database rules: Open the system's own database and observe the correspondence between the data structure and query results, which will help you quickly understand the working principle of the system.
5. Database file: The asa version database file is an access database file. Change its suffix to .mdb and you can open it with software such as Ms Access.
System architecture:
1. Query page:
The query page consists of the following parts:
* Query condition setting area: Users set query conditions in this area, such as selecting fields, entering keywords, etc.
* Query results display area: The system displays query results according to the query conditions set by the user, and provides addition, deletion and modification operations.
* Paging control area: When the query results exceed one page, the system will automatically generate paging control buttons to facilitate users to turn pages for viewing.
The query page uses ajax technology to implement the query function:
1. The user sets the query conditions in the query condition setting area and submits them.
2. The page uses ajax to asynchronously request the background program to obtain data according to the query conditions.
3. The background program returns the query results to the page and displays them in the query results display area.
4. If the query results exceed one page, the system will generate paging control buttons.
2. Background program:
The background program is mainly responsible for processing queries, additions, deletions, modifications and other operations, as well as generating query results and paging information.
The background program is mainly written in ASP language and uses the access database for data storage and operation.
The background program performs different operations according to the user's request type (query, addition, deletion, modification, etc.) and returns the results to the page.
3. Database:
The system's own database contains multiple tables, each table stores different types of user information.
The system stores user information in the access database to facilitate quick query and modification.
4. Document description:
The system contains multiple files, mainly including the following:
* inc/conn.Asp: Configuration file for connecting to the database.
* inc/desc.txt: Query page description file, supports html format.
* Query page.asp: The query page visited by the user.
* Background program.asp: The background program that handles user requests.
Suggestions for use:
It is recommended to read the system documentation carefully to understand the system functions and operation methods.
Try to use the system's own database and sample data to perform simple query operations.
According to your actual needs, modify the system configuration file and page code to achieve personalized functions.
If you encounter problems, please refer to your system documentation or seek help in the relevant forums.
I hope this universal query system can help you quickly build a powerful and easy-to-use query system.
