1、安装mysqlconnector
sudo apt-get install libmysqlcppconn-dev
2、安装mysql
sudo apt-get install mysql-server
使用网上广泛引用的一个测试代码
#include <iostream>
#include <sstream>
#include <memory>
#include <string>
#include <stdexcept>
using namespace std;
#include <mysql_connection.h>
#include <mysql_driver.h>
#include <cppconn/driver.h>
using namespace sql;
#define DBHOST "tcp://127.0.0.1:3306"
#define USER "root"
#define PASSWORD "your password here"
int main() {
Driver *driver;
Connection *conn;
driver = get_driver_instance();
conn = driver->connect(DBHOST, USER, PASSWORD);
conn->setAutoCommit(0);
cout<<"DataBase connection autocommit mode = "<<conn->getAutoCommit()<<endl;
delete conn;
driver = NULL;
conn = NULL;
return 0;
}
使用 g++ -o testmysql testmysql.cpp -lmysqlcppconn 编译文件,运行即可
一定注意不要写成g++ -o testmysql -lmysqlcppconn testmysql.cpp 网上好多写这样的,让我查了半天也没找出哪错了。。。这样编译不通过