caccess数据库源码

#include <stdio.h>
#include <stdlib.h>
#include "CAccess.h"

int main() {
    CAccessDB *db;
    char *errMsg = 0;

    // 打开数据库
    db = CAccess_Open("example.db", &errMsg);
    if (!db) {
        fprintf(stderr, "Can't open database: %s\n", errMsg);
        return 1;
    }

    // 创建表
    char *createTableSQL = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT);";
    CAccess_Execute(db, createTableSQL, &errMsg);
    if (errMsg) {
        fprintf(stderr, "SQL error: %s\n", errMsg);
        CAccess_Close(db);
        return 1;
    }

    // 插入数据
    char *insertSQL = "INSERT INTO users (name) VALUES ('Alice');";
    CAccess_Execute(db, insertSQL, &errMsg);
    if (errMsg) {
        fprintf(stderr, "SQL error: %s\n", errMsg);
        CAccess_Close(db);
        return 1;
    }

    // 查询数据
    char *selectSQL = "SELECT * FROM users;";
    CAccessStmt *stmt = CAccess_Prepare(db, selectSQL, &errMsg);
    if (!stmt) {
        fprintf(stderr, "SQL error: %s\n", errMsg);
        CAccess_Close(db);
        return 1;
    }
    while (CAccess_Step(stmt) == CACCESS_OK) {
        int id = CAccess_ColumnInt(stmt, 0);
        char *name = CAccess_ColumnText(stmt, 1);
        printf("ID: %d, Name: %s\n", id, name);
    }

    // 关闭数据库
    CAccess_Close(db);
    return 0;
}