| 标题 | 在mysql数据库插入中文及中文查询实例教程 |
| 内容 | //我修改之，能正常运行，测试环境为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; } |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。