libmysqlcppconn-dev Sample

#include <stdlib.h>
#include <iostream>
#include <mysql_connection.h>
#include <driver.h>
#include <exception.h>
#include <resultset.h>
#include <statement.h>


using namespace sql;
int main(void){
  sql::Driver *driver;
  sql::Connection *con;
  Statement *state;
  sql::ResultSet *result;
//  std::time_t timeresult=std::time(nullptr);
  driver = get_driver_instance();
  con = driver->connect("tcp://192.168.0.110:3306","root","123maiqi");
  state =con->createStatement();
  std::cout <<"connection sucessful!" <<std::endl;
  state->execute("use maiqi_model");


 // std::cout <<std::asctime(std::localtime(&timeresult)) <<std::endl;
  result= state->executeQuery("select * from model");


  std::cout <<result <<std::endl;
  // std::cout <<std::asctime(std::localtime(&timeresult)) <<std::endl;
  return 0;
}

g++ -Wall -I/usr/include/cppconn -o testapp tester.cpp -L/usr/lib -lmysqlcppconn