android native C++编程实现数据库加密sqlcipher

sqlcipher是sqlite的加版本，分为免费版和收费版。

这里研究的是开源的免费版

https://github.com/sqlcipher/sqlcipher

Android码源默认提供了sqlite的native，jni和java版本，但没有提供sqlcipher，开发用到需要自己添加。

sqlcipher需要配置openssl，写一个android.bp

android_sqlite_cflags = ["-DHAVE_USLEEP=1","-DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=1048576","-DSQLITE_THREADSAFE=1","-DNDEBUG=1","-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1","-DSQLITE_TEMP_STORE=3","-DSQLITE_ENABLE_FTS3_BACKWARDS","-DSQLITE_ENABLE_LOAD_EXTENSION","-DSQLITE_ENABLE_MEMORY_MANAGEMENT","-DSQLITE_ENABLE_COLUMN_METADATA","-DSQLITE_ENABLE_FTS4","-DSQLITE_ENABLE_UNLOCK_NOTIFY","-DSQLITE_ENABLE_RTREE","-DSQLITE_SOUNDEX","-DSQLITE_ENABLE_STAT3","-DSQLITE_ENABLE_FTS4_UNICODE61","-DSQLITE_THREADSAFE","-Wno-unused-parameter","-Wno-pointer-arith","-Wno-unused-variable"
]sqlcipher_cflags = ["-DSQLITE_HAS_CODEC","-DHAVE_FDATASYNC=0","-Dfdatasync=fsync",
]sqlcipher_files = ["src/sqlite3.c"]//APP_STL := c++_shared
//APP_ABI := armeabi-v7a arm64-v8a x86 x86_64
//APP_PLATFORM := android-26// ANDROIDMK TRANSLATION ERROR: unsupported assignment to LOCAL_EXPORT_C_INCLUDES
// LOCAL_EXPORT_C_INCLUDES := $(LOCAL_PATH)/include///LOCAL_SRC_FILES := $(LOCAL_PATH)/lib/arm64-v8a/libcrypto.so
// ANDROIDMK TRANSLATION ERROR: unsupported include
// include $(PREBUILT_SHARED_LIBRARY)
cc_prebuilt_library_shared {name: "libcrypto2",target: {android_arm: {srcs: ["lib/armeabi-v7a/libcrypto.so"],},android_arm64: {srcs: ["lib/arm64-v8a/libcrypto.so"],},},strip: {none:true,},//shared_libs: ["libx", "libxx", "libxxx", "libxxxx"],check_elf_files: false,compile_multilib: "both"//32位和64位都预编译
}cc_library_shared {name: "sqlite3_ext2",host_ldlibs: ["-llog"],srcs: sqlcipher_files,local_include_dirs: ["src","include",],cflags: android_sqlite_cflags + sqlcipher_cflags,//LOCAL_STATIC_LIBRARIES 	:= static-libcryptoshared_libs: ["libcrypto2",  "liblog",],}

详细使用看：

GitHub - blogercn/android_sqlciphe: android natvity C/C++使用的加密数据库sqlciphe

可以用于ndk，可以复制到android源码供C++层开发使用

sqlite数据库修改数据需要提交事务，否则显示成功，但并没有入库。

sqlite3_exec(db, "BEGIN TRANSACTION", NULL, NULL, NULL);

if (rc != SQLITE_OK)

    {

        std::cout << "EventLogServer SQL错误: " << errMsg << std::endl;

        sqlite3_free(errMsg);

        rc = sqlite3_exec(db, "ROLLBACK;", nullptr, nullptr, nullptr);

    }

    else

    {

        rc = sqlite3_exec(db, "COMMIT;", NULL, NULL, NULL);

    }

如下：

int IEventLogServer::insertLog(slog& log)

{

    sqlite3* db;

    int rc = sqlite3_open(LOG_DATABASE, &db);

    if (rc != SQLITE_OK)

    {

        std::cout << "EventLogServer 无法打开数据库: " << sqlite3_errmsg(db) << std::endl;

        sqlite3_close(db);

        return rc;

    }

    rc = sqlite3_exec(db, "BEGIN TRANSACTION", NULL, NULL, NULL); // 开始事务

    if (rc != SQLITE_OK) {

        std::cout << "Failed to begin transaction: " << sqlite3_errmsg(db) << std::endl;

        sqlite3_close(db);

        return rc;

    }

    char* errMsg = nullptr;

    std::string sql = "INSERT INTO " + std::string(LOG_TABLE) +" (Severity, EventID, BaseEventCount, TimeStamp, Source) VALUES (" +

                    std::to_string(log.Severity) + ", " + std::to_string(log.EventID) + ", " +

                    std::to_string(log.BaseEventCount) + ", " + std::to_string(log.TimeStamp) +", '" + log.Source + "');";

                     

    rc = sqlite3_exec(db, sql.c_str(), nullptr, nullptr, &errMsg);

    if (rc != SQLITE_OK)

    {

        std::cout << "EventLogServer SQL错误: " << errMsg << std::endl;

        sqlite3_free(errMsg);

        rc = sqlite3_exec(db, "ROLLBACK;", nullptr, nullptr, nullptr);

    }

    else

    {

        rc = sqlite3_exec(db, "COMMIT;", NULL, NULL, NULL);

    }

    sqlite3_close(db);

    return rc;

}