C++如何进行数据库操作_使用SQLiteCpp库在C++中轻松管理SQLite数据库

• Ubuntu/Debian系统可通过命令安装依赖：
  sudo apt-get install libsqlite3-dev
• 从GitHub克隆SQLiteCpp：
  git clone https://github.com/SRombauts/SQLiteCpp.git
• 编译并安装（推荐使用CMake）：
  进入目录执行 mkdir build && cd build && cmake .. && make && sudo make install

#include 
#include 

int main() {
    try {
        // 创建或打开数据库文件 "example.db"
        SQLite::Database db("example.db", SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE);

        std::cout << "数据库打开成功！" << std::endl;
    } catch (const std::exception& e) {
        std::cerr << "数据库错误：" << e.what() << std::endl;
    }
    return 0;
}

// 建立一张用户表
db.exec("CREATE TABLE IF NOT EXISTS users ("
        "id INTEGER PRIMARY KEY AUTOINCREMENT, "
        "name TEXT NOT NULL, "
        "age INTEGER)");

// 插入两条记录
SQLite::Statement insert(db, "INSERT INTO users (name, age) VALUES (?, ?)");
insert.bind(1, "Alice");
insert.bind(2, 25);
insert.executeStep(); // 执行一次插入

insert.reset(); // 重用语句
insert.bind(1, "Bob");
insert.bind(2, 30);
insert.executeStep();

SQLite::Statement query(db, "SELECT id, name, age FROM users WHERE age > ?");
query.bind(1, 20);

while (query.executeStep()) {
    int id   = query.getColumn(0);
    std::string name = query.getColumn(1);
    int age  = query.getColumn(2);

    std::cout << "ID: " << id << ", 名字: " << name << ", 年龄: " << age << std::endl;
}