只有增删改
#include<stdio.h>
#include<string.h>
#include<sqlite3.h>
#include<stdlib.h>char *insert_db();
char *delete_db();
char *update_db();
int main (int argc, const char *argv[])
{
//创建并打开数据库
sqlite3 *db = NULL;
if(sqlite3_open("./test.db",&db) != SQLITE_OK)
{
printf("line :%d sqlite3_open:[%d]%s\n",__LINE__,sqlite3_errcode(db),sqlite3_errmsg(db));
return -1;
}
printf("sqlite3_open success\n");
//先创建数据库表
char sql[128] = "create table if not exists stu (id int ,name char,score float)";
char *errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
{
printf("line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
return -1;