首页 新闻 搜索 专区 学院

vs2017执行mysql语句问题

0
悬赏园豆:5 [待解决问题]

有关代码如下:
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)
Riang的主页 Riang | 初学一级 | 园豆:19
提问于:2019-02-16 18:27
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册