22,210
社区成员
发帖
与我相关
我的任务
分享
#include <iostream>
#include <mysql++.h>
using namespace std;
int main()
{
const char* db = "aries_role", *server = "127.0.0.1", *user = "root", *pass = "123456";
mysqlpp::Connection conn(false);
// 连接数据库
if (conn.connect(db, server, user, pass))
{
// 从role表中查找ID为99的角色
mysqlpp::Query query = conn.query("select * from role where id = 99");
mysqlpp::StoreQueryResult resu = query.store();
int nRows = resu.num_rows();
if (nRows > 0)
{
cout<<nRows<<endl;
cout<<resu.size()<<endl;
}
else
{
std::cout << "Failed to get item list: " << query.error() << endl;
}
}
return 0;
}