Sqlite3安装与使用

最新推荐文章于 2021-11-09 23:34:42 发布

语暖心扉

最新推荐文章于 2021-11-09 23:34:42 发布

阅读量400

点赞数

本文链接：https://blog.csdn.net/zat111/article/details/39938585

版权

安装：

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, "打开失败%s\n",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("%s\n", sql);   
    char *select_str = "SELECT";
    char *errorMsg;
    char *str_str = strstr(sql, select_str);
    if(str_str) {
        printf("in it, %s\n", str_str);
        int row = 0, column = 0, i = 0;
        char **result;
        sqlite3_get_table(db, sql, &result, &row, &column, &errorMsg);
        printf("row:%d, column:%d\n", row, column);
        for(; i < column * (row + 1); i++) {
            printf("result[%d]=%s\n", i, result[i]);   
        }  
    }else{
        sqlite3_exec(db, sql, 0, 0, &errorMsg);
    }
    if(errorMsg){
        printf("%s\n", errorMsg);
    }else{
        printf("success!\n");
    }
}