在 linux 上安装 sqlite 数据库
实例代码(test_sqlite.h,test_main.c)
test_sqlite.h:
#include <sqlite3.h>
sqlite3 *open_sqlite_db(char *dbname);
void create_sqlite_table(sqlite3 *db,char *tablename,char *SQL);
void insert_sqlite_table(sqlite3 *db,char *tablename,char *str);
void query_sqlite_table(sqlite3 *db,char *tablename);
void close_sqlite_db(sqlite3 *db);
sqlite3 *open_sqlite_db(char *dbname)
{
int rc;
sqlite3 *db=NULL;
rc=sqlite3_open(dbname,&db);
return db;
}
void create_sqlite_table(sqlite3 *db,char *tablename,char *SQL)
{
char sql[1024];
char *errmsg;
sprintf(sql,"CREATE TABLE %s(%s);",tablename,SQL);
sqlite3_exec(db,sql,0,0,&errmsg);
}
void insert_sqlite_table(sqlite3 *db,char *tablename,char *str)
{
char sql[1024];
char *errmsg;
sprintf(sql,"INSERT INTO %s VALUES(null,%s);",tablename,str);
sqlite3_exec(db,sql,0,0,&errmsg);
}
/*
查询数据库
db
中
tablename
表中的内容
*/
void query_sqlite_table(sqlite3 *db,char *tablename)
{
char sql[1024];
int nrow = 0, ncolumn = 0;
char *errmsg;
char **azResult;
int i=0,j=0;
sprintf(sql,"SELECT * FROM %s",tablename);
sqlite3_get_table(db,sql,&azResult, &nrow , &ncolumn , &errmsg );