int main(int argc, char* argv[])
{
if(argc <2) {
printf("select [select/insert]\n");
exit(1);
}
if(0 == strcmp(argv[1], "select")){
printf("execute select sql\n");
select_sql();
}
else if(0 == strcmp(argv[1], "stores")){
printf("execute stores\n");
stores_sql();
}
else if(0 == strcmp(argv[1], "insert")){
printf("execute insert the number is %d\n", atoi(argv[2]));
insert_sql(atoi(argv[2]));
}
return 0;
}
int main(int argc, const char *argv[])
{
sqlite3 *dbp;
char *errmsg;
int flag = 0;
char **pazResult;
int row;
int column;
int i,j;
char buf[128];
int id = 10005;
char name[64] = "xiaoming";
float english = 99;
if(SQLITE_OK != sqlite3_open("my.db",&dbp) ){
puts(sqlite3_errmsg(dbp));
return -1;
}
if(SQLITE_OK != sqlite3_exec(dbp,
"create table stu(id integer primary key,name text,english real NULL);",NULL,NULL,&errmsg) ){
puts(errmsg);
}
if(SQLITE_OK != sqlite3_exec(dbp,
"insert into stu (id,name,english) values(10000,'li',59);",NULL,NULL,&errmsg) ){
puts(errmsg);
}
if(SQLITE_OK != sqlite3_exec(dbp,
"insert into stu (id,name,english) values(10001,'xiaoming',100);",NULL,NULL,&errmsg) ){
puts(errmsg);
}
if(SQLITE_OK != sqlite3_exec(dbp,
"insert into stu (id,name,english) values(10002,'xiaoli',70);",NULL,NULL,&errmsg) ){
puts(errmsg);
}
bzero(buf,sizeof(buf));
sprintf(buf,"insert into stu (id,name,english) values(%d,'%s',%.2f);",id,name,english);
if(SQLITE_OK != sqlite3_exec(dbp,
buf,NULL,NULL,&errmsg) ){
puts(errmsg);
}
insert_sql(dbp,10007,"zhangsan",57);
flag = 0;
if(SQLITE_OK != sqlite3_exec(dbp,
"select * from stu;",callback,(void *)&flag,&errmsg) ){
puts(errmsg);
}
flag = 0;
if(SQLITE_OK != sqlite3_exec(dbp,
"select * from stu;",callback,(void *)&flag,&errmsg) ){
puts(errmsg);
}
puts("/**************************/");
if(SQLITE_OK != sqlite3_get_table(dbp,
"select * from stu;",&pazResult,&row,&column,&errmsg)){
puts(errmsg);
}
for(j = 0;j <= row;j ++){
for(i = column * j;i < column *(j + 1);i ++ ){
printf("%s\t",pazResult[i]);
}
printf("\n");
}
sqlite3_free_table(pazResult);
if(SQLITE_OK != sqlite3_close(dbp) ){
puts(sqlite3_errmsg(dbp));
return -1;
}
return 0;
}
