sqlite数据库连接

 1 #include <stdio.h>
 2 #include <stdlib.h>
 3 #include "sqlite3.h"
 4 
 5 char path[100] = "C:\\Users\\Chien\\Desktop\\1.db";
 6 
 7 int main(void)
 8 {
 9     //创建一个数据库指针
10     sqlite3* db = NULL;
11 
12     //打开数据库
13     int ret = sqlite3_open(path, &db);
14 
15     if (ret != SQLITE_OK)
16     {
17         printf("文件打开失败");
18     }
19     else
20     {
21         printf("文件打开成功");
22         char* sql = "insert into mytable(id, value) values(2, 'chien');";
23         int ret = sqlite3_exec(db, sql, 0, 0, NULL);
24 
25         if (ret != SQLITE_OK)
26         {
27             printf("sql执行失败");
28         }
29 
30         //关闭数据库;
31         sqlite3_close(db);
32     }
33 
34     system("pause");
35     return 0;
36 }