Compile with cppconn and mysqlclient

1. cpp 

#include Model/Util.h #include <functional> #include <string_view> #include <experimental/source_location> #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> #include <cppconn/exception.h> #include <cppconn/prepared_statement.h> #include <mysql/mysql.h>  void mysqlClient74();  int main(int args, char **argv) {     batchInsert(atoi(argv[1])); }  void batchInsert(int loops) {     try     {         sql::Driver *driver;         sql::Connection *conn;         sql::PreparedStatement *prepStmt;         driver = get_driver_instance();          conn = driver->connect(tcp://127.0.0.1:3306, root, Root0001!);         conn->setSchema(myDB);          stringstream ss;         int repeatedTimes = 1000000;         int64_t num = 0;         Util ul;          for (int i = 0; i < loops; i++)         {             ss = stringstream();             conn = driver->connect(tcp://127.0.0.1:3306, root, Root0001!);             conn->setSchema(myDB);             ss << insert into mt(BookId,BookName,BookTitle) values ;             for (int j = 0; j < repeatedTimes; j++)             {                 ss << ( << ++num << ,' << getUuid() << ',' << getUuid() << '), << endl;             }              string str = ss.str();             int lastIndex = str.find_last_of(,);             str = str.erase(lastIndex);             prepStmt = conn->prepareStatement(str);             prepStmt->execute();             cout << ul.getTimeNow() << ,Loop= << i + 1 <<  finished! << endl;             conn->close();             prepStmt->close();         }          delete prepStmt;         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;         return;     }     cout << Finished in void batchInsert(int loops)! << endl; }

 

 

2.Compile:

g++ -g -std=c++2a -I. -Wall -I/usr/include/cppconn -I/usr/include/mysql/ *.cpp ./Model/*.cpp -o h1 -luuid -lpthread -L/usr/lib -lmysqlcppconn -lmysqlclient

 

3.Execute

./h1 10