Mysql 插入中文及中文查询 (修改+调试)

时间:2022-03-06 03:03:29

//我修改之,能正常运行,测试环境为mysql5.0,xp 
//关键是设置对字符集,设置gbk,gb2312测试通过,utf8测试未通过 
//在运行程序前先建立数据库jj,注意下面几个参数(修改为你自己的) 

复制代码代码如下:


// char *host = "localhost"; 
// char *user = "root"; 
// char *pass = "674800"; 
// char *db = "jj"; 
#include <windows.h> 
#include <iostream> 
#include <mysql.h> 
#include <stdio.h> 
#include <string.h> 
using namespace std; 
#pragma comment(lib,"libmysql.lib") 
int connDB(); 
int create_table(); 
int insert_table(); 
int select_table(); 
int disconnDB(); 
MYSQL *mysql; 
MYSQL_RES *res; 
MYSQL_FIELD * fd; 
MYSQL_ROW row; 
char szSqlText[500]=""; 
int i; 
int main() 

connDB(); 
// create_table(); 
insert_table(); 
select_table(); 
disconnDB(); 
return 0; 

///////////////子函数 
int connDB()//连接数据库 

char *host = "localhost"; 
char *user = "root"; 
char *pass = "674800"; 
char *db = "jj"; 
mysql = mysql_init((MYSQL*) 0); 
mysql_real_connect( mysql, host, user, pass, db,3306, NULL, 0 ) ; //链接到服务器 
mysql_set_character_set(mysql,"gb2312"); //设置字符集 
cout<<"conn OK!"<<endl; 
return 0; 

//关闭数据库 
int disconnDB() 

mysql_close( mysql ) ; 
cout<<"disconn OK!"<<endl; 
return 0 ; 

//创建表 
int create_table() 

mysql_set_character_set(mysql,"gb2312"); 
sprintf(szSqlText, \ 
"create table mytable \ 
(s0 varchar(100), \ 
s1 char(6),\ 
s2 varchar(4),\ 
s3 varchar(3),s4 int)\ 
ENGINE=InnoDB \ 
DEFAULT CHARSET=gb2312"); 
if(mysql_query( mysql, szSqlText)) 
cout<<"occurred an error:"<<mysql_error(mysql)<<endl; 
return 0; 

int insert_table() 

mysql_set_character_set(mysql,"gb2312"); 
sprintf(szSqlText, 
"insert into mytable\ 
values('2000-3-10 21:01:30',\ 
'Test',\ 
'清风寒剑',\ 
'岁月情',\ 
2500)"); 
if( mysql_query( mysql, szSqlText) ) 
cout<<"occurred an error:"<<mysql_error(mysql)<<endl; 
return 0; 

int select_table() 

mysql_set_character_set(mysql,"gb2312"); 
sprintf(szSqlText, "select * from mytable "); 
if (mysql_query( mysql, szSqlText)) 

cout<<"occurred an error:"<<mysql_error(mysql)<<endl; 
mysql_close( mysql ) ; 
return FALSE ; 

res = mysql_store_result( mysql) ; 
i = (int) mysql_num_rows( res ) ; 
cout<<"Query: "<<szSqlText<<"\n"<<i<<" records found:"<<endl; 
for ( i = 0 ; fd = mysql_fetch_field( res ) ; i++ ) 
cout<<fd->name<<"\t"; 
cout<<endl; 
while(row = mysql_fetch_row( res )) 
cout<<row[0]<<"\t"<<row[1]<<"\t"<<row[2]<<"\t"<<row[3]<<"\t"<<row[4]<<endl; 
mysql_free_result( res ) ; 
cout<<"select OK!"<<endl; 
return 0; 


我机器上的运行结果: 
Mysql 插入中文及中文查询 (修改+调试)
Mysql 插入中文及中文查询 (修改+调试)