vs2010 读取mysql数据库_vs2010连接mysql数据库进行查询修改操作 c++

#include#include#include#include#include#include

using namespacestd;char *user="root"; //用户名

char *pass="jiangshan"; //密码

char *db="jiang"; //所用的数据库

unsigned int port =3306; //MYSQL mydata;

MYSQL_RES*res;

MYSQL_FIELD*fd;

MYSQL_ROW row;stringSqlText;boolshow();boolinsert();boolchange();boolfind();stringfindbyid();boolfindbyname();bool changename(stringid);bool changesex(stringid);intmain()

{if (0!=mysql_library_init(0,NULL,NULL))

{

cout<

}if (NULL==mysql_init(&mydata))

{

cout<

}if (NULL==mysql_real_connect(&mydata,"",user,pass,db,port,NULL,0))

{

cout<

}

SqlText="create table if not exists stu";

SqlText+="(id int(10) primary key auto_increment,name char(30) not null,sex tinyint(1) default 0) default character set utf8 engine myisam;";if (0!=mysql_query(&mydata,SqlText.c_str()))

{

cout<

}while(1)

{

cout<

cout<

cout<

cout<

cout<

cout<

cout<

cin>>i;switch(i)

{case 1:

SqlText="select * from stu;";

show();break;case 2:

insert();break;case 3:

change();break;case 4:

find();break;default:return 0;

}

}return 0;

}//从表中读取所有的数据

boolshow()

{

cout<

{

cout<

}

res=mysql_store_result(&mydata);int rowcount =mysql_num_rows(res);

unsignedint fieldcount =mysql_num_fields(res);

MYSQL_FIELD*field =NULL;//打印个字段名称

for(int i=0;i

{

field=mysql_fetch_field_direct(res,i);

cout<name<

}

cout<

row=mysql_fetch_row(res);while (NULL!=row)

{for (int i=0;i

{

cout<

}

cout<

row=mysql_fetch_row(res);

}

cout<

}//插入数据

boolinsert()

{stringname;

cout<

cin>>name;stringsex;

cout<

cin>>sex;

SqlText="insert into stu(name,sex) values('";

SqlText+=name;

SqlText+="',";

SqlText+=sex;

SqlText+=");";//SqlText="insert into stu(name,sex) values('haha',1);";//这个是范例，字符串必须用 ' ' 串起来

if(0!=mysql_query(&mydata,SqlText.c_str()))

{

cout<

}return true;

}//查找

boolfind()

{

cout<

cout<

cout<

cout<

cout<

cin>>i;switch(i)

{case 1:

a=findbyid();break;case 2:

findbyname();break;default:return false;

}

cout<

}stringfindbyid()

{

cout<

cin>>id;

SqlText="select * from stu where id=";

SqlText+=id;

SqlText+=";";

show();returnid;

}boolfindbyname()

{

cout<

cin>>name;

SqlText="select * from stu where name ='";

SqlText+=name;

SqlText+="' ;";//SqlText="select * from stu where name ='jiang';";

show();return true;

}//修改

boolchange()

{string id=findbyid();

cout<

cout<

cout<

cin>>i;switch(i)

{case 1:

changename(id);break;case 2:

changesex(id);break;default:return false;

}return true;

}bool changename(stringid)

{

cout<

cin>>name;

SqlText="update stu set name='";

SqlText+=name;

SqlText+="' where id=";

SqlText+=id;

SqlText+=";";if(0!=mysql_query(&mydata,SqlText.c_str()))

{

cout<

}

SqlText="select * from stu where id=";

SqlText+=id;

SqlText+=";";

show();return true;

}bool changesex(stringid)

{

cout<

cin>>sex;

SqlText="update stu set sex=";

SqlText+=sex;

SqlText+="where id=";

SqlText+=id;

SqlText+=";";if(0!=mysql_query(&mydata,SqlText.c_str()))

{

cout<

}

SqlText="select * from stu where id=";

SqlText+=id;

SqlText+=";";

show();

}