Форум программистов [Powered by Invision Power Board]

Код

#include <stdlib.h>
#include <iostream>
#include <fstream>
#include <sstream>

#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>

using namespace std;

int main(){

    sql::Driver *driver;
    sql::Connection *con;
    sql::Statement *stmt;
    sql::ResultSet *res;
    sql::PreparedStatement *pstmt;
    
    try{
        driver = get_driver_instance();
        con = driver->connect("tcp://127.0.0.1:3306", "root", "pwd");
        con->setSchema("mydb");
        stmt = con->createStatement();
        stmt->execute("insert into trans values(4,'four'),(5, 'five')");
        delete stmt;

        pstmt = con->prepareStatement("select * from trans");
        res = pstmt->executeQuery();
        while (res->next())
            cout << res->getInt("id")<<"  "<<res->getString("data") << endl;
        delete res;
        delete pstmt;

        pstmt = con->prepareStatement("delete from example where id=?");
        pstmt->setInt(1,4);
        pstmt->executeUpdate();
        pstmt->setInt(1,5);
        pstmt->executeUpdate();

        delete pstmt;

        delete con;    
    }catch(sql::SQLException &e){
        cout << e.what();
    }
    return 0;
}