测试代码如下,就是database.cpp
#include <iostream>
#include <stdlib.h>
#include "mysql.h"using namespace std;int main() { MYSQL mysql;
MYSQL_ROW row;
MYSQL_RES *result=NULL; unsigned int num_rows=0;
unsigned int num_fields=0; char* host="2001:250:f007:1:20c:29ff:fe1f:ccb2"; //localhost ipv6 address
char* user="mzf";
char* pass="123456";
char* db="mysql"; const char* sql="select * from user"; mysql_init(&mysql);
if (!mysql_real_connect(&mysql,host,user,pass,db,0,NULL,0))
{
cout<<"Fail to connect to database"<<endl;
return -1;
} if (mysql_query(&mysql,sql) != 0)
{
cout<<"Query fails"<<endl;
return -1;
}
else
{
result = mysql_store_result(&mysql);
num_fields = mysql_num_fields(result);
num_rows = mysql_num_rows(result);
while ((row=mysql_fetch_row(result)))
{
for (unsigned int i=0; i<num_fields; i++)
{
if (row[i])
cout<<row[i]<<" ";
else
cout<<"NULL"<<" ";
}
cout<<endl;
} mysql_free_result(result);
result=NULL;
}
mysql_close(&mysql); return 1;
}
#include <iostream>
#include <stdlib.h>
#include "mysql.h"using namespace std;int main() { MYSQL mysql;
MYSQL_ROW row;
MYSQL_RES *result=NULL; unsigned int num_rows=0;
unsigned int num_fields=0; char* host="2001:250:f007:1:20c:29ff:fe1f:ccb2"; //localhost ipv6 address
char* user="mzf";
char* pass="123456";
char* db="mysql"; const char* sql="select * from user"; mysql_init(&mysql);
if (!mysql_real_connect(&mysql,host,user,pass,db,0,NULL,0))
{
cout<<"Fail to connect to database"<<endl;
return -1;
} if (mysql_query(&mysql,sql) != 0)
{
cout<<"Query fails"<<endl;
return -1;
}
else
{
result = mysql_store_result(&mysql);
num_fields = mysql_num_fields(result);
num_rows = mysql_num_rows(result);
while ((row=mysql_fetch_row(result)))
{
for (unsigned int i=0; i<num_fields; i++)
{
if (row[i])
cout<<row[i]<<" ";
else
cout<<"NULL"<<" ";
}
cout<<endl;
} mysql_free_result(result);
result=NULL;
}
mysql_close(&mysql); return 1;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货