数据库2

/*****************************************************
copyright (C), 2014-2015, Lighting Studio. Co.,     Ltd. 
File name：
Author：Jerey_Jobs    Version:0.1    Date: 
Description：
Funcion List: 
*****************************************************/


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


int create_db(sqlite3 *db)
{
char * errmsg;
char *sql;


sql = "create table if not exists mytable (id integer primary key,name text);";


if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("create table error!: %s\n",errmsg);
exit (-1);
}
return 0;
}


int insert_db(sqlite3 *db)
{
char * errmsg = NULL;
char sql[100];
int id;
char name[10];
int i;


// sql = "insert into mytable (id,name)values(NULL,'huang');";
    for(i = 0;i < 3;i++)
{
   printf("please input id:\n");
scanf("%d",&id);
printf("please input name:\n");
scanf("%s",name);
sprintf(sql,"insert into mytable (id,name)values(%d,'%s');",id,name);


if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))//执行sql
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
}
/* sql = "insert into mytable (id,name)values(NULL,'li');";


if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg);
exit(-1);
}
sql = "insert into mytable (id,name)values(NULL,'zhan');";


if(SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("insert table error! : %s",errmsg):;
exit(-1);
}*/
}


int displaydb(void * para,int col_cnt,char ** col_value,char ** col_name)
{
int i;
printf("total column is %d\n",col_cnt);
for(i = 0;i < col_cnt;i++)
{
printf("col_name : %s--> col_value : %s\n",col_name[i],col_value[i]);
}
printf("－－－－－－－－－－－－－－－－－－－－－－－－－－－－\n");
return 0;
}
int insquire_cb(sqlite3 *db)
{
char *errmsg = NULL;
char *sql;


sql = "select * from mytable;";


if(SQLITE_OK != sqlite3_exec(db,sql,displaydb,NULL,&errmsg))
{
printf("insquire table error! : %s\n",&errmsg);
exit(-1);
}
}
int main()
{
int ret;
sqlite3 *db = NULL;


ret =sqlite3_open("mydatabase.db",&db);


if(SQLITE_OK != ret)
{
perror("sqlite open");
exit(-1);
}
else
{
printf("open database successfully!\n");
}


create_db(db);
insert_db(db);
insquire_cb(db);


sqlite3_close(db);
    return 0;
}