sqlite3查询例子

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

#define P3SCAN_DB "/usr/local/conf/as.db"
sqlite3 *p3scan_db = NULL;

int main()
{
        int ret,i,n;
        char *errmsg = NULL,**result = NULL;
        int nrow = 0,ncol = 0;

        if(sqlite3_open(P3SCAN_DB,&p3scan_db))
        {
                sqlite3_free(p3scan_db);
                return -1;
        }

        ret = sqlite3_get_table(p3scan_db,"select blackserverip from blackServer;",&result,&nrow,&ncol,&errmsg);
        sqlite3_free(errmsg);
        if(ret == SQLITE_OK)
        {
                printf("nrow: %d,ncol: %dn",nrow,ncol);
                if(nrow && result)
                {
                        for(i=1; i<=nrow; i++)
                        {
                                printf("%sn",result[i*ncol]);
                        }
                }
                sqlite3_free_table(result);
        }
}

编译：

[root@localhost ~]# gcc -o select_blackserverip select_blackserverip.c -lsqlite3

（编辑：李大同）

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