linux 下C 操作sqlite环境搭建（ubuntu）

1.安装sqlite

a.首先更新源

sudo apt-get update

b.然后安装sqlite3

sudo apt-get install sqlite3

c.再安装Sqlite3编译需要的工具包

sudo apt-get install libsqlite3-dev

d.查看是否安装成功

sqlite3 -version

---

2.测试

a.创建c文件

vi test.c

#include <stdio.h>
#include <sqlite3.h>

int main(int argc, char* argv[])
{
   sqlite3 *db;
   char *zErrMsg = 0;
   int rc;
   printf("hello");
   rc = sqlite3_open("test.db", &db);

   if( rc )
   {
      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
      exit(0);
   }else
   {
      fprintf(stderr, "Opened database successfully\n");
   }
   sqlite3_close(db);
   return 0;
}

b.编译

 gcc -o test test.c -lsqlite3

c.运行

./test

可以看到运行结果

stu@ubuntu:~/zhangbing$ ./test
Opened database successfully

---

3.codeblock中测试

a.创建工程sqlite_test
b.添加静态库路径

依次点击project–>build options–>Linker setting–>Add
找到静态库（libsqlite3.so）路径
search–> libsqlite3.so
找到之后添加就可以了
c.添加测试代码

#include <stdio.h>
#include <sqlite3.h>

int main(int argc, char* argv[])
{
   sqlite3 *db;
   char *zErrMsg = 0;
   int rc;
   printf("hello");
   rc = sqlite3_open("test.db", &db);

   if( rc )
   {
      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
      exit(0);
   }else
   {
      fprintf(stderr, "Opened database successfully\n");
   }
   sqlite3_close(db);
   return 0;
}

d.编译运行
可以看到结果

Opened database successfully