软件及相关库的版本:
- VS2012
- boost版本boost_1_67_0
- mysql-5.7.22-winx64
- mysql-connector-c++-8.0.11-windows-x86-64bit
C++连接数据库的方法有两种:
- 调用MySQL的C API
- 使用mysql-connector-c++操作数据库
调用MySQL的C API方法如下:
1、新建项目
2、项目属性->C/C++ ->常规->附加包含目录:mysql安装目录的include路径
3、项目属性->链接器->常规->附加库目录:mysql安装目录的lib路径
4、项目属性->链接器->输入->附加依赖项:增加libmysql.lib
5、生成->配置管理器->平台:新建平台、X64
6、引用头文件 <winsock.h>、<mysql.h>
测试demo如下:
int main()
{
const char user[] = "root";
const char pswd[] = "123456";
const char host[] = "localhost";
const char table[] = "test";
unsigned int port = 3306;
MYSQL myCont;
MYSQL_RES *result;
MYSQL_ROW sql_row;
int res;
mysql_init(&myCont);
if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0))
{
mysql_query(&myCont, "SET NAMES GBK"); //设置编码格式
res = mysql_query(&myCont, "select * from track_detials");//查询
if (!res)
{
result = mysql_store_result(&myCont);
if (result)
{
while (sql_row = mysql_fetch_row(result))//获取具体的数据
{
cout<<"name:" << sql_row[0] << endl;
cout<<"index:" << sql_row[1] << endl;
}
}
}
else
{
cout << "query sql failed!" << endl;
}
}
else
{
cout << "connect failed!" << endl;
}
if (result != NULL)
mysql_free_result(result);
mysql_close(&myCont);
return 0;
}
使用mysql-connector-c++操作数据库的方法如下:
1、使用前提:已下载安装boost库、mysql-connector-c++(下载地址)
2、C/C++常规附加包含目录:
- D:\Program Files\MySql\mysql-5.7.22-winx64\include;
- D:\Program Files\MySql\mysql-connector-c++-8.0.11-windows-x86-64bit\include\jdbc\cppconn;
- D:\Program Files\MySql\mysql-connector-c++-8.0.11-windows-x86-64bit\include\jdbc;
- D:\Program Files (x86)\Microsoft Visual Studio 11.0\boost_1_67_0
3、链接器附加库目录:
- D:\Program Files (x86)\Microsoft Visual Studio 11.0\boost_1_67_0\bin.v2\libs;
- D:\Program Files\MySql\mysql-connector-c++-8.0.11-windows-x86-64bit\lib64\vs14;
- D:\Program Files\MySql\mysql-5.7.22-winx64\lib
4、链接器附加依赖项:增加mysqlcppconn.lib
5、生成->配置管理器->平台:新建平台、X64
测试demo如下:
#include <iostream>
#include <map>
#include <string>
#include <memory>
#include <mysql_driver.h>
#include "mysql_connection.h"
#include "cppconn/driver.h"
#include "cppconn/statement.h"
#include "cppconn/prepared_statement.h"
#include "cppconn/metadata.h"
#include "cppconn/exception.h"
using namespace std;
using namespace sql;
int main()
{
sql::mysql::MySQL_Driver *driver = 0;
sql::Connection *conn = 0;
try{
driver = sql::mysql::get_mysql_driver_instance();
conn = driver->connect("tcp://localhost:3306/test", "root", "123456");
cout << "连接成功" << endl;
}
catch (...)
{
cout << "连接失败" << endl;
}
sql::Statement* stat = conn->createStatement();
stat->execute("set names 'gbk'");
ResultSet *res;
res = stat->executeQuery("SELECT * FROM track_detials");
while (res->next())
{
cout << "index:" << res->getInt("index") << endl;
cout << "name :" << res->getString("name").c_str() << endl;
}
if (conn != 0)
{
delete conn;
}
return 0;
}