C++中的SQLite字符*转换

#include <iostream>
#include <sqlite3.h>

int main() {
    sqlite3* db;
    sqlite3_stmt* stmt;
    const char* sql = "SELECT name FROM users WHERE id = 1";

    // 打开数据库连接
    int rc = sqlite3_open("database.db", &db);
    if (rc != SQLITE_OK) {
        std::cerr << "Cannot open database: " << sqlite3_errmsg(db) << std::endl;
        return rc;
    }

    // 准备SQL语句
    rc = sqlite3_prepare_v2(db, sql, -1, &stmt, nullptr);
    if (rc != SQLITE_OK) {
        std::cerr << "Cannot prepare SQL statement: " << sqlite3_errmsg(db) << std::endl;
        return rc;
    }

    // 执行查询
    rc = sqlite3_step(stmt);
    if (rc == SQLITE_ROW) {
        // 获取查询结果中的字符串数据
        const char* name = reinterpret_cast<const char*>(sqlite3_column_text(stmt, 0));
        std::cout << "Name: " << name << std::endl;
    }

    // 释放资源
    sqlite3_finalize(stmt);
    sqlite3_close(db);

    return 0;
}