我想将连接器用于mysql数据库。我正在关注此页面

http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html

但是似乎很难。还有其他教程吗?请告诉我。

最佳答案

示例代码的相关部分非常简单:

     Driver *driver;
     Connection *con;
     Statement *stmt;
     ResultSet *res;

    driver = get_driver_instance();

    /* create a database connection using the Driver */
    con = driver -> connect(url, user, password);

    /* alternate syntax using auto_ptr to create the db connection */
    //auto_ptr  con (driver -> connect(url, user, password));

    /* turn off the autocommit */
    con -> setAutoCommit(0);

    /* select appropriate database schema */
    con -> setSchema(database);

从那里开始,您只需要像这样查询它:
     stmt = con -> createStatement();

     res = stmt -> executeQuery ("SELECT * FROM City");

10-07 19:32
查看更多