How to Use Delphi Multi-Tier Database Application Code Generator

王朝delphi·作者佚名  2006-05-22
窄屏简体版  字體: |||超大  

Delphi Multi-Tier Database Application Code Generator 0.9

--Bear,.11.25

DMPCG is a FREE code generator for Delphi developers.

When developing MIDAS project, we need develop the Application Server and Client Application.

We need put Dataset component and Provider components for each table on Application Server side.

We need put ClientDataSet and DataSource components for each table on Client application side.

We need put DataAware components for each table and field on Client application side too.

We need give each component a readable name regarding its table name or field name.

If you have a lot of tables in database to deal with, it may take you several days.

DMDACG can do all of these work for you in several minutes.

The more tables you have, the more time it save for you.

How does DMDACG work?

=====================

1. Copy project template directory to output directory.

2. Connect to database via UDL file or connect to Access MDB file directly.

3. Replace the variable block in template and insert some code blocks:

On Server Side:

A. Each table will have a DataSet and DataSetProvider components in RemoteDataModule

B. Each DataSet will have persist field components.

The first field will be looked as Primary Key.

On Client Side:

A. Each DataSet will have persist field components.

The first field will be looked as Primary Key.

If the filedname is like *ID, we guess it is a Foreign Key, there will be a DBLookupComboBox for it.

B. Each table will have a form with DBGrid for the table and DBEdit components and Label components for each field.

C. There will be a form to hold all of the DBGrid components.

4. All of the component will be named well by the table name or field name.

For example : Client_Frm, Client_DBGrid, Client_DBEdt, Client_Lab, etc.

5. You can change all of the default name format strings in NameFormat.ini

How to Use the DMDACG?

======================

1. Select template directory, you can select the default template directory: \MidasProject

In fact you can edit the code in template directory to add more functions.

2. Select output directory

3. Select UDL file or mdb file

You can also edit the database.udl and let it point to your own database,

And then select the UDL file.

4. Select FieldName and DisplayText Map File, it is a text file. (Optional)

If you use PowerDesigner to design the database, you can copy the field names and codes from the data item list to a text file.

5. Change other options. (Optional)

6. Click "Generate Project Source Code" button.

How to Use the output projects?

===============================

There will be two projects in the output directory.

One is for application server and another is for client GUI application.

1. Open the Application Server Project, run it to register the Remote Data Module COM.

Then close it.

If there is a "Database.mdb" file, The RDM will use it as the database, or it will use

"DataBase.udl" file as the data connection file to connect to database. See the source code.

2. Open the Client GUI Project, open DataModule, select the ServerName from the CombboBox for the DCOM Connection.

By default, the Connection Broker use DCOMConnection because it is handy to debug.

You can use other connection too.

And there is a Config.ini file in Exe directory.

The client will read it at runtime to decide use which connection. (DCOMConnection,SockectConnection or WebConnection)

3. Run the Client GUI Project,

you can edit the the data and post for each table now!

4. Redesign the forms or copy and paste these components to your own forms.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航