嵌入式linux调用数据库,嵌入式linux下sqlite3数据库操作

#include int Display(void *para,int n_column,char **column_value,char **column_name)

{

int i;

printf("记录包含 %d 个字段

",n_column);

for( i = 0;i < n_column;i++)

{

printf("字段名:%s 字段值:%s

",column_name[i],column_value[i]);

}

printf("------------------

");

return 0;

}

int main ()

{

char value[200];

sqlite3 *db;

char *errmsg = NULL;

int rc;

rc = sqlite3_open("bb.db",&db);

if(rc)

{

fprintf(stderr, "Can't open sqlite: %s

", sqlite3_errmsg(db));

sqlite3_close(db);

exit(1);

}

else

printf("open sqlite success

");

rc = sqlite3_exec(db,"create table mytable(id,ip);",NULL,NULL,errmsg);

if(rc == SQLITE_OK)

{

printf("create table success

");

}

else

{

printf("create table failure

");

}

sqlite3_exec(db,"insert into mytable(id,ip) values(1,2);",NULL,NULL,errmsg);

sqlite3_exec(db,"select * from mytable",Display,NULL,errmsg);

sqlite3_close(db);

}