037_delphi7 efficient database program design

Delphi7 efficient database program design

DelphiTutorial Series of books(037)《Delphi7Efficient database program design Organize netizens (state)Email:Shuaihj@163.com

:

Source code of the PDF attachment

• Author: Li Wei
• Series name: Li Wei works Series
• Press: Machinery Industry Press
• ISBN: 7111112261
• Mounting time: 2002-12-24
• Published on: February 1, January 2003
• Start: 16
• Page number: 412
• Version: 1-1

Introduction

Dbexpress is Borland's next-generation data access technology. This book not only introduces dbexpress's basic functions, usage skills, and Delphi/kylix datasnap technology, but also discusses in detail the implementation principles of dbexpress and the future development trend of dbexpress. This book has a clear structure, a thorough explanation, and rich examples. Li Wei, a famous technical expert of Borland, has published many famous Delphi books. By reading this book, readers can make full use of the powerful functions of dbexpress to develop an efficient Delphi/kylix system. This book is suitable for Delphi/kylix/C ++ builder programmers, database programmers, and those interested in Delphi/kylix.

Preface

Since the launch of Delphi, all-round functions of Delphi have made many programmers talk about it. Delphi's powerful and flexible database capabilities surprise many database programmers. Delphi's Bde/idapi not only provides reasonable performance, but also can connect different databases, from file-based paradox/DBASE databases to real relational databases (such as Interbase, Oracle, Informix, DB2, and ms SQL Server ), it is very convenient for Delphi programmers to use the same technology to access different data sources. However, with the advancement of software technology and changes in user needs, the data access method has also undergone tremendous changes. From the master-slave architecture application system that previously provided continuous connection to the current batch processing, and the client and database may be in the unconnected state. For example, the current data access technology must meet both the enterprise's master-slave structured application system and the distributed application system that can provide Web access. Although Bde/idapi technology can be used in both applications, Bde/idapi is designed based on the concept of file and master-slave structure, applications based on Web and distributed structures cannot provide efficient and economical usage. Borland wants to meet new user requirements and provide cross-platform capabilities to users using Borland development tools. Borland also introduces the development tool kylix, which is executed on Linux, therefore, Borland must seriously consider developing the next-generation data access technology, because Bde/idapi obviously cannot meet the needs of new applications and provide cross-platform functions. Therefore, dbexpress came into being. Dbexpress is Borland's next-generation data access technology. Dbexpress is designed to provide efficient data access and a data access engine that provides cross-platform capabilities. Since Borland launched dbexpress 1.0 in Delphi 6, dbexpress has developed rapidly. Currently, dbexpress has been able to access many relational databases, including Oracle, Interbase, Informix, DB2, ms SQL Server, My SQL, and postgre SQL. In the future, borland will continue to develop dbexpress drivers for databases such as Sybase. In addition, dbexpress is now able to run on Windows and Linux platforms and will be transplanted to Microsoft. netj2 in the future. Dbexpress in Delphi 7 is version 2.0. Dbexpress 2.0 not only provides more dbexpress drivers, but also modifies many bugs and provides higher performance. Because dbexpress is now better than Bde/idapi, Borland has also announced that it will not update Bde/idapi, but only provide basic maintenance. Therefore, Delphi/kylix/C ++ builder programmers must also use dbexpress to develop new database applications. Unfortunately, although dbexpress provides good functions and efficiency, there are almost no books on the market dedicated to discussing dbexpress technology, it can help programmers develop efficient database application systems by leveraging the functions of dbexpress. This is why I was prompted to write this book. I hope this book will help readers fully master the dbexpress technology. This book not only discusses how to use dbexpress and the datasnap Technology of Delphi/kylix, but also discusses in detail and in depth the advanced technologies of dbexpress, including how to adjust the performance of dbexpress, the implementation principle of dbexpress and the future development of dbexpress allow readers to fully utilize the powerful functions of the dbexpress engine to develop an efficient Delphi/kylix database application system. I have written this book since Delphi 6.0/kylix 1.0, although dbexpress and DA (asnap has a little improvement, however, the contents of this book still apply to Delphi 6/kylix 2.0 and Delphi 7/kylix 3.0. In addition, the author also describes the differences between Delphi 6 and Delphi 7. I would like to thank all my friends who have helped publish this book and the readers for their support. Finally, I hope that the content of this book can help readers quickly enter the world of dbexpfess, and become proficient in Delphi/kylix database application system design after reading it. Thank you.

Directory

Part 1 basic functions of dbexpress

Chapter 2 dbexpress components, concepts, technologies and applications 3

1.1 dbexpress Component 3

1.2 create the first dbexpress database application 4

1.3 use the concept of dbexpress 13

1.4 Use dbexpress to modify data 16

1.4.1 use tsqldataset with tdataset-provider and tclientdataset components 17

1.4.2 use tsimpledataset component 21

1.5 dbexpress driver setting 25

1.6 CONCLUSION 28

Chapter 29 using dbexpress Components

2.1 use the tsimpledataset component 29

2.1.1 using dynamic SQL statements to process data 32

2.1.2 data and Delta features 42

2.1.3 modify data-multiple data tables 45

2.1.4 control the number of data access records-packet-records feature 50

2.2 datasnap technology 54

2.3 use tsqldataset and tsqlquery components 59

2.3.1 use tsqldataset component 59

2.3.2 use tsqlquery component 63

2.3.3 run SQL script 65

2.4 use tsqlstoredproc component 69

2.5 use tsqlmonitor component 74

2.6 Conclusion 78

Chapter 1 more dbexpress skills 81

3.1 Data Sorting 81

3.1.1 dbexpress/datasnap sort 82 by default

3.1.2 use the tsqldataset sorting feature 83

3.1.3 perform dynamic sorting in tsimpledataset 86

3.1.4 factors for sorting 93

3.2 Memory Data Table 98

3.3 Use calculated field 105

3.4 use the aggregate field 109

3.5 updatestatus 111

3.6 savepoint 113

3.7 mybase 115

3.8 at the settext and gettext events of the tfield object

Function 118

3.9 conclusion 124

Part 2 advanced functions of dbexpress

Chapter 4 search data 4th

4.1 search for dataset data 127

4.1.1 location 128

4.1.2 lookup 137

4.1.3 filter 139

4.1.4 set range 147

4.2 comparison of search methods 148

4.3 how to quickly search for data in a dataset 152

4.3.1 analyze the behavior of the Delphi/kylix search result dataset method 153

4.3.2 The data table contains a small amount of data 154

4.3.3 a data table contains a large amount of data 154

4.3.4 rapid data search 155

4.4 Conclusion 168

Chapter 2 advanced technologies of dbexpress 5th

5.1 Transaction Management 171

5.2 database transisolation 175

5.3 error handling 177

5.4 use dbexpress 188 in COM +

5.5 Conclusion 202

Chapter 4 using dbexpress to process complex data types 6th

6.1 tdatasetprovider component 203

6.1.1 handle important events of tdatasetprovider

Functions 204

6.1.2 important features of tdatasetprovider 208

6.1.3 tdatasetprovider example 212

6.2 master-slave applications 215

6.2.1 use components and dbexpress to implement Master/Slave functions 215

6.2.2 use the program code to implement the master-slave function 219

6.3 process multiple data tables 221

6.4 conclusion 232

Chapter 2 dbexpress and Web applications 7th

7.1 Delphi webbroker technology 233

7.2 use dbexpress to develop Web applications 234

7.3 dbexpress and intraweb 262

7.4 conclusion 271

Part 3 advanced dbexpress Technology

Chapter 1 processing Binary large data 8th

8.1 process graphic data 275

8.2 process JPEG image data 279

8.3 how to efficiently process Binary large data 281

8.4 OLE container type data 290

8.5 conclusion 298

Part 4 in-depth practices of dbexpress

Chapter 2 dbexpress and metadata 9th

9.1 dbexpress and metadata 303

9.2 use dbexpress to process metadata 304

9.3 observe how dbexpress uses metadata 321

9.4 conclusion 331

Part 5 performance

Chapter 2 Developing efficient database application systems 10th

10.1 start from testing dbexpress, Bde/idapi, and dbexpress 335

10.1.1 observe one of the execution behaviors of dbexpress 338

10.1.2 observe the execution behavior of dbexpress II 340

10.2 Performance Comparison Between dbexpress and Bde/idapi: 345

10.2.1 database connection speed: 345

10.2.2 access to large amounts of data at a speed of 346

10.2.3 Add a large amount of data 347

10.3 adjust the way dbexpress accesses data 348

10.3.1 adjust the value of packetrecords to 348

10.3.2 change dbexpress's data processing behavior by 349

10.4 fast data query 354

10.5 tsimpledataset 361 after delphi 7

10.6 conclusion 361

Chapter 5 animation, happy 11th

11.1 starting from a seemingly simple scenario 363

11.2 start to brainstorm 374

11.3 second question 374

11.4 conclusion 376

Chapter 2 Data Access Technology 12th

12.1 dbexpress development 379

12.2 BDE status 380

12.3 ADO 380

12.4 optional database 380

12.5 several databases and data access technologies 384

12.6 database and Component Model 384

12.7 conclusion 385

Chapter 2 dbexpress implementation and future development 13th

13.1 dbexpress Implementation Technology 387

13.2 simulate dbexpress workflow 399

13.3 differences between dbexpress implementation 409

13.4 dbexpress implementation and development in the future 410

13.5 conclusion 411