C++中使用sqlite

最新推荐文章于 2025-06-24 09:18:21 发布

原创最新推荐文章于 2025-06-24 09:18:21 发布 · 626 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlite #c++ #callback #sql #database #include

C++ 专栏收录该内容

7 篇文章

订阅专栏

#include <iostream>
#include <stdio.h>
#include <stdlib.h>
#include "./sqlite3_lib/sqlite3.h"

static int _callback_exec(void * notused,int argc, char ** argv, char ** aszColName)
{
    int i;
    for ( i=0; i<argc; i++ )
    {
        printf( "%s = %s/n", aszColName[i], argv[i] == 0 ? "NUL" : argv[i] );
    }
    return 0;
}

void main(int argc,char *argv[])
{

const char * sSQL = "select * from animal;";
const char * sSQL1 = "insert into animal(id) values('233');";
    char * pErrMsg = 0;
    int ret = 0;
    sqlite3 * db = 0;
    ret = sqlite3_open("demo.sqb", &db);
    printf("%d/n",ret);
    if ( ret != SQLITE_OK )
    {
        fprintf(stderr, "Could not open database: %s", sqlite3_errmsg(db));
        exit(1);
    }
    printf("Successfully connected to database/n");
    sqlite3_exec( db, sSQL, _callback_exec, 0, &pErrMsg );
    if ( ret != SQLITE_OK )
    {

fprintf(stderr, "SQL error: %s/n", pErrMsg);
        sqlite3_free(pErrMsg);
    }
    sqlite3_exec( db, sSQL1, _callback_exec, 0, &pErrMsg );
    if ( ret != SQLITE_OK )
    {

fprintf(stderr, "SQL error: %s/n", pErrMsg);
        sqlite3_free(pErrMsg);
    }
    sqlite3_exec( db, sSQL, _callback_exec, 0, &pErrMsg );
    if ( ret != SQLITE_OK )
    {

fprintf(stderr, "SQL error: %s/n", pErrMsg);
        sqlite3_free(pErrMsg);
    }
    sqlite3_close(db);
    db = 0;
    getchar();