004 _ DELPHI6 typical Database Development Instance

DELPHI6 typical Database Development Instance

DelphiTutorial Series of books(004)《DELPHI6Typical database development instances Organize netizens (state)Email:Shuaihj@163.com

:

PDF

• Author:Yin Limin
• Series Name:Software Engineer books
• Press: Electronic Industry Press
• ISBN:7505380109
• Mounting time: 2006-10-25
• Published on: February 1, November 2002
• Start: 16
• Page number: 536
• Version: 1-1

Introduction

This book is intended for readers who have certain experience in Delphi 6 application or Windows programming. The book works closely with examples and starts from the topic. Guided by examples, it comprehensively and thoroughly introduces common methods and techniques for developing database applications using Delphi 6.
The book consists of eight chapters, mainly explaining the database development tools, general query design, data exchange technology, file processing skills, reports and charts in Delphi 6, and multiple typical database development instances.
This book is rich in materials and informative. It integrates the theories and practices of using Delphi 6 to develop database applications. The well-designed instances are easy to learn and use, simple and clear, and can help program designers improve the ability to develop database application systems using Delphi 6. This book can also be used as a reference manual for intermediate training materials and professional technicians in Delphi 6.

Directory

Chapter 1 Preliminary Experience Delphi 6
1.1 New Features of Delphi 6
1.1.1 enhanced integrated Delphi Development Environment
1.1.2 new-generation Data Access Engine --- dbexpress
1.1.3 develop the WebSnap component of the Internet/Intranet application system
1.1.4 the evolutionary version of Midas -datasnap
1.1.5 XML/XSL support
1.1.6 develop web service wizard and components
1.2 SQL explorer in Delphi
1.2. I SQL explorer Overview
1.2.2 set ODBC Data Source
1.2.3 set the tag of the query script
1.3 SQL Monitor
1.3.1 SQL Monitor Overview
1.3.2 SQL monltor menu
1.4 use SQL explorer to manage databases
1.4.1 Database Management
1.4.2 Database Access
1.4.3 SQL query
1.5 database work platform
1.5.1 introduction to Database Desktop
1.5.2 use SQL query and QBE Query
1.6 database connection
1.6.1 BDE Administrator
1.6.2 connect to the ODBC database
1.6.3 use SQL links to connect to the SQL Server database
1.6.4 use SQL in a program
Conclusion 1.7
Chapter 4 file management and data storage
2.1 Basic Concepts and difficult processes/functions of file management
2.1.1 file type
2.1.2 text file
2.1.3 Document Management Standard Process
2.2 Student Achievement Management System
2.2.1 basic design ideas
2.2.2 open and create a record file
2.2.3 record file reading and display
2.2.4 Add a record
2.2.5 modification records
2.2.6 deletion, insertion, and sorting of records
2.2.7 file and system shutdown
2.3 simple file management program instance
2.3.1 Interface Design
2.3.2 Association of File Components
2.3.3 set the validity of options
2.3.4 self-painting style display of drivetabset
2.3.5 implementation of basic file management functions
Conclusion 2.4
Chapter 4 student register management system
3.1 System Analysis
3.1.1 System Requirements
3.1.2 Solution
3.1.3 function demonstration
3.2 use Microsoft Access 2000 to create a database
3.2.1 create a "Student Register" Database
3.2.2 create a "Student Information" table
3.2.3 create the "original education level" table
3.3 design the main form
3.3.1 set form attributes
3.3.2 add global variables to the module
3.3.3 form Initialization
3.4 Display records in the form
3.5 use DAO for data maintenance
3.5.1 add record
3.5.2 update data
3.5.3 edit record
3.5.4 delete a record
3.5.5 jump between records
3.6 create a "Query Form"
3.7 Query
3.8 run the program
Conclusion 3.9
Chapter 2 Data Exchange Technology
4.1 clipboard and Its Application
4.1, 1 use the clipboard to transmit text
4.1.2 clipboard class
4.1.3 use clipboard to transmit images
4.2 DDE Implementation Mechanism
4.2.1 introduction to the DDE implementation mechanism of Delphi 6
4.2.2 realization of DDE client program
4.2.3 realization of the DDE Server program
4.3 object link and embedding
4.3.1 introduction to Ole
4.3.2 creation of OLE objects during design
4.3.3 Ole Application Development Instance
4.4 dynamic link library Programming
4.4.1 windows Dynamic Link Library Principle
4.4.2 compiling and calling of DLLs
4.4.3 use DLLs for form Reuse
Conclusion 4.5
Chapter 2 Design of reports in the database application system
5.1 qreport component
5.1.1 tquickrep component
5.1.2 tqrexpr component
5.1.3 tqrsubdetail component
5.1.4 tqrsysdata component
5.1.5 other qreport Components
5.2 quick report Creation
5.2.1 Quickreport wizard
5.2.2 create a report using a Report Template
5.3 Integrate reports into Applications
5.4 chart creation example
5.4.1 design procedure interface
5.4.2 chart Scaling
5.4.3 display digital signals
5.4.4 keyboard control
5.4.5 storage for images
Conclusion 5.5
Chapter 4 delivery mail processing system
6.1 system design ideas
6.1.1 System Analysis
6.1.2 function demonstration
6.2 Design Database
6.3 create a Main Interface
6.3.1 Add a data module
6.3.2 design the main form
6.4 display Splash
6.5 Authentication
6.6 user management
6.6.1 useradd form
6.6.2 userman form
6.7 mail handling status
6.8 main form code design
Conclusion 6.9
Chapter 2 bookstore leasing management system
7.1 System Analysis
7.1.1 System Requirements
7.1.2 Solution
7.1.3 function demonstration
7.2 Design Database
7.2.1 "member information" table
7.2.2 "Book information" table
7.2.3 "Book Number-in-store number" table
7.2.4 "borrow information" table
7.2.5 "income" table
7.3 design menu
7.3.1 "Data Maintenance" menu
7. 3.2 "query" menu
7.3.3 "borrow record" menu
7.4 data maintenance module
7.4.1 "member information" Form
7.4.2 "borrow information" Form
7.4.3 "No. in-store number" Form
7.4.4 "Book information" Form
7.4.5 "revenue" Form
7.5 query module
7.5.1 individual Member borrowing
7.5.2 Book Search
7.6 borrow records
7.6, 1 member borrow books
7.6.2 member book return
7.6.3 borrow books from temporary personnel
7.6.4 return a temporary account
7.7 Management of expired members
7.7, 1 design and view the "expired member" Form
7.7.2 run and view the "expired member" Form
7.8 design the main form code
Conclusion 7.9
Chapter 2 database-based alarm
8.1 Program Design Ideas
8.1.1 System Analysis
8.1.2 function demonstration
8.2 Design Database
8.3 main form design
8.3.1 transparent form
8.3.2 status bar icon
8.3.3 configure the access display alarm
8.3.4 access to the system time calibration module
8.3.5 access maintenance program parameter setting module
8.3.6 alarm response
8.4 memory index module
8.4.1 design form
8.4.2 module structure
8.4.3 code implementation
8.5 program parameter setting module
8.5.1 form Initialization
8.5.2 fill the list box
8.5.3 preview user selection
8.6 calibration system time module
8.6.1 display system time
8.6.2 modify the system time
8.7 alarm setting module
8.7.1 form Initialization
8.7.2 add an alarm
8.7.3 edit an alarm
8.7.4 delete an alarm
8.8 alarm clock editing Module
8.8.1 form Initialization
8.8.2 play the selected sound
8.8.3 set the execution Program
Conclusion 8.9
Appendix a SQL Query Language
A1 SQL language basics
Common functions in A2 SQL
A3 operate tables and indexes using SQL language
Appendix B database Components
B1 tdataset component
B1.1 Basic Dataset knowledge
B1.2 browse Dataset
B1.3 tdataset bookmarks
B1.4 data maintenance in tdataset
B1.5 tdataset event
B1.6 tTable component
B1.7 tquery component
B1.8 tstoreproc component
B2 data contr01s component page
B2.1 Overview
B2.2 tdb0rld component
B2.3 tdbnavigator component
B2.4 tdbtext component
B2.5 tdbe6it component
B2.6 tdbmemo component
B2.7 tdbimage component
B2.8 tdblistbox component
B2.9 tdbcombobox component
B2.10 tdbchad component
B3 ADO component page
B3.1 fadocon06ction group jtt
B3.2 fadocomidand component
B3.3 TADODataSet component
B4 other common database Components
B4.3 tdatasource component
B4.2 tsession component
B4.3 tdatabase component
Appendix c dao technology
Objects in C1 DAO technology
Methods In C2 DAO technology
C2.1 AppendChunk method
C2.2 Transaction Management Method
C2.3 CREATEWORKSPACE Method
C2.4 creaeeuser Method
C2.5 createdatabase
C2.6 compactdatabase Method
C2.7 creatertabledef Method
C2.8 createquerydef Method
C2.9 createrelation Method
C2.10 createindex Method
C2.11 createpropedy Method
C2.12 cfeatefietd Method
C2.13 seek Method
C2.14 bxecute Method