codeblocks mysql_在windows上怎么用CodeBlock和Mysql Connect c++连接mysql数...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

如题，可以写个简单的列子吗，我的总是报错？下面是我的测试代码

#include

#include

#include

#include

#include

using namespace sql;

using namespace std;

void RunConnectMySQL()

{

mysql::MySQL_Driver *driver;

Connection *con;

Statement *state;

ResultSet *result;

// 初始化驱动

driver = sql::mysql::get_mysql_driver_instance();

// 建立链接

con = driver->connect("tcp://127.0.0.1:3306", "root", "root");

state = con->createStatement();

state->execute("use test");

// 查询

result = state->executeQuery("select * from student where id < 1002");

// 输出查询

while(result->next())

{

int id = result->getInt("ID");

string name = result->getString("name");

cout << id << " : " << name << endl;

}

delete state;

delete con;

}

int main(int argc, char* argv[])

{

RunConnectMySQL();

getchar();

return 0;

}