Mysql Connector/c++库的下载和使用(Windows)

环境配置

环境：windows10, visual studio 2019，已安装mysql server 版本为8.0.36，项目配置visual studio解决方案时，使用的Release x64

下载Mysql Connector/c++

mysql官方提供了connector/c++版本，connector是mysql官方提供的驱动数据库的工具（api），connector支持c++，提供库文件和头文件，来使用。

https://dev.mysql.com/downloads/connector/cpp/
此处下载了压缩包的版本 mysql-connector-c+±8.3.0-winx64

向项目中添加头文件和库文件（配置解决方案）

• 附加包含目录设置解压后的include路径：
  
• 附加库目录设置解压后的lib/64/vs14路径
  
• 附加依赖项设置
  
• 拷贝解压后的lib64目录下的所有.dll到与main函数文件同级的目录下 （或者放到.exe同级的目录也可以）
  
• 测试下如下代码能不能正常编译

#include "jdbc/mysql_driver.h"
#include "jdbc/mysql_connection.h"
#include "jdbc/cppconn/driver.h"
#include "jdbc/cppconn/connection.h"
#include "jdbc/cppconn/statement.h"
#include "jdbc/cppconn/prepared_statement.h"
#include "jdbc/cppconn/resultset.h"
#include "jdbc/cppconn/metadata.h"
#include "jdbc/cppconn/resultset_metadata.h"
#include "jdbc/cppconn/exception.h"
#include "jdbc/cppconn/warning.h"
 
#include <mysql/jdbc.h>
 
#define DBHOST "tcp://127.0.0.1:3306"
#define USER "root"
#define PASSWORD "123456"
#define DATABASE "sys"
 
using namespace std;
using namespace sql;
 
int main()
{
    try
    {
        //连接数据库
        Driver* driver = get_driver_instance();
        Connection* conn = driver->connect(DBHOST, USER, PASSWORD);
        Statement* stm;
        if (!conn->isValid()) {
            cout << "数据库连接无效" << endl;
            return 0;
        }
        else
            cout << "数据库连接成功" << endl;
        //创建 test 表，添加数据
        stm = conn->createStatement();
        stm->execute("use " DATABASE);
        stm->execute("DROP TABLE IF EXISTS test");
        stm->execute("CREATE TABLE test(id INT,lable CHAR(1))");
        stm->execute("INSERT INTO test(id,lable) VALUES(6,'A')");
        stm->execute("INSERT INTO test(id,lable) VALUES(3,'A')");
        stm->execute("INSERT INTO test(id,lable) VALUES(2,'A')");
 
        //升序查询
        ResultSet* rss;
        rss = stm->executeQuery("SELECT id,lable FROM test ORDER BY id ASC");
        while (rss->next())
        {
            /* code */
 
            int id = rss->getInt(1);
            string lable = rss->getString("lable");
 
            cout << "id:" << id << ","
                << "lable:" << lable << endl;
        }
        
        //删除
        stm->execute("DELETE FROM test WHERE id=3");
 
        //改
        stm->execute("UPDATE test SET lable='B' WHERE id=2");
 
        delete stm;
        delete conn;
        delete rss;
 
    }
    catch (const SQLException& sqle)
    {
        cout << "# ERR: SQLException in " << __FILE__;
        cout << "(" << __FUNCTION__ << ") on line " << __LINE__ << endl;
        std::cerr << "sql errcode:" << sqle.getErrorCode() << ",state:" << sqle.getSQLState() << ",what:" << sqle.what() << endl;
    }
 
    return 0;
}