linux学习笔记
bitscn.com linux下c++/c连接mysql数据库(三)--处理返回数据一、通过返回结果集中的字段数unsigned int mysql_field_count(mysql * connection);//将mysql_row的值作为一个存储了一行数据的数组...
示例：
//一次取一个值的情况，另一种情况与其类似，修改处会标出#include #include #include #include using namespace std;void mysql_err_function(mysql * connection);void mysql_display(mysql * mysql,mysql_row sqlrow);int main(){ mysql * connection; connection = mysql_init(null); if (mysql_real_connect(connection,localhost,root,123456,test,0,null,0)) { cout << connection to mysql server is succeed... << endl; string query = select * from tmp15; //getline(cin,query); int res = mysql_query(connection,query.c_str()); if (res) { mysql_err_function(connection); } else { mysql_res * my_res = mysql_use_result(connection); //将mysql_use_result改为mysql_store_result即可得到另一种情况的结果（其实是相同的...） if (my_res) { mysql_row sqlrow; while ((sqlrow = mysql_fetch_row(my_res))) { mysql_display(connection,sqlrow); } mysql_free_result(my_res); } else { mysql_err_function(connection); } } mysql_close(connection); cout << connection to mysql server is closed! << endl; } else { mysql_err_function(connection); }}void mysql_err_function(mysql * connection){ if (mysql_errno(connection)) { cout << error << mysql_errno(connection) << : << mysql_error(connection) << endl; exit(-1); }}void mysql_display(mysql * mysql,mysql_row sqlrow){ for (unsigned int i = 0; i < mysql_field_count(mysql); ++i) { printf(%s ,sqlrow[i]); //cout << sqlrow[i] << ' '; //不知到为什么将printf换成cout之后，打印值就会出错...思考ing... } cout << endl;}
二、获取一个字段的信息1、mysql_field *mysql_fetch_field(mysql_res *result); 2、mysql_field定义：typedef struct st_mysql_field{ char *name; /* name of column */ char *table; /* table of column if column was a field */ char *org_table; /* org table name if table was an alias */ char *db; /* database for table */ char *def; /* default value (set by mysql_list_fields) */ unsigned long length; /* width of column */ unsigned long max_length; /* max width of selected set */ unsigned int flags; /* div flags */ unsigned int decimals; /* number of decimals in field */ enum enum_field_types type; /* type of field. se mysql_com.h for types *