Android 加密数据库 sqlite

下载sqlcipher-for-android-community-v3.2.0.zip

解压后复制相关文件到项目中

assets/icudt46l.zip

libs/armeabi/libdatabase_sqlcipher.so

libs/armeabi/libsqlcipher_android.so

libs/armeabi/libstlport_shared.so

 

 

private SQLiteDatabase db;
private Context mContext;

SQLiteDatabase.loadLibs(mContext);
final mySqlite mSqlite = new mySqlite(mContext, DATABASEPATH, null, 1);
db = mSqlite.getWritableDatabase(PASSWORD);

//事务
try{
	ArrayList<String> list = new ArrayList<String>();
        //......添加SQL语句	
        db.beginTransaction();
	for (String cmd : list) {
		db.execSQL(cmd);
	}
	db.setTransactionSuccessful();
}catch(Exception e){
						
}finally{
	db.endTransaction();
}

//查询
Cursor cursor = db.rawQuery("SELECT rowid,* FROM th_ALH WHERE backupflag = 0", null);
if(cursor.moveToFirst()){
	do{
		
//		int id = cursor.getInt(0);
//		String update = "UPDATE th_ALH SET backupflag = 1 WHERE rowid = "+String.valueOf(id);
//		successlist.add(update);
//		
//		String RawId = cursor.getString(1);
//		String name = cursor.getString(2);
//		String number = cursor.getString(3);
//		int sType = cursor.getInt(4);
//		
//		String insert = "INSERT INTO th_ALH VALUES('id','name','number',sType)";
//		insert = insert.replace("id", RawId);
//        insert = insert.replace("name", name);
//        insert = insert.replace("number", number);
//        insert = insert.replace("sType", String.valueOf(sType));
//        
//        nList.add(insert);
        
	}while(cursor.moveToNext());
}
cursor.close();

//执行
Cursor cursor = db.rawQuery("SELECT rowid,* FROM th_ALH WHERE backupflag = 0", null);