mysql connector c++ 使用_MySQL Connector/C++ 使用 | 学步园

1. 到MySQL官网( http://dev.mysql.com/downloads/connector/cpp/ )

下载 mysql-connector-c++-noinstall-1.0.5-win32-vs2005

2. 安装MySQL, 注意安装前要勾上C/C++ Headers 这个选项

3. 建立工程，把 libmySQL.dll、mysqlcppconn.dll 放到工程根目录下

4. 代码如下：

/* Standard C++ headers */

#include

#include

/* MySQL Connector/C++ headers */

#include

#include

#include

#include

#include

#pragma comment(lib, "mysqlcppconn.lib")

/* Microsoft headers */

#include

#define __free__(p, b_close)/

if (b_close) { p->close(); } if (p != NULL) { delete p; p = NULL; }/

struct cStudent

{

int nID;

std::string s_name;

int nAge;

};

int _tmain(int argc, _TCHAR* argv[])

{

sql::Driver *driver = NULL;

sql::Connection *conn = NULL;

sql::Statement *stmt = NULL;

sql::ResultSet *rs = NULL;

sql::Savepoint *savept = NULL;

try

{

driver = get_driver_instance();

conn = driver->connect("tcp://127.0.0.1:3306", "root", "root");

// 设置为手动提交

conn->setAutoCommit(false);

conn->setSchema("test");

savept = conn->setSavepoint("SAVE_POINT");

stmt = conn->createStatement();

char buf[64];

for (int i = 0; i < 100; ++i)

{

sprintf(buf, "INSERT INTO student(name, age) VALUES(/"tom%d/", %d);", i + 1, i + 19);

stmt->execute(buf);

}

rs = stmt->executeQuery("SELECT * FROM student LIMIT 10");

std::vector students;

while (rs->next())

{

cStudent student;

student.nID = rs->getInt("id");

student.s_name = rs->getString("name");

student.nAge = rs->getInt("age");

students.push_back(student);

}

// 提交

conn->commit();

}

catch (sql::SQLException &e)

{

std::string s_error(e.what());

std::cout << e.what() << std::endl;

// 回滚操作

conn->rollback(savept);

conn->releaseSavepoint(savept);

}

// 释放资源

__free__(rs, false);

__free__(stmt, false);

__free__(conn, true);

system("PAUSE");

return 0;

}