mysql c++开发实例_mysql c++ jdbc 示例

#include "JdbcHelper.h"#includeJdbcHelper::JdbcHelper(const std::string& host, const std::string& username, const std::string& passwd, const std::string&database)

{this->host =host;this->username =username;this->passwd =passwd;this->database =database;this->conn =NULL;try{this->driver =get_driver_instance();

}catch (sql::SQLException &e) {this->printSQLException(e, "get_driver_instance");

}if (driver ==NULL) {

std::cout<< "driver is null" <<:endl>

}

}

JdbcHelper::~JdbcHelper()

{

}int JdbcHelper::jdbc_connect(boolenableSSL)

{if (NULL !=conn) {return -1;

}this->m_enableSSL =enableSSL;try{

sql::ConnectOptionsMap opts;

opts["hostName"] = this->host;

opts["userName"] = this->username;

opts["password"] = this->passwd;if(enableSSL) {//默认使用SSL

}else{

opts["OPT_SSL_MODE"] =sql::SSL_MODE_DISABLED;

}

opts["OPT_RECONNECT"] = sql::ConnectPropertyVal(true);this->conn = driver->connect(opts);if (NULL ==conn) {

printf("conn id null\n");return -2;

}//选择数据库

sql::SQLString catalog(this->database);

conn->setSchema(catalog);return 0;

}catch (sql::SQLException &e) {this->printSQLException(e, "connect");

}return -3;