Android 加密数据库 sqlite

来源：互联网发布：纯k线源码编辑：程序博客网时间：2024/06/07 09:31

下载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);

0 0