sqlite列出所有表信息

#include <sqlite3.h>
#include <stdio.h>
#include <string.h>

//回调函数
int ListTablesName_callback(void *pDB,int argc,char **argv,char **azColName)
{
    int ret;
    char pSqlQuerySel[128] = "select * from ";
    char *pError = NULL;
    sqlite3_stmt *pStmt = NULL;

    strcat(pSqlQuerySel,argv[0]);    
    fprintf(stdout,"%sn",pSqlQuerySel);

        //准备读取数据
    ret = sqlite3_prepare((sqlite3 *)pDB,pSqlQuerySel,strlen(pSqlQuerySel),&pStmt,(const char**)&pError);
    if (ret != SQLITE_OK)
    {
        fprintf(stderr,"sqlite3_prepare failn");
        return -1;
    }

    while (1)
    {
        ret = sqlite3_step(pStmt);        //移动记录集
        if (ret != SQLITE_ROW)
            break;

        fprintf(stdout,"%d ",sqlite3_column_int(pStmt,0));
        fprintf(stdout,"%s n",sqlite3_column_text(pStmt,1));        
    }

    return 0;
}

int main()
{
    int ret = 0;
    sqlite3 *pDB = NULL;
    sqlite3_stmt *pStmt = NULL;
    char *pError = NULL;
    char *pListTablesNameSel = (char*)"SELECT name FROM sqlite_master";//列出所以表名语句

    //打开文件
    ret = sqlite3_open("test.db",&pDB);
    if (ret != SQLITE_OK)
    {
        fprintf(stderr,"can't open database : %sn",sqlite3_errmsg(pDB));

        sqlite3_close(pDB);
        return -1;
    }

  //查找源文件中所有表名    
    ret = sqlite3_exec(pDB,pListTablesNameSel,ListTablesName_callback,pDB,&pError);
    if (ret != SQLITE_OK)
    {
        fprintf(stderr,"list table count error: %s",sqlite3_errmsg(pDB));

        sqlite3_close(pDB);
        return -1;
    }

    return 0;
}

原文链接

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!