C++ mysql
1.Install C++ connector
sudo apt install libmysqlcppconn-dev
2.
#include <iostream> #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> #include <cppconn/exception.h> using namespace std; void mySQL65(); int main(int args, char **argv) { mySQL65(); } void mySQL65() { try { sql::Driver *driver; sql::Connection *conn; sql::Statement *stmt; sql::ResultSet *res; driver = get_driver_instance(); conn = driver->connect(tcp://127.0.0.1:3306, root, Root0001!); conn->setSchema(myDB); stmt = conn->createStatement(); res = stmt->executeQuery(SELECT 'Hello World!' AS _message); // replace with your statement while (res->next()) { cout << \t... MySQL replies: ; /* Access column data by alias or column name */ cout << res->getString(_message) << endl; cout << \t... MySQL says it again: ; /* Access column fata by numeric offset, 1 is the first column */ cout << res->getString(1) << endl; } delete res; delete stmt; delete conn; } catch (sql::SQLException &e) { cout << # ERR: SQLException in << __FILE__; cout << ( << __FUNCTION__ << ) on line << __LINE__ << endl; cout << # ERR: << e.what(); cout << (MySQL error code: << e.getErrorCode(); cout << , SQLState: << e.getSQLState() << ) << endl; } }
3.Compile via g++ and inclue mysql connector , -I/usr/include/cppconn -L/usr/lib -lmysqlcppconn
g++ -g -std=c++2a -I. -Wall -I/usr/include/cppconn *.cpp ./Model/*.cpp -o h1 -luuid -lpthread -L/usr/lib -lmysqlcppconn
4.Run the compiled program