#include <iostream>
#include <sqlite3.h>// 創建數據庫連接
sqlite3* OpenDatabase(const char* dbFilePath) {sqlite3* db;// 打開數據庫if (sqlite3_open(dbFilePath, &db) != SQLITE_OK) {std::cerr << "Error opening database." << std::endl;return nullptr;}return db;
}// 關閉數據庫連接
void CloseDatabase(sqlite3* db) {sqlite3_close(db);
}// 創建表
void CreateTable(sqlite3* db) {const char* createTableSQL = "CREATE TABLE IF NOT EXISTS Users (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Age INTEGER);";if (sqlite3_exec(db, createTableSQL, nullptr, nullptr, nullptr) != SQLITE_OK) {std::cerr << "Error creating table." << std::endl;} else {std::cout << "Table created or already exists." << std::endl;}
}// 插入數據
void InsertData(sqlite3* db, const char* name, int age) {const char* insertDataSQL = "INSERT INTO Users (Name, Age) VALUES (?, ?);";sqlite3_stmt* statement;if (sqlite3_prepare_v2(db, insertDataSQL, -1, &statement, nullptr) == SQLITE_OK) {// 綁定參數sqlite3_bind_text(statement, 1, name, -1, SQLITE_STATIC);sqlite3_bind_int(statement, 2, age);// 執行語句if (sqlite3_step(statement) != SQLITE_DONE) {std::cerr << "Error inserting data." << std::endl;} else {std::cout << "Data inserted." << std::endl;}// 釋放資源sqlite3_finalize(statement);}
}// 查詢數據
void QueryData(sqlite3* db) {const char* queryDataSQL = "SELECT * FROM Users;";sqlite3_stmt* statement;if (sqlite3_prepare_v2(db, queryDataSQL, -1, &statement, nullptr) == SQLITE_OK) {std::cout << "Id\tName\tAge" << std::endl;// 遍歷結果集while (sqlite3_step(statement) == SQLITE_ROW) {std::cout << sqlite3_column_int(statement, 0) << "\t" << sqlite3_column_text(statement, 1) << "\t" << sqlite3_column_int(statement, 2) << std::endl;}// 釋放資源sqlite3_finalize(statement);}
}// 更新數據
void UpdateData(sqlite3* db, int id, const char* name, int age) {const char* updateDataSQL = "UPDATE Users SET Name=?, Age=? WHERE Id=?;";sqlite3_stmt* statement;if (sqlite3_prepare_v2(db, updateDataSQL, -1, &statement, nullptr) == SQLITE_OK) {// 綁定參數sqlite3_bind_text(statement, 1, name, -1, SQLITE_STATIC);sqlite3_bind_int(statement, 2, age);sqlite3_bind_int(statement, 3, id);// 執行語句if (sqlite3_step(statement) != SQLITE_DONE) {std::cerr << "Error updating data." << std::endl;} else {std::cout << "Data updated." << std::endl;}// 釋放資源sqlite3_finalize(statement);}
}// 刪除數據
void DeleteData(sqlite3* db, int id) {const char* deleteDataSQL = "DELETE FROM Users WHERE Id=?;";sqlite3_stmt* statement;if (sqlite3_prepare_v2(db, deleteDataSQL, -1, &statement, nullptr) == SQLITE_OK) {// 綁定參數sqlite3_bind_int(statement, 1, id);// 執行語句if (sqlite3_step(statement) != SQLITE_DONE) {std::cerr << "Error deleting data." << std::endl;} else {std::cout << "Data deleted." << std::endl;}// 釋放資源sqlite3_finalize(statement);}
}int main() {// 指定數據庫文件路徑const char* dbFilePath = "sample.db";// 創建數據庫連接sqlite3* db = OpenDatabase(dbFilePath);if (db) {// 創建表CreateTable(db);// 插入數據InsertData(db, "John Doe", 30);// 查詢數據QueryData(db);// 更新數據UpdateData(db, 1, "Updated Name", 35);// 查詢更新后的數據QueryData(db);// 刪除數據DeleteData(db, 1);// 查詢刪除后的數據QueryData(db);// 關閉數據庫連接CloseDatabase(db);}return 0;
}