需要自己配置下sqlite3 C++api库的开发环境
写法1:获取数据库中所有表名
#include <sqlite3.h>
#include <iostream>
int main() {
sqlite3 *db;
char *zErrMsg = 0;
int rc;
rc = sqlite3_open("your_database.db", &db);
if (rc) {
std::cerr << "Can't open database: " << sqlite3_errmsg(db) << std::endl;
return(0);
} else {
std::cout << "Opened database successfully" << std::endl;
}
const char* sql = "SELECT name FROM sqlite_master WHERE type='table';";
sqlite3_stmt *stmt;
if (sqlite3_prepare_v2(db, sql, -1, &stmt, nullptr) == SQLITE_OK) {
while (sqlite3_step(stmt) == SQLITE_ROW) {
const unsigned char* tableName = sqlite3_column_text(stmt, 0);
std::cout << "Table Name: " << tableName << std::endl;
}
sqlite3_finalize(stmt);
} else {
std::cerr << "SQL error: " << zErrMsg << std::endl;
sqlite3_free(zErrMsg);
}
sqlite3_close(db);
return 0;
}
写法2:获取数据库中所有表名
#include <iostream>
#include <sqlite3.h>
int main() {
sqlite3 *db;
char *zErrMsg = 0;
int rc;
// 打开数据库连接
rc = sqlite3_open("your_database.db", &db);
if (rc) {
std::cerr << "无法打开数据库: " << sqlite3_errmsg(db) << std::endl;
return(1);
}
// 执行查询以获取所有表名
const char *sql = "SELECT name FROM sqlite_master WHERE type='table'";
rc = sqlite3_exec(db, sql, [](void* data, int argc, char** argv, char** azColName) -> int {
for(int i = 0; i < argc; i++) {
std::cout << argv[i] << std::endl;
}
return 0;
}, nullptr, &zErrMsg);
if (rc != SQLITE_OK) {
std::cerr << "SQL 错误: " << zErrMsg << std::endl;
sqlite3_free(zErrMsg);
}
// 关闭数据库连接
sqlite3_close(db);
return 0;
}