Document directory
- Delphi7.0 + ROSE project development practices
Delphi7.0 + ROSE project development practices
DelphiTutorial Series of books(059)《Delphi7.0 + roseProject development practices Organize netizens (state)Email:Shuaihj@163.com
:
PDF
- Author: Lu weichen Zhou Tao
- Series name: programmer Project Development Instance Series
- Press: Science Press
- ISBN: 7030155734
- Mounting time:
- Published on: February 1, June 2005
- Start: 16
- Page number: 392
- Version: 1-1
Introduction
This book describes the entire process of developing database projects by combining Delphi and Rose software. The book introduces a variety of methods for developing database projects, and uses rose to build desert projects based on different projects. The database used in the book is SQL Server and can be transformed into other database systems. Examples of this book are taken from several types commonly used in life: archives, educational administration, students, hotels, books, attendance, wages, warehouse management, etc. Currently, there are not many books on the programming technology for Delphi7.0 + rose modeling and database system creation in the market. This book can make up for these shortcomings, yes-this is a rare practical reference book for medium and advanced programming users.
Preface
The author of this book has been engaged in Borland tool program development all the year round. In his long-term development practices, he has accumulated rich experience and collected and sorted out many valuable materials, the most basic and classic databases are selected from the list, and the most popular and practical databases are shared with readers. This book describes the entire process of developing a complete database project by combining Delphi7.0 and Rose project planning software. The book details a variety of methods for developing database projects in Delphi7.0. According to different project requirements, we use rose modeling to select different types of databases. The databases used in the book are the most popular sqlserver, users can easily transform it into other database systems. In addition, the detailed project examples also introduce environment settings, basic pas language knowledge, control application, and skill programming, the book also provides a large number of controls, API application skills and the essence of many Delphi programming, is a very rare, practical, mainly for medium and advanced programming user learning reference books. This book is informative and comprehensive. It mainly uses rose modeling and Delphi Database Programming applications to guide readers to learn about Delphi7.0 database programming technology. Currently, there are not many books on the programming technology for creating database systems using Delphi 7.0 + rose Modeling in a large space on the market. This book can make up for the above shortcomings. The cases in this book have been carefully selected to reflect the essence of Delphi Database programming technology. Examples are independent and interrelated. This book includes the personnel file management system, school teaching management system, student information management system, hotel front and back-end management system, book management system, attendance management system, Salary Management System, and warehouse management system. During the compilation of this book, Comrade Huo Yan and Lian Ying have also done a lot of work, and I would like to express my deep gratitude for this. Due to the limited level of the author, there are inevitable omissions. You are welcome to criticize and correct them.
Directory
Chapter 2 Personnel Archive Management System Modeling
1.1 System Design
1.1.1 rose Modeling
1.1.2 create a project use case View
1.1.3 create a logical view of the project
1.1.4 database creation Solution
1.1.5 create a component View
1.2 physical implementation of databases
Chapter 4 Implementation of the personnel file management system
2.1 prepare database applications
2.1.1 Main form design process
2.1.2 improve the framework structure designed by Rose
2.1.3 user login form design
2.1.4 configure database setdbform Form Design
2.1.5 Design of brmainform for data backup and recovery
2.1.6 Department management depmainform Design
2.1.7 SYSTEM account management form accountmainform Form Design
2.1.8 Design of The stuffmain form for personnel file management
2.1.9 Design of printsetupform
2.1.10 print preview printmainform Design
2.2 running results
Chapter 2 Design of school teaching administration system
3.1 establish educational administration system model
3.1.1 design use case View
3.1.2 logical view of the design project
3.1.3 design component View
3.1.4 convert the rose Model
3.2 Implementation of physical Databases
3.2.1 create a data table in SQL Server 2000
3.2.2 configure the ODBC Data Source
3.2.3 use SQL Server DMO to create databases and data tables
3.3 implementation of the database of the School Educational Administration System
3.3.1 main form design process
3.3.2 improve the framework structure designed by Rose
3.3.3 user login form design
3.3.4 configure database setdbmainform Design
3.3.5 backupandrestoreform Design for data backup and recovery
3.3.6 class settings tbsclass page design
3.3.7 tbscourse page design
3.3.8 account settings tbsaccount page design
3.3.9 design of the tbsscourse page for course Query
3.3.10 tbssscore page design
3.3.11 print and set printsempform Form Design
3.3.12 print and preview the printmainform Design
3.4 running results
Chapter 2 student information management Inquiry System
4.1 Establish a student information management and Inquiry System Model
4.1.1 design use case View
4.1.2 logical view of the design project
4.1.3 design component View
4.1.4 convert the rose Model
4.2 Implementation of physical Databases
4.2.1 create a data table in SQL Server 2000
4.2.2 configure the ODBC Data Source
4.3 Implementation of student information management and Inquiry System
4.3.1 Student Management
4.3.2 Student Course Selection Query
4.4 running results
Chapter 4 hotel front and back-end Management System
5.1 create a model for the front-and back-end management system of the hotel
5.1.1 design use case View
5.1.2 logical view of the design project
5.1.3 design component View
5.1.4 convert the rose Model
5.2 Implementation of physical Databases
5.3 Database Application Implementation of the front and back-end management system of the hotel
5.3.1 hotel Background Management System
5.3.2 hotel front-end Management System
5.4 running results
Chapter 2 Library Management System
6.1 create a library management system model
6.1.1 design use case View
6.1.2 logical view of the design project
6.1.3 design component View
6.1.4 convert the rose Model
6.2 Implementation of physical Databases
6.3 Implementation of the Library Management System
6.3.1 main form design process
6.3.2 improve the framework structure designed by Rose
6.3.3 user login page design
6.3.4 user registration page design
6.3.5 Design of borrowing and Returning books page
6.3.6 design the library management page
6.3.7 design of the book query page
6.3.8 design of the borrow Type page
6.4 running results
Chapter 2 Attendance Management System
7.1 create an Attendance Management System Model
7.1.1 design use case View
7.1.2 logical view of the design project
7.1.3 design component View
7.1.4 convert the rose Model
7.2 Implementation of physical Databases
7.2.1 create data tables
7.2.2 configure the ODBC Data Source
7.3 attendance management system database application implementation
7.3.1 main form design process
7.3.2 improve the framework structure designed by Rose
7.3.3 database connection settings Form Design
7.3.4 design of the loginform for logging on to the attendance system
7.3.5 account management form accountform Design
7.3.6 design of the kaoqingmainform for attendance record
7.4 running results
Chapter 4 Wage Management System
8.1 establish a Wage Management System Model
8.1.1 design use case View
8.1.2 logical view of the design project
8.1.3 design component View
8.1.4 convert the rose Model
8.2 Implementation of physical Databases
8.2.1 create data tables
8.2.2 configure the ODBC Data Source
8.3 wage management system database application implementation
8.3.1 main form design process
8.3.2 improve the framework structure designed by Rose
8.3.3 database connection settings Form Design
8.3.4 design of the loginform for logging on to the payroll system
8.3.5 design of the salary account management form accountform
8.3.6 salary standard setting form basesetup Design
8.3.7 Design of gzglform for wage statistics
8.3.8 salary query searchform Design
8.3.9 reward Record Form Design
8.4 running results
Chapter 4 Warehouse Management System
9.1 establish a Warehouse Management System Model
9.1.1 design use case View
9.1.2 logical view of the design project
9.1.3 design component View
9.1.4 convert the rose Model
9.2 Implementation of physical Databases
9.2.1 create data tables
9.2.2 configure the ODBC Data Source
9.3 Implementation of database application in the Warehouse Management System
9.3.1 main form design process
9.3.2 improve the framework structure designed by Rose
9.3.3 database connection settings Form Design
9.3.4 Warehouse Management System Login loginform Design
9.3.5 warehouse system account management form accountform Design
9.3.6 itemform Design
9.3.7 design of the searchform form for cargo Query
9.3.8 design of the kfglform for warehouse picking/warehouse receiving operations
9.4 running results