该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
如题,可以写个简单的列子吗,我的总是报错?下面是我的测试代码
#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;
}