Dev++软件连接Sqlite

ops/2024/9/23 9:36:00/

sqlite_0">Dev++中的C语言使用连接sqlite 数据库

sqlite3dllsqlite3h_1">1.下载sqlite3.dll和sqlite3.h

sqlite3.dll类似于.c文件，封装了函数的原型。
sqlite3.h库文件声明函数。

官网地址下载：sqlite

sqlite-amalgamation-3460000.zip
sqlite-dll-win-x64-3460000.zip

2.新建c项目

sqlite3dll_10">1. sqlite3.dll文件添加到项目中

    项目-->项目属性-->参数-->加入库或对象，选择sqlite3.dll后确定。我的路径："D:/Program Files (x86)/Dev-Cpp/MinGW64/lib/sqlite3.dll"

sqlite3hhttpsimgblogcsdnimgcndirect61d4e046420e44cca2218d260b8b80fbpngpic_center_13">2. sqlite3.h文件放到项目文件夹中

3.更换main.c代码

#include <stdio.h>
#include "sqlite3.h " //自定义的库文件使用""void check_db_error1(int rc, const char *errmsg, sqlite3 *db) {if (rc != SQLITE_OK) {fprintf(stderr, "SQL error: %s\n", errmsg);sqlite3_free((void*)errmsg);sqlite3_close(db);}
}int main() {sqlite3 *db;char *errmsg = 0;int rc;// 打开数据库，如果不存在则创建rc = sqlite3_open("test.db", &db);if (rc != SQLITE_OK) {fprintf(stderr, "Cannot open database: %s\n", sqlite3_errmsg(db));sqlite3_close(db);return 1;}// 创建表const char *create_table_sql = "CREATE TABLE IF NOT EXISTS People (""ID INTEGER PRIMARY KEY AUTOINCREMENT, ""Name TEXT NOT NULL, ""Age INTEGER NOT NULL, ""Date TEXT NOT NULL);";rc = sqlite3_exec(db, create_table_sql, 0, 0, &errmsg);check_db_error1(rc, errmsg, db);printf("Table created successfully.\n");// 插入数据const char *insert_data_sql = "INSERT INTO People (Name, Age, Date) VALUES ('Alice', 30, '2024-06-27');";rc = sqlite3_exec(db, insert_data_sql, 0, 0, &errmsg);check_db_error(rc, errmsg, db);printf("Data inserted successfully.\n");// 关闭数据库sqlite3_close(db);return 0;
}