菜鸟一枚,最近项目需要操作数据库,记下连接数据库的过程,不足之处多多关照。
本文以mysql-5.5.28-winx64和vs2015为例:
一:下载安装mysql-5.5.28-winx64
二:配置vs2015
(1)在vs中新建项目,创建原文件test.cpp,打开项目属相—–>c/c++—>常规——>附加包含目录—->添加D:\MySQL\MySQL Server 5.5\include(mysql安装目录下include文件的路径)如图:
(2)配置属性——>链接器—->常规—–>附加库目录—->添加“D:\MySQL\MySQL Server 5.5\lib”
(3)配置属性——>链接器—->输入—–>附加依赖项—->添加“libmysql.lib”
(4)将“libmysql.dll”拷贝到vs项目路径下:
(5)运行测试:
#include <Windows.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql.h>
#include <iostream>
using namespace std;
int main()
{
const char user[] = "root"; //username
const char pswd[] = "123456"; //password
const char host[] = "localhost"; //or"127.0.0.1"
const char table[] = "test"; //database
unsigned int port = 3306; //server port
MYSQL myCont;
MYSQL_RES *result;
MYSQL_ROW sql_row;
MYSQL_FIELD *fd;
char column[32][32];
int res;
mysql_init(&myCont);
if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0))
{
cout << "connect success!" << endl;
}
else
{
cout << "connect failed!" << endl;
}
mysql_close(&myCont);//断开连接
return 0;
}