20170118

数据库的相关操作

#include <stdio.h>

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


int main(int argc,char** argv)
{
    int i;
    int ret;
    int id;
    char name[1024];
    int age;
    sqlite3 * db;
    char * errmsg;
    char sql[1024];


    ret = sqlite3_open(argv[1],&db);
    if(ret != SQLITE_OK)
    {
        printf("error!");
exit(1);
    }


    sqlite3_exec(db,"create table student(id integer primary key,name text,age integer)",NULL,NULL,&errmsg);
#if 0
    for(i = 0;i < 3;i++)
    {
        printf("please input id\n");
scanf("%d",&id);
        printf("please input name\n");
scanf("%s",name);
        printf("please input age\n");
scanf("%d",&age);
sprintf(sql,"insert into student(id,name,age) values(%d,'%s',%d)",id,name,age);
printf("%s\n",sql);
sqlite3_exec(db,sql,NULL,NULL,&errmsg);
    }
#endif
    aqlite3_exec(db,"select * from student",handle_result,"hello world",&me)
    sqlite3_close(db);


    return 0;
}