12.21

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


void create_table(sqlite3 *db)
{
char *sql;
char *errmsg=NULL;




sql = "create table if not exists mytable (id integer primary key,name txt);";
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}


int delete_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;




}


int insert_record(sqlite3 *db)
{
char *errmsg=NULL;
char sql[100];
int n;
char str[20];


printf("input :");
scanf("%d",&n);
scanf("%s",str);


sprintf(sql,"insert into mytable (id,name) values(%d,'%s');",n,str);
if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}


int displaycb(void *para,int n_col,char **col_value,char **col_name)
{
    int i;
printf("total column is %d\n",n_col);


for(i=0;i<n_col;i++)
{
   printf("col_name:%s-->col_val:%s\n",col_name[i],col_value[i]);
}
    printf("=================================\n");


return 0;
}


int inquire_usecd(sqlite3 *db)
{
    char *sql;
char *errmsg=NULL;


sql="select * from mytable;";
if(SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
{
printf("operator failed :%s\n",errmsg);
exit(-1);
}
}


int main()
{
sqlite3 *db = NULL;
int ret;


ret = sqlite3_open("mydatabase.db",&db);
if(ret != SQLITE_OK)
{
perror("sqlite open");
}
else
{
printf("open sqlite3 database successfully!\n");
}


create_table(db);
insert_record(db);
inquire_usecd(db);
}