vc mysql断线自动连接_VC连接mysql，笔记

一、下载并完全安装mysql(用VC连接需完全安装)

二、新建控制台工程，进行如下设置：

1.  菜单：Tools->Options->Directories

选：Show directories for: Include files

添加:Directories: D:/Program Files/mysql/mysql server5.1/include

2.  菜单：Tools->Options->Directories

选：Show directories for: Library files

添加:Directories: D:/Program Files/mysql/mysql server5.1/lib/debug

3. 菜单：Projuct->Settings->Settings For: All configures

选项卡选：Link

Object/library modules:  行尾添加 libmysql.lib

三、编写代码：

#include

#include

#include

//写这句或者在Project->Setings里设置

#pragma comment(lib,"libmysql.lib")

bool MySQL_Select(MYSQL);

int main()

{

puts("Hello Mysql");

MYSQL mysql; //数据库连接句柄

mysql_init (&mysql);

//连接数据库

//MYSQL *mysql_real_connect(MYSQL *mysql,char *host,char *user,char *passwd,char *db,int port,char *unix_socket,int client_flag)

if(!mysql_real_connect(&mysql,"59.74.166.41","cc","gshcc","test",3306,NULL,0))

{

puts("数据库连接失败");

return FALSE;

}

puts("连接成功,查询结果：");

MySQL_Select( mysql);

//数据库插入操作

char strSQL[100]="insert into student values(/'0808010205/',/'呆鸟/',22,/'陕西,西安/')";

if(mysql_real_query(&mysql, strSQL, strlen(strSQL)))

{

puts("添加失败！");

}

puts("添加成功,查询结果：");

MySQL_Select( mysql);

//数据库修改操作

char *pSQL=strSQL;

pSQL="update student set name=/'死呆鸟/' where ID=/'0808010205/'";

if(mysql_real_query(&mysql, pSQL, strlen(pSQL)))

{

puts("修改失败！");

}

puts("修改成功,查询结果：");

MySQL_Select( mysql);

//数据库删除操作

pSQL="delete from student where ID=/'0808010205/'";

if(mysql_real_query(&mysql, pSQL, strlen(pSQL)))

{

puts("删除失败！");

}

puts("删除成功,查询结果：");

MySQL_Select( mysql);

mysql_close(&mysql);

return 0;

}

bool MySQL_Select(MYSQL mysql)

{

MYSQL_RES *result; //查询结果

MYSQL_ROW col; //索引每一字段

char *ch_query="select * from student";

if(mysql_real_query(&mysql,ch_query,strlen(ch_query)))

{

puts("数据库中表格出错");

}

if(!(result=mysql_use_result(&mysql)))

{

puts("读取数据集失败");

return false;

}

int i=0;

puts(" 学号 /t /t 姓名/t/t年龄/t/t 住址");

while(col=mysql_fetch_row(result))

{

printf("%10s/t",col[0]);

printf("%10s/t",col[1]);

printf("%4s",col[2]);

printf("%20s/t",col[3]);

putchar(10);

i++;

}

putchar(10);

return true;

}