Database类为单例类、线程安全、实现了连接池,并且封装所需要的操作。
本代码在Ubuntu下测试可用,使用Mysql connector c++连接数据库,并启用C++11特性。
相关依赖库下载地址:https://dev.mysql.com/downloads/connector/cpp/
基本操作如下:
//数据库配置
DbSetting setting;
setting.host = "tcp://127.0.0.1:3306/dbname";
setting.username = "root";
setting.password = "root";
setting.connpoolsize = 100;//连接池最大大小
setting.reconnmaxsize = 3;//重连次数
//初始化
Database::Create(setting);
//调用,如果有错误会抛出异常
try
{
//调用封装好的数据库操作
Database::GetInstance()->AddUser("deviceid","username");
}catch(const exception& e)
{
//异常处理
}
//销毁
Database::Destory();
干货如下:
头文件:
#ifndef DATABASE_H
#define DATABASE_H
//base
# include <iostream>
# include <pplx/pplx.h>
# include <memory>
# include <map>
# include <functional>
# include <list>
# include <string>
# include <sstream>
//mysql
# include <cppconn/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;
//数据库配置
struct DbSetting
{
string host;
string us