12.31

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


void create_table(sqlite3 * db)
{
char * errmsg = NULL;
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("operate failed: %s\n",errmsg);
exit(-1);
}

}


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


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


if( SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("operate failed: %s\n",errmsg);
exit(-1);
}

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


if( SQLITE_OK != sqlite3_exec(db,sql,NULL,NULL,&errmsg))
{
printf("inesrt failed: %s\n",errmsg);
exit(-1);
}


}


int displaycb(void * para,int n_col,char ** column_value,char ** column_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",column_name[i],column_value[i]);
}


printf("---------------------------\n");


return 0;
}


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


sql = "select * from mytable;";


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


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


sql = "delete from mytable;";


if( SQLITE_OK != sqlite3_exec(db,sql,displaycb,NULL,&errmsg))
{
printf("delete failed: %S\n",errmsg);
exit(-1);
}
else
{
printf("delete ok!\n");
}

}


int main()
{


sqlite3 * db;

//鎵撳紑鏁版嵁搴? if( SQLITE_OK != sqlite3_open("mydatabase",&db))
{
printf("open database failed:%s \n",sqlite3_errmsg(db));
}
else
{
printf("open datebase successed!\n");
}


//鍒涘缓琛? create_table(db);

//鎻掑叆鏁版嵁
insert_record(db);

//浣跨敤鍥炴帀鍑芥暟
inquire_usecb(db); 
    
delete_table(db); 
//鍏抽棴鏁版嵁搴?
sqlite3_close(db);


return 0;
}