c++ codeblocks连接mysql_c++ code blocks 配置 mysql5.7

#include#include

using namespacestd;const char HOST[]="localhost";const char USERNAME[]="root";const char PASSWORD[]="1234";const char DATABASE[]="webcat";void query_sql(char*sql)

{

MYSQL my_connection;/*这是一个数据库连接*/

int res; /*执行sql語句后的返回标志*/MYSQL_RES*res_ptr; /*指向查询结果的指针*/MYSQL_FIELD*field; /*字段结构指针*/MYSQL_ROW result_row;/*按行返回的查询信息*/

int row, column; /*查询返回的行数和列数*/

inti, j;/*初始化mysql连接my_connection*/mysql_init(&my_connection);/*建立mysql连接*/

if (NULL != mysql_real_connect(&my_connection, HOST, USERNAME, PASSWORD,

DATABASE,0, NULL, 0)) /*连接成功*/{

printf("数据库查询query_sql连接成功！\n");/*设置查询编码为gbk，以支持中文*/mysql_query(&my_connection, "set names gbk");

res= mysql_query(&my_connection, sql);

cout<< "res =" << res <