linux_sqlite3添加新信息，插入信息

来源：互联网发布：涂鸦照片的软件编辑：程序博客网时间：2024/04/28 20:13

#include<stdio.h>

#include <stdlib.h>

#include <sqlite3.h>

void create_table(sqlite3 *db)
{
char *sql;
char *errmsg;
int ret;

sql = "create table if not exists mytable (id integer primary key,name text);";//id为主键，创建mytable
// sql = "create table if not exists mytable (name text primary key,id integer);";

ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(ret != SQLITE_OK)
{
printf("create table error : %s\n",errmsg);
exit(-1);
}
}

void my_add(sqlite3 *db)
{
char sql[100];
char *errmsg;
int ret;
int id;
char name[20];

printf("please input id and name:\n");

scanf("%d%s",&id,name);
getchar();

sprintf(sql,"insert into mytable (id,name)values(%d,'%s');",id,name);
// sprintf(sql,"insert into mytable (name,id)values('%s',%d);",name,id);

ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(ret != SQLITE_OK)
{
printf("insert record error : %s\n",errmsg);
exit(-1);
}
printf("exit!\n");
// exit(1);
#if 0
sql = "insert into mytable (id,name)values(NULL,'zhang');";

ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(ret != SQLITE_OK)
{
printf("insert record error : %s\n",errmsg);
exit(-1);
}

sql = "insert into mytable (id,name)values(NULL,'lin');";

ret = sqlite3_exec(db,sql,NULL,NULL,&errmsg);

if(ret != SQLITE_OK)
{
printf("insert record error : %s\n",errmsg);
exit(-1);
}
#endif
}

0 0