db.execsql在java对应_Java SQLiteDatabase.rawExecSQL方法代码示例

import net.sqlcipher.database.SQLiteDatabase; //导入方法依赖的package包/类

/**

* Replaces this database with a version encrypted with the supplied

* passphrase, deleting the original. Do not call this while the database

* is open, which includes during any Room migrations.

*

* The passphrase is untouched in this call. If you are going to turn around

* and use it with SafeHelperFactory.fromUser(), fromUser() will clear the

* passphrase. If not, please set all bytes of the passphrase to 0 or something

* to clear out the passphrase.

*

* @param ctxt a Context

* @param originalFile a File pointing to the database

* @param passphrase the passphrase from the user

* @throws IOException

*/

public static void encrypt(Context ctxt, File originalFile, char[] passphrase)

throws IOException {

SQLiteDatabase.loadLibs(ctxt);

if (originalFile.exists()) {

File newFile=

File.createTempFile("sqlcipherutils", "tmp",

ctxt.getCacheDir());

SQLiteDatabase db=

SQLiteDatabase.openDatabase(originalFile.getAbsolutePath(),

"", null, SQLiteDatabase.OPEN_READWRITE);

db.rawExecSQL("ATTACH DATABASE '"+newFile.getAbsolutePath()+

"' AS encrypted KEY '"+String.valueOf(passphrase)+"'");

db.rawExecSQL("SELECT sqlcipher_export('encrypted')");

db.rawExecSQL("DETACH DATABASE encrypted");

int version=db.getVersion();

db.close();

db=SQLiteDatabase.openDatabase(newFile.getAbsolutePath(), passphrase,

null, SQLiteDatabase.OPEN_READWRITE);

db.setVersion(version);

db.close();

originalFile.delete();

newFile.renameTo(originalFile);

}

}