SQL C ++ Automatic Code Generator (sql2class) Introduction-newzai's column-blog channel-csdn. net

SQL C ++ Automatic Code Generator (sql2class) Introduction-newzai's column-blog channel-csdn. net

SQL C ++ Automatic Code Generator (sql2class) Category: Unix/Linux C/C ++/VC Read by 941 Comment (0) Favorites Report Sqlclassc ++ database API database Problems

Sql2class is a tool used to convert database tables into a C ++ object. It is used together with odbcwrapped and mysqlwrapped object-oriented database interface encapsulation libraries.

 

Odbcwrapped uses the C ++ class to encapsulate windows obdc API calls.

Mysqlwrapped uses the C ++ class to encapsulate MySQL c api calls.

 

Both databases use unified interfaces. SimplifiedProgramMaster database API operations when developing database-related applications. When many database operation APIs on Windows, such as ADO, Dao, and obdc, as well as the C APIs provided by MySQL and the numerous APIs provided by other databases are implemented, when you want to learn a lot of the same repeated knowledge, be depressed. warpped and sql2class are your savior.

 

They can save at least 1/3 of your development time.

 

Warpped:

Database Class: strictly speaking, it should be a database connection pool object. Manage the TCP connector between the client and the database server.

Query: used to execute SQL query statements, including select, update, and delete. All Database statements supported by SQL standards.

Query requires a datadase object. Each time you execute an SQL operation, a database connection object is requested from the connection pool managed by the database object and related database operations are performed. Then release the connection (instead of disconnecting, return to the connection pool managed by the database object and reuse it again ).

 

 

Sql2calss generates database table Objects Based on warpped, further encapsulating database APIs, so that programmers can face the Objects represented in each database table, rather than the C APIs of those database operation statements that are not afraid of the hay. Sometimes you need to know some simple SQL statements. The classes provided by warpped need to be used for multi-table queries and operations. At this time, the classes generated by sql2class are powerless or inefficient.

 

Applicable scope:

It is used for developing ODBC-driven databases in windows, such as MySQL and MSSQL. Acces-any ODBC driver is supported.

MySQL c api if there are no drivers such as obdc in Linux, currently only MySQL is supported

SQLite is a file database of the same type as Microsoft Access.

Source code and more detailed reference information: http://www.alhem.net/project/sql2class/index.html

 

 

Note: It is best to re-compile the database on different CPUs (the same operating system); otherwise, some inexplicable problems may occur.