c语言操作数据库

        #include <stdio.h>
    #include <stdlib.h>
    #include "sqlite3.h"
    
    char path[100] = "C:\\Users\\yincheng01\\Desktop\\1.db";
    
    void main()
    {
        sqlite3 *db = NULL;//数据库指针
        int ret = sqlite3_open(path, &db);//打开数据库
        if (ret!= SQLITE_OK)
        {
            printf("文件打开失败 ");
        }
        else
        {
            printf("文件打开成功 ");
    
            //char *sql = "insert into mytable(id, value) values(2, 'Jenny');";
            //char *sql = "insert into mytable(id, value) values(2, 'Jenny');";
    
            char *sql = "create table mytableX11(id integer primary key, value text);";
            char *sql1 = "insert into mytableX11(id, value) values(12, 'J1enny');";
            char *sql2 = "insert into mytableX11(id, value) values(22, 'J2enny');";
            //char *sql3 = "delete * from  mytableX1;";//清空
            char *sql3 = "delete  from  mytableX11 where id =12;";
            ret = sqlite3_exec(db, sql, 0, 0, NULL);
            ret = sqlite3_exec(db, sql1, 0, 0, NULL);
            ret = sqlite3_exec(db, sql2, 0, 0, NULL);
            ret = sqlite3_exec(db, sql3, 0, 0, NULL);
            if (ret != SQLITE_OK)
            {
                printf("sql执行失败 ");
    
            }
    
            sqlite3_close(db);//关闭数据库
        }
        system("pause");
    }

转载于:https://www.cnblogs.com/lhfen/p/6082174.html