c++ 怎么样利用 mysql++ 连接 mysql 在linux 下

来源:百度知道 编辑:UC知道 时间:2024/05/10 09:43:49

下面有一个用GCC编译的例子希望对你有所帮助.
#include<stdio.h>
#include<mysql.h>
int main()
{
/*declare structures and variables */
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW row;

//initialize MYSQL structure
mysql_init(&mysql);

//connect to database
mysql_real_connect(&mysql,"localhost","john","doe","db1",0,null,0);

//execute query
mysql_query(&mysql,"select title,author from books");

//get result set
result=mysql_store_result(&mysql);

//process result set
while((row=mysql_fetch_row(result))
{
fprintf(stdout,"%s - %s\n",row[0],row[1]);
}

//clean