Write a program to use the three-tier architecture.
Development Environment: windows7 + Delphi xe7 bcbxe7
The server is BCB and the client is Delphi. The server is transferred from the Delphi code.
Firedac, realthinclientsdk_v628_2013q4bcb, JSON
Transmission Security: minimize transmission packets.
The Local Machine queries 10 million data records. The 4 fields are less than 5 seconds. 1 million data records are completed within 1 second.
Multi-data multi-client program source code:
1. client and server authentication
Use the verification mechanism to query the login account from the verification database.
Single, combined with the Web user management center will be more convenient.
Ii. About Images
This is also relatively simple. After all, it is a demo. You do not need to use a remote function to process the upload.
, Refer to the editing process in the right-click menu of the photo,
Can be submitted together with age.
Iii. Multi-Table query and update of multiple tables
Multiple tables can be submitted at the same time to reduce network transmission volume and improve stability and data consistency.
And improve the client's data processing capabilities.
4. Security. The master is on the server side, and the client does not need to generate SQL to send to the server.
In fact, this example can meet the needs of three-tier projects with multiple databases and multiple users of different database types.
.
Other details:
You can configure the database type in the verification database to support MySQL MSSQL and paging (only simple paging is supported ).
The above is a demo program example,
If necessary, contact QQ 364944662 to purchase the source code.
Delphi BCB layer-3 architecture source code