C语言操作sqlite数据库(增删改查)

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

int main()
{
    const char *select_query="select * from users";
    int ret = 0;
    sqlite3 *db = 0;
    char *s;

    //打开数据库，不存在，创建数据库db
    ret = sqlite3_open("./mydb",&db);
    if(ret != SQLITE_OK)
    {
       printf("无法打开数据库n");
       return 1;
    }
    printf("数据库连接成功n");

    //创建表
    ret = sqlite3_exec(db,"create table if not exists users(id int(10),name char(20))",0,&s);
    if(ret !=   SQLITE_OK)
    {
        sqlite3_close(db);
        printf("create errorn");
        return 1;
    }
    printf("create successn");

    //插入数据
    ret = sqlite3_exec(db,"insert into users values(1,'aass')",&s);
    ret += sqlite3_exec(db,"insert into users values(2,'bbbb')","insert into users values(3,'cccc')",&s);
    if(ret != SQLITE_OK)
    {
         sqlite3_close(db);
         printf("insert errorn");
         return 1;
    }
    printf("insert successn");

    //删除
    ret = sqlite3_exec(db,"delete from users where id=1",&s);
    if(ret != SQLITE_OK)
    {
         sqlite3_close(db);
         printf("delete errorn");
         return 1;
    }
    printf("delete successn");

    //更新
    ret = sqlite3_exec(db,"update users set name='qqq' where id=3",&s);
    if(ret != SQLITE_OK)
    {
         sqlite3_close(db);
         printf("update errorn");
         return 1;
    }
    printf("update successn");



    //查询
    int nrow,ncolumn;
    char ** db_result;
    ret = sqlite3_get_table(db,select_query,&db_result,&nrow,&ncolumn,&s);
    if(ret != SQLITE_OK)
    {
        printf("select errorn");
        sqlite3_close(db);
        return 1;
    }
    int i,j;
    for(i=0;i<(nrow+1)*ncolumn;i+=ncolumn)
    {
        for(j=0;j<ncolumn;j++)
        {
             printf("%s ",db_result[i+j]);
        }
        printf("n");
    }
    sqlite3_close(db);
    db = 0;
    return 0;
}

（编辑：李大同）

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