快捷導航

Mysql 插入中文及中文查詢 (修改+調(diào)試)

更新時間：2009年07月09日 14:29:19 作者：

此程序從pudn上下載，但源程序編譯都通不過，同時又有致命錯誤，

//我修改之，能正常運行，測試環(huán)境為mysql5.0,xp
//關(guān)鍵是設(shè)置對字符集，設(shè)置gbk,gb2312測試通過,utf8測試未通過
//在運行程序前先建立數(shù)據(jù)庫jj,注意下面幾個參數(shù)(修改為你自己的)

復制代碼代碼如下:

 
// 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; 
} 
///////////////子函數(shù) 
int connDB()//連接數(shù)據(jù)庫 
{ 
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 ) ; //鏈接到服務(wù)器 
mysql_set_character_set(mysql,"gb2312"); //設(shè)置字符集 
cout<<"conn OK!"<<endl; 
return 0; 
} 
//關(guān)閉數(shù)據(jù)庫 
int disconnDB() 
{ 
mysql_close( mysql ) ; 
cout<<"disconn OK!"<<endl; 
return 0 ; 
} 
//創(chuàng)建表 
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; 
} 