最近在做一个嵌入式设备,因为设计密码问题,所以需要对sqlite数据库进行加密,但是找了好多例子都不能达到要求,好在最后终于找到一可用资源,本人亲测可用。

 源码下下来包含了加密插件的源码还有一个测试的程序,首先需要编译sqlitecipher.pro项目了,编译debug和release后分别把生成的sqlitecipherd.dll 和sqlitecipher.dll 拷到对应的qt安装目录的sql驱动插件目录下plugins/sqldrivers下,就能在程序里进行使用了。
1.检查 QtCipherSqlitePlugin 是否成功加载
我们可以使用下面的代码检查 QtCipherSqlitePlugin 是否成功加载:
( "QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7", "SQLITECIPHER")
DB File Path is: "C:/Users/Bozone/Documents/test_c.db"
1: "AAA"
2: "BBB"
3: "CCC"
4: "DDD"
5: "EEE"
6: "FFF"
7: "GGG"
----------
 
1: "ZZZ"
2: "BBB"
3: "CCC"
4: "DDD"
5: "EEE"
6: "FFF"
7: "GGG"
----------
 
1: "ZZZ"
2: "BBB"
3: "CCC"
5: "EEE"
6: "FFF"
7: "GGG"
Press <RETURN> to close this window...
 
 
 
()::C++
3
6
9
= addDatabase);
setDatabaseName);
setPassword);
setConnectOptions);
dbconn())     << dbconn().    CONNECTION_FAILEDC++
3
6
9
= addDatabase);
setDatabaseName);
setPassword);
setConnectOptions);
dbconn())     << dbconn().    CONNECTION_FAILEDC++
3
6
9
= addDatabase);
setDatabaseName);
setPassword);
setConnectOptions);
dbconn())     << dbconn().    CONNECTION_FAILED