MySQL数据库简单用法

 

#include <Windows.h>
#include <mysql.h> 
#include <iostream>
#include <string.h>


using namespace std;
#pragma comment (lib,"libmysql.lib") 
int main()
{
MYSQL myCont;
int res = 0;
mysql_init(&myCont);
MYSQL_RES *result;
MYSQL_ROW sql_row;
MYSQL_FIELD *fd;
char column[32][32];
if(mysql_real_connect(&myCont,"192.162.4.145","root","root","db",3306,NULL,0))
{
cout<<"db connect succeed!\n";
mysql_query(&myCont,"SET NAMES GBK");//设置编码格式,否则在cmd下无法显示中文
res = mysql_query(&myCont,"select * from sp_admins");
if(!res)
{
result = mysql_store_result(&myCont);
if(result)
{
int i,j;
cout<<"number of result: "<<(unsigned long)mysql_num_rows(result)<<endl;
for(i=0;fd=mysql_fetch_field(result);i++)//获取列名
{
strcpy(column[i],fd->name);
}
j=mysql_num_fields(result);
for(i=0;i<j;i++)
{
printf("%s\t",column[i]);
}
printf("\n");
while(sql_row=mysql_fetch_row(result))//获取具体的数据
{
for(i=0;i<j;i++)
{
printf("%s\n",sql_row[i]);
}
printf("\n");
}

}
}
//res = mysql_query(&myCont,"insert into tmc_db values")
}
return 0;
}