我想将连接器用于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");