c++ mysql庫的數據更新與刪除操作

在C++中，可以使用MySQL C++ Connector庫來進行數據更新和刪除操作。以下是一個簡單的示例代碼，展示如何使用MySQL C++ Connector庫來進行數據更新和刪除操作：

數據更新操作示例：

#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>

int main() {
    sql::mysql::MySQL_Driver *driver;
    sql::Connection *con;

    driver = sql::mysql::get_mysql_driver_instance();
    con = driver->connect("tcp://127.0.0.1:3306", "username", "password");
    con->setSchema("database_name");

    sql::PreparedStatement *pstmt;
    std::string query = "UPDATE table_name SET column1 = ? WHERE column2 = ?";
    pstmt = con->prepareStatement(query);
    pstmt->setString(1, "new_value");
    pstmt->setString(2, "value_to_match");
    pstmt->executeUpdate();

    delete pstmt;
    delete con;

    return 0;
}

數據刪除操作示例：

#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/statement.h>

int main() {
    sql::mysql::MySQL_Driver *driver;
    sql::Connection *con;

    driver = sql::mysql::get_mysql_driver_instance();
    con = driver->connect("tcp://127.0.0.1:3306", "username", "password");
    con->setSchema("database_name");

    sql::Statement *stmt;
    stmt = con->createStatement();
    std::string query = "DELETE FROM table_name WHERE column = 'value'";
    stmt->execute(query);

    delete stmt;
    delete con;

    return 0;
}

在以上示例代碼中，需要將username、password、database_name、table_name、column1、column2和value_to_match替換為實際的數據庫連接信息和表、列名等。同時，需要確保已經安裝了MySQL C++ Connector庫，并在編譯時鏈接該庫。