c++-C++连接mysql数据库时，用getString()方法总是出错_动视

c++-C++连接mysql数据库时，用getString()方法总是出错

2020-11-09 16:53:24 责编:小采

 #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"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/tree", "root", "123"); cout << "连接成功" << endl; } catch (...) { cout << "连接失败" << endl; } sql::Statement* stat = conn->createStatement(); stat->execute("set names 'gbk'"); ResultSet *res; res = stat->executeQuery("SELECT * FROM testuser"); while (res->next()) { cout << "Id :" << res->getInt("id") << endl; cout << "Name :" << res->getString("name") << endl; //cout << "Address :" << res->getString("address") << endl; } if (conn != 0) { delete conn; } system("pause");}

为此我创建了一个数据库tree和表testuser：

create database tree;use tree;create table testuser(id INT(4) PRIMARY KEY,name CHAR(25),address varchar(45));desc testuser;insert into testuser values(1,'Tom','China Beijing'),(2,'Amy','America NewYork');select*from testuser;

准备工作都做好了，然后就开始执行：
问题来了：

下载本文

显示全文

全部频道