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

此程序从pudn上下载，但源程序编译都通不过，同时又有致命错误，

// char *host = "localhost"; 
// char *user = "root"; 
// char *pass = "674800"; 
// char *db = "jj"; 
#include  
#include  
#include  
#include  
#include  
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!"<return 0; 
} 
//关闭数据库 
int disconnDB() 
{ 
mysql_close( mysql ) ; 
cout<<"disconn OK!"<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:"<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:"<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_close( mysql ) ; 
return FALSE ; 
} 
res = mysql_store_result( mysql) ; 
i = (int) mysql_num_rows( res ) ; 
cout<<"Query: "<for ( i = 0 ; fd = mysql_fetch_field( res ) ; i++ ) 
cout<name<<"\t"; 
cout<while(row = mysql_fetch_row( res )) 
cout<mysql_free_result( res ) ; 
cout<<"select OK!"<return 0; 
} 
 
我机器上的运行结果：