问

使用c++返回mysql中的varchar类型数据，resultset的getString方法返回该数据报错

严气发布于 2022-10-31 17:51

mysql

1、使用c++返回mysql中的varchar类型数据，resultset的getString方法返回该数据报错,使用try catch语句显示为bad allocation.
2、代码：

#include 
#include 
#include 
#include 
#include "mysql_driver.h"
#include "mysql_connection.h"
#include "cppconn/driver.h"
#include "cppconn/statement.h"
#include "cppconn/prepared_statement.h"
#include "cppconn/metadata.h"
#include "cppconn/exception.h"
#include 

using namespace std;
using namespace sql;

int main()
{
    sql::mysql::MySQL_Driver *driver = 0;
    sql::Connection *conn = 0;
    try
    {
        driver = sql::mysql::get_mysql_driver_instance();
        conn = driver->connect("tcp://localhost:3306/jwsystem", "root", "123456");
        cout << "succeed!" << endl;
    }
    catch (...)
    {
        cout << "fail!" << endl;
    }
    sql::Statement* stat = conn->createStatement();
    stat->execute("set names 'gbk'");
    ResultSet *res;
    res = stat->executeQuery("select * from semester");
    while (res->next())
    {
        try{
            string s = "_semester";
            cout << "semester\t:" << res->getString(s) << endl;

        }
        catch (exception e)
        {
            cout<< e.what();
        }

    }
    if (conn != 0)
    {
        delete conn;
    }
    system("pause");
}

3、

撰写答案

今天，你开发时遇到什么问题呢？

立即提问

热门标签