MySQL 提供 C 語言客戶端庫 libmysqlclient,核心結構體 MYSQL、MYSQL_RES、MYSQL_ROW,函數族:mysql_init, mysql_real_connect, mysql_query, mysql_store_result, mysql_fetch_row, mysql_close 等。
| 庫 | 特點 |
|---|---|
| MySQL Connector/C++ | Oracle 官方,JDBC 4.0 API 的 C++ 實現,適合熟悉 JDBC 的開發者,支援 PreparedStatement、ResultSet、連線池。 |
| MySQL++ | 輕量、STL 風格,將結果集映射為容器,支援 SSQLS(靜態結構對映),學習曲線平緩。 |
MySQLInterface 核心碼#ifndef __MYSQL_INTERFACE_H__
#define __MYSQL_INTERFACE_H__
#include
#include
#include
#include
#pragma comment(lib, "ws2_32.lib")
#pragma comment(lib, "libmysql.lib")
class MySQLInterface {
public:
MySQLInterface();
virtual ~MySQLInterface();
bool connectMySQL(const char* server, const char* user, const char* pass,
const char* db, int port);
bool createDatabase(const std::string& dbname);
bool createTable(const std::string& ddl);
bool executeUpdate(const std::string& sql); // INSERT/UPDATE/DELETE
bool executeQuery(const std::string& sql,
std::vector>& rows); // SELECT
void close();
int getErrorNo() const { return errorNum; }
const char* getErrorMsg() const { return errorInfo; }
private:
MYSQL mysqlInstance;
MYSQL_RES* result;
int errorNum;
const char* errorInfo;
};
#endif
MySQLInterface::MySQLInterface() : errorNum(0), errorInfo("ok") {
mysql_library_init(0, NULL, NULL);
mysql_init(&mysqlInstance);
mysql_options(&mysqlInstance, MYSQL_SET_CHARSET_NAME, "gbk"); // 或 utf8mb4
}
bool MySQLInterface::connectMySQL(const char* server, const char* user,
const char* pass, const char* db, int port) {
if (!mysql_real_connect(&mysqlInstance, server, user, pass, db, port, NULL, 0)) {
errorNum = mysql_errno(&mysqlInstance);
errorInfo = mysql_error(&mysqlInstance);
return false;
}
return true;
}
bool MySQLInterface::executeQuery(const std::string& sql,
std::vector>& rows) {
if (mysql_query(&mysqlInstance, sql.c_str())) {
errorNum = mysql_errno(&mysqlInstance);
errorInfo = mysql_error(&mysqlInstance);
return false;
}
result = mysql_store_result(&mysqlInstance);
if (!result) return false; // 非 SELECT 或空結果
unsigned int num_fields = mysql_num_fields(result);
MYSQL_ROW row;
while ((row = mysql_fetch_row(result))) {
std::vector record;
record.reserve(num_fields);
for (unsigned int i = 0; i < num_fields; ++i)
record.push_back(row[i] ? row[i] : "");
rows.push_back(std::move(record));
}
mysql_free_result(result);
return true;
}
void MySQLInterface::close() {
if (result) mysql_free_result(result);
mysql_close(&mysqlInstance);
mysql_library_end();
}
std::queue + std::mutex + 條件變量。begin(), commit(), rollback() 對應 mysql_autocommit、mysql_commit、mysql_rollback。MYSQL_STMT、MYSQL_BIND 防注入、提升重複執行效能。libevent/boost::asio 實現高併發。