Sqlite3安装与使用

sudo apt-get install sqlite3 libsqlite3-dev

使用：

//gcc test.c -o m -l sqlite3
#include <stdio.h>
#include <string.h>
#include "sqlite3.h"
 
void sqlite_test();
char query(sqlite3 *db,const char *sql);
 
int main() {
    sqlite_test(); 
}
 
void sqlite_test() {
    sqlite3 *db;
    int rc;
    rc = sqlite3_open("sqlite.sqlite3",&db);
    if(rc) {
        fprintf(stderr,"打开失败%sn",sqlite3_errmsg(db));
        sqlite3_close(db);
    }else {
        printf("成功n");
        char *sql = "CREATE TABLE IF NOT EXISTS test(
                    id INTEGER PRIMARY KEY,
                    uid INTEGER,
                    nickname VARCHAR(12),
                    latitude FLOAT
        )";
        query(db,sql);
        sql = "INSERT INTO test(uid,nickname,latitude)VALUES(1,'abcdefg',1.234)";
        query(db,sql);
        sql = "SELECT * FROM test";
        query(db,sql);
    }
}
char query(sqlite3 *db,const char *sql) {
    printf("%sn",sql);   
    char *select_str = "SELECT";
    char *errorMsg;
    char *str_str = strstr(sql,select_str);
    if(str_str) {
        printf("in it,%sn",str_str);
        int row = 0,column = 0,i = 0;
        char **result;
        sqlite3_get_table(db,sql,&result,&row,&column,&errorMsg);
        printf("row:%d,column:%dn",row,column);
        for(; i < column * (row + 1); i++) {
            printf("result[%d]=%sn",i,result[i]);   
        }  
    }else{
        sqlite3_exec(db,&errorMsg);
    }
    if(errorMsg){
        printf("%sn",errorMsg);
    }else{
        printf("success!n");
    }
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!