软件可以到官网下载:
http://www.sqlite.org/download.html
我安装的版本是:sqlite-autoconf-3071502.tar.gz
解压:tar -xvf sqlite-autoconf-3071502.tar.gz
进入目录:cd sqlite-autoconf-3071502
新建一个安装目录:mkdri my_install
执行:./configure --prefix=安装目录
会自动生成Makefile文件
编译并安装:make && make install
如果这时候使用:gcc sqlitest.c -o sqlitest
会出现错误:
sqlitest.c:3:25: fatal error: sqlite3.h: No such file or directory
解决办法:
将头文件复制到系统的include中:
cp 安装目录/include/sqlite3.h /usr/include
这时候再测试一下:gcc sqlitest.c -o sqlitest
会出现错误:
/tmp/ccSaqYiI.o: In function `main':
sqlitest.c:(.text+0x39): undefined reference to `sqlite3_open'
sqlitest.c:(.text+0x50): undefined reference to `sqlite3_errmsg'
sqlitest.c:(.text+0xad): undefined reference to `sqlite3_exec'
sqlitest.c:(.text+0xde): undefined reference to `sqlite3_free'
sqlitest.c:(.text+0x10a): undefined reference to `sqlite3_exec'
sqlitest.c:(.text+0x14d): undefined reference to `sqlite3_exec'
sqlitest.c:(.text+0x19c): undefined reference to `sqlite3_exec'
sqlitest.c:(.text+0x1a8): undefined reference to `sqlite3_close'
这是因为没有库文件
解决办法:
cp /安装目录/lib/libsqlite3.so /usr/lib
libsqlite3.so是链接文件,一般会自动把libsqlite3.so.8和libsqlite3.so.8.0.6一起复制过去,如果没有的话就手动复制吧。
编译时,使用:
gcc sqlitest.c -o sqlitest -l sqlite3
测试代码:
#include