获取Sqlite数据库中的表名和字段名

最新推荐文章于 2023-05-09 16:17:23 发布

Mamong

最新推荐文章于 2023-05-09 16:17:23 发布

阅读量1.2w

点赞数

分类专栏： sqlite

本文链接：https://blog.youkuaiyun.com/Mamong/article/details/24712719

版权

sqlite 专栏收录该内容

8 篇文章

订阅专栏

本文深入探讨了数据库的基本概念，重点介绍了使用SQLite进行数据库操作和表查询的方法，包括创建表、获取表信息以及解析查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码很简略，没有添加太多的保护

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *path = [documentsDirectory stringByAppendingPathComponent:@"database_name"];
    
    sqlite3 *database;
    sqlite3_open([path UTF8String], &database);
    
    char *errorMsg;
    const char *createSQL = "CREATE TABLE IF NOT EXISTS PEOPLE (ID INTEGER PRIMARY KEY AUTOINCREMENT, FIELD_DATA TEXT)";
    int result = sqlite3_exec(database, createSQL, NULL, NULL, &errorMsg);
    
    sqlite3_stmt *statement;
    if (result == SQLITE_OK) {
        const char *getTableInfo = "select * from sqlite_master where type='table' order by name;";
        result = sqlite3_prepare_v2(database, getTableInfo, -1, &statement, nil);
       while (sqlite3_step(statement) == SQLITE_ROW) {
            char *nameData = (char *)sqlite3_column_text(statement, 1);
            NSString *tableName = [[NSString alloc] initWithUTF8String:nameData];
            NSLog(@"name:%@",tableName);
        }
        
        const char *getColumn = "PRAGMA table_info(PEOPLE)";
        result = sqlite3_prepare_v2(database, getColumn, -1, &statement, nil);
        while (sqlite3_step(statement) == SQLITE_ROW) {
            char *nameData = (char *)sqlite3_column_text(statement, 1);
            NSString *columnName = [[NSString alloc] initWithUTF8String:nameData];
            NSLog(@"columnName:%@",columnName);
        }
        
        sqlite3_finalize(statement);
    }
    sqlite3_close(database);

指出一点：

sqlite_master表结构
CREATE TABLE sqlite_master (
  type TEXT,
  name TEXT,
  tbl_name TEXT,
  rootpage INTEGER,
  sql TEXT
);