linux系统下mysql-connector-c++ 连接mysql教程，

linux系统下mysql-connector-c++ 连接mysql教程，

centos6.5 ,官网下载包:mysql-connector-c++-1.1.9-linux-glibc2.12-x86-64bit.tar.gz

一、

解压包，将里边的include,lib目录里边的文件和文件夹分别拷到/usr/include ,/usr/lib

二、数据库安装好，配置好用户

三、根据官方提供的案例测试

//test.cpp,内容 :

/* Standard C++ includes */

#include

#include

/*

Include directly the different

headers from cppconn/ and mysql_driver.h + mysql_util.h

(and mysql_connection.h). This will reduce your build time!

*/

#include "mysql_connection.h"

#include

#include

#include

#include

#include

using namespace std;

int main(void)

{

cout << endl;

cout << "Let's have MySQL count from 10 to 1..." << endl;

try {

sql::Driver *driver;

sql::Connection *con;

sql::Statement *stmt;

sql::ResultSet *res;

sql::PreparedStatement *pstmt;

/* Create a connection */

driver = get_driver_instance();

con = driver->connect("tcp://192.168.56.121:3306", "root", "123456");

/* Connect to the MySQL test database */

con->setSchema("test");

stmt = con->createStatement();

stmt->execute("DROP TABLE IF EXISTS test");

stmt->execute("CREATE TABLE test(id INT)");

delete stmt;

/* '' is the supported placeholder syntax */

pstmt = con->prepareStatement("INSERT INTO test(id) VALUES ()");

for (int i = 1; i <= 10; i++) {

pstmt->setInt(1, i);

pstmt->executeUpdate();

}

delete pstmt;

/* Select in ascending order */

pstmt = con->prepareStatement("SELECT id FROM test ORDER BY id ASC");

res = pstmt->executeQuery();

/* Fetch in reverse = descending order! */

res->afterLast();

while (res->previous())

cout << "\t... MySQL counts: " << res->getInt("id") << endl;

delete res;

delete pstmt;

delete con;

}

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;

}

cout << endl;

return EXIT_SUCCESS;

}

四、编译生成

g++ -c test.cpp -lmysqlcppconn

g++ test.o -lmysqlcppconn

五、运行结果

[root@testicehost test]# ./test

Let's have MySQL count from 10 to 1...

... MySQL counts: 10

... MySQL counts: 9

... MySQL counts: 8

... MySQL counts: 7

... MySQL counts: 6

... MySQL counts: 5

... MySQL counts: 4

... MySQL counts: 3

... MySQL counts: 2

... MySQL counts: 1