catalogue
The first part is the introduction.
1. 1 task or problem:
1.2 actual background:
1.3 My work
1.4 features (innovation)
The second part is graduation design.
2. 1 design project
2.2 Design time
2.3 Designers and Tasks
2.4 Lecturer
2.5 Design content
The third part demonstrates the system scheme.
3. 1 Software definition
3.2 Architecture planning
The fourth part is the content of graduation project.
4. 1 introduction to the development of distributed multi-tier database
4.2 Establishment of server-side programs
4.3 the establishment of the client program
4.4 client to achieve SQL query
4.5 Realize the dynamic connection with the application server
4.6 Realization of book management function
The fifth part is the experience of graduation design.
Part VI Appendix
8. 1 code section
reference data
abstract
The task of this graduation project is to develop a distributed multi-layer database book management system and learn to develop a distributed multi-layer database system with delphi. Using Delphi6.0 and MS Server2000 as development tools. By demonstrating computer hardware and software solutions; Application fields of investigation and analysis; Refer to various materials and practice database programming. With the help of the instructor, the requirements of the design task book have been basically realized smoothly. The designed database system can realize the management of general database. We studied the query optimization of database.
The first part is the introduction.
1. 1 task or problem:
Developing distributed multi-layer library management system can realize dynamic connection with application server. As long as the configuration file is configured, you can choose the application server to connect to just like your online neighbor. It also provides query functions such as borrowing and returning books, finding books and periodicals, etc.
1.2 actual background:
With the development of society, human production and life are increasingly inseparable from information. Whoever has more and more effective information will be in a favorable position in the competition. The information industry is becoming the pillar of a country. As the carrier of information, the importance of data management tool database to information technology has been paid more and more attention. Only by adopting advanced database technology can we effectively manage massive data and extract useful information from it for use.
In 1990s, the MIS system developed by most people is a client/server structure, which is both a hardware structure and a software structure. In other words, the data is placed on the server and the program is placed on the client. When accessing data, the client requests (usually SQL statements), and the server executes and gives the results. Client/server optimizes the network and improves the utilization rate of the system. The development of client/server architecture has experienced from two-tier architecture mode to three-tier architecture mode.
1.3 My work
Design system framework, design database, write code, test data, etc.
1.4 features (innovation)
You can choose the application server you want to connect to just like your online neighbor.
The second part is graduation design.
2. 1 design project
Zhangda Library Management System
2.2 Design time
10 in 2004 to 12 in 2004.
2.3 Designers and Tasks
The Realization of Wang Dongkai's Dynamic Connection Server Module and Assistant Function Module
Realization of Wang Kaibin's Distributed Multilayer Data Module
Realization of management function module of Wang Library
Analysis of Chen Qinghui's sqlserver 2000 Database and Table Design
2.4 Lecturer
Sulvyuan
2.5 Design content
Delphi6.0 and MS Server2000 are the main development tools, and WindowsXP is the development platform. Design a distributed multi-tier application library management system. You can dynamically connect to the application server, and you can choose the application server you want to connect to by configuring the configuration file like an online neighbor. Realize fast and accurate connection with the application server.