一、下载并完全安装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 <stdio.h>
- #include <winsock.h>
- #include <mysql.h>
- //写这句或者在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;
- }