mysql 通讯录_基于MySQL版本的通讯录 | 术与道的分享

#include

#include

#include

#include

#include

#define SIZE 1024

MYSQL mysql;//mysql句柄

void Connect(const char* host,const char* user,const char* passwd,const char* db)

{

mysql_init(&mysql);//初始化

if(!mysql_real_connect(&mysql,host,user,passwd,db,3306,NULL,0))//3306是MySQL的网络端口

{

printf("mysql_real_connect faile\n");

exit(0);

}

printf("mysql connect success\n");

}

//插入

void Insert(const char* msg)

{

if(msg)

{

char buf[SIZE] = "insert into book(name,tel,mail,addr) values";

strcat(buf,msg);

int len = strlen(buf);

//执行成功返回0，失败返回非0

if(mysql_real_query(&mysql,buf,len))

{

printf("mysql_real_query insert faile\n");

return ;

}

printf("Insert success.\n");

}

}

//删除

void Delete(const char* condition)

{

char buf[SIZE] = "delete from book where ";

strcat(buf,condition);

int len = strlen(buf);

//成功返回0，失败返回非0

if(mysql_real_query(&mysql,buf,len))

{

printf("mysql_real_query delete faile\n");

return ;

}

<