[C/C++]連接mysql資料庫

MySQL Connector/C++ 是 MySQL 官方開發，讓 C++ 程式能與 MySQL 資料庫進行溝通的函式庫。

其實官方的說明已經寫得很詳盡了，不過還是從網站中修改出幾個常見的情況的程式碼。

在使用前記得：

1. include header

#include <cppconn/driver.h>
//如果有用 prepared statement 的話
#include <cppconn/prepared_statement.h>

2. Options for Linking -lmysqlcppconn。
3. 最好使用 try-catch 防止 mysql 錯誤。
   或是直接複製這裡的 try-catch 區塊?

sql::Driver* driver;
sql::Connection* connection;

driver = get_driver_instance();
connection = driver->connect("tcp://127.0.0.1:3306", "user", "password");
connection->setSchema("myDatabase");

delete connection;

修改自此。

sql::Driver* driver;
sql::Connection* connection;
sql::PreparedStatement* prep_stmt;

driver = get_driver_instance();
connection = driver->connect("tcp://127.0.0.1:3306", "user", "password");
connection->setSchema("myDatabase");

pstmt = con->prepareStatement("INSERT INTO test(id, label) VALUES (?, ?)");
pstmt->setInt(1, 1);
pstmt->setString(2, "a");
pstmt->execute();

delete pstmt;
delete connection;

修改自此。

sql::Driver* driver;
sql::Connection* connection;
sql::Statement* stmt;
sql::ResultSet res;

driver = get_driver_instance();
connection = driver->connect("tcp://127.0.0.1:3306", "user", "password");
connection->setSchema("myDatabase");

stmt = connection->createStatement();
res = stmt->executeQuery("SELECT id FROM test");
while (res->next()) {
	cout<<res->getInt("id")<<endl;
}

delete res;
delete stmt;
delete connection;

修改自此。

• https://dev.mysql.com/doc/connector-cpp/en/

• http://programer-learn.blogspot.tw/2010/11/jsp-preparedstatement.html

隨便 google 了一個 prepared statement 的介紹。發現這個 library 跟 Java 的 java.sql 很像?