做导购网站,如何注册域名邮箱,团队展示网站,视频剪辑制作教学1.下载最新的Connector https://dev.mysql.com/downloads/connector/cpp/#xff0c;下载带debug的库。
解压缩到本地#xff0c;本次使用的是带debug模式的connector库#xff1a;
注#xff1a;其中mysqlcppconn与mysqlcppconn8的区别是#xff1a;
2.在cmakelist…1.下载最新的Connector https://dev.mysql.com/downloads/connector/cpp/下载带debug的库。
解压缩到本地本次使用的是带debug模式的connector库
注其中mysqlcppconn与mysqlcppconn8的区别是
2.在cmakelist中定义寻址头文件的路径与库的路径
#定义头文件需要寻址的路径
include_directories(D:/Library/mysql-connector-c-8.2.0-winx64/include/jdbc
)#定义库文件需要寻址的路径
link_directories(D:/Library/mysql-connector-c-8.2.0-winx64/lib64/vs14/debug
)target_link_libraries(QtDemo2Qt5::CoreQt5::GuiQt5::Widgets......mysqlcppconn
)3.复制对应的DLL到可执行目录 把D:\Library\mysql-connector-c±8.2.0-winx64\lib64\debug中的mysqlcppconn-9-vs14.dll复制到项目的可执行目录下。
3.基础使用 https://dev.mysql.com/doc/connector-cpp/1.1/en/connector-cpp-examples-connecting.html
#include sql_connector.h
#include string
#include QDebug#include mysql_connection.h
#include cppconn/driver.h
#include cppconn/exception.h
#include cppconn/prepared_statement.hvoid SqlConnector::process()
{qDebug(SqlConnector started....);std::string server tcp://localhost:3306;std::string username root;std::string password Xi1ozh#1;sql::Driver* driver;sql::Connection* connection;try{driver get_driver_instance();connection driver-connect(server, username, password);connection-setSchema(ws300);}catch (sql::SQLException e){std::cout Could not connect to server. Error message: e.what() \n;}//查询sql::SQLString sql(select * from users;);std::unique_ptrsql::Statement statment(connection-createStatement());statment-execute(set names utf8mb4);std::unique_ptrsql::ResultSet result(statment-executeQuery(sql));while (result-next()){auto data result-getString(password).asStdString();qDebug(SqlConnector username: %s, data.c_str());}result-close();statment-close();connection-close();delete connection;qDebug(SqlConnector finished....);
}
