#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();
}