4,018
社区成员




#include<iostream>
#include<cstdlib>
#include<string>
#include<mysql/mysql.h>
using namespace std;
MYSQL *conn;
MYSQL_RES *rs;
MYSQL_ROW fields;
int main(int argc, char *argv[])
{
string host;
string user;
string pwd;
string db_name;
string sql;
conn = mysql_init(NULL);
if(conn==NULL){
printf("Initialization connection fail.\r\n");
return 1;
}
printf("Initialization connection OK.\r\n");
host = "127.0.0.1";
user = "root";
pwd = "123456";
db_name = "testdb";
conn = mysql_real_connect(conn, host.c_str(),user.c_str(), pwd.c_str(), db_name.c_str(), 0, NULL, 0);
if(conn==NULL){
printf("Connection database fail.\r\n");
return 1;
}
printf("Connection database OK.\r\n");
sql = "SELECT * FROM `users`";
if(mysql_query(conn, sql.c_str())){
printf("exec search fail.\r\n");
mysql_close(conn);
return 1;
}
rs = mysql_use_result(conn);
fields = mysql_fetch_row(rs);
printf("fields 3:%s\r\n",fields[3]);
mysql_free_result(rs);
mysql_close(conn);
return 0;
}