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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.