有关代码如下:
try {
sql::Driver driver;
sql::Connection con;
sql::Statement stmt;
sql::ResultSet res;
/* 创建连接 */
driver = get_driver_instance();
con = driver->connect("tcp://localhost:3306", "root", "");
/* 连接 MySQL 数据库 test */
con->setSchema("test");
stmt = con->createStatement();
cout << "表名" <<sqlfilename << endl;
/*指定的图片创建相应的表*/
sprintf_s(SqlCreate, "create table %s (id int auto_increment primary key, data float(11,5));", &sqlfilename);
cout << "执行" << SqlCreate << endl;
sql::SQLString sqlcreate = SqlCreate;
res = stmt->executeQuery(sqlcreate);
cout << "创建成功" << endl;
delete res;![](https://img2018.cnblogs.com/q/1600529/201902/1600529-20190216182705810-558616296.png)
delete stmt;
delete con;
}
catch (sql::SQLException &e) {
cout << "# ERR: SQLException in " << __FILE__;
cout << "(" << __FUNCTION__ << ") on line " << __LINE__ << endl;
cout << "# ERR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() << " )" << endl;
}![](https://img2018.cnblogs.com/q/1600529/201902/1600529-20190216182804550-1082966589.png)