C++是一種流行的編程語言，廣泛用于各種應用程序的開發。其中，操作MySQL數據庫是C++開發中非常重要的一部分。下面我們將介紹如何使用C++編寫代碼來操作MySQL數據庫。

1. 安裝MySQL C++ Connector

sudo apt-get install libmysqlcppconn-dev

2. 頭文件引入

#include#include#include#include#include#include#include

3. 創建連接

sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;
driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "username", "password");
stmt = con->createStatement();
stmt->execute("USE database_name");

4. 查詢數據

res = stmt->executeQuery("SELECT * FROM table_name");
while (res->next()) {
std::cout<< res->getString("column_name")<< std::endl;
}
delete res;
delete stmt;
delete con;

5. 插入數據

stmt = con->createStatement();
stmt->execute("INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')");
delete stmt;
delete con;

6. 更新數據

stmt = con->createStatement();
stmt->execute("UPDATE table_name SET column1='new_value' WHERE column2='old_value'");
delete stmt;
delete con;

7. 刪除數據

stmt = con->createStatement();
stmt->execute("DELETE FROM table_name WHERE column_name='value'");
delete stmt;
delete con;

總結

在C++中操作MySQL數據庫是非常方便的，只需要通過引用相關的頭文件和創建連接，就可以進行各種數據操作了。本文介紹了基本的數據查詢、插入、更新和刪除操作，您可以根據您的具體應用場景進行相應的選擇和組合。