/*
* test.cpp
*
* Created on: 2010-5-13
* Author: Sarah
*/
#include "/usr/include/mysql/mysql.h" /*为绝对路径*/
#include <stdio.h>
#include <stdlib.h>
#include <string>
#include <iostream>
using namespace std;
int main(int argc,char *argv[])
{
char *user = "root", *pwd = "475475", *dbname = "bookman";
MYSQL mysql;
MYSQL_RES *mysql_ret;
MYSQL_ROW mysql_row;
unsigned long num_rows;
int ret;
mysql_init(&mysql);
if(mysql_real_connect(&mysql,NULL,user,pwd,dbname,0,NULL,0))
{
printf("Connection success!/n");
//sql字符串
string sqlstr;
sqlstr ="INSERT INTO booklist VALUES (3,'friend','Jack',2,1);";
if(0==mysql_query(&mysql,sqlstr.c_str()))
{
cout<<"mysql_query() insert data succeed"<<endl;
}
else
{
cout<<"mysql_query() insert data failed"<<endl;
return -1;
}
ret = mysql_query(&mysql,"select * from booklist");
if(!ret)
{
printf("Query Success!/n");
mysql_ret = mysql_store_result(&mysql);
if(mysql_ret != NULL)
{
printf("Store Result Success!/n");
num_rows = mysql_num_rows(mysql_ret);
if(num_rows != 0)
{
printf("%d/n",num_rows);
while(mysql_row = mysql_fetch_row(mysql_ret))
{
printf("%s/t%s/t%s/t%s/t%s/n",mysql_row[0],mysql_row[1],mysql_row[2],mysql_row[3],mysql_row[4]);
}
}
else
{
printf("mysql_num_rows Failed!/n");
exit(-1);
}
mysql_free_result(mysql_ret);
exit(0);
}
else
{
printf("Store Result Failed!/n");
exit(-1);
}
}
else
{
printf("Query Failed!/n");
exit(-1);
}
}
else
{
printf("Connection Failed/n");
exit(-1);
}
}
c++ mysql
最新推荐文章于 2024-07-20 22:49:13 发布