c++ connector
下面是一个示例,世界使用c++ connector时注意release版本和debug版本要和响应的动态库匹配才可以
#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>int main() {// 创建 MySQL Connector/C++ 驱动程序对象sql::mysql::MySQL_Driver *driver;sql::Connection *con;// 初始化驱动程序对象driver = sql::mysql::get_mysql_driver_instance();// 创建连接con = driver->connect("tcp://127.0.0.1:3306", "username", "password");// 连接到数据库con->setSchema("database_name");// 执行查询sql::Statement *stmt;sql::ResultSet *res;stmt = con->createStatement();res = stmt->executeQuery("SELECT * FROM your_table");// 处理结果集while (res->next()) {std::cout << "Column 1: " << res->getString(1) << std::endl;std::cout << "Column 2: " << res->getString(2) << std::endl;}// 释放资源delete res;delete stmt;delete con;return 0;
}