android微信wcdb,android本地数据库，微信数据库WCDB for Android 使用实例

importandroid.content.ContentValues;importandroid.content.Context;importcom.aax.exchange.entity.Favorites;importcom.tencent.wcdb.Cursor;importcom.tencent.wcdb.database.SQLiteDatabase;importjava.util.ArrayList;importjava.util.List;public classFavoritesDBManager {privateWcdbHelper mDBHelper;privateSQLiteDatabase mDB;private String name = "favorites.db";private String password = "xxx";publicFavoritesDBManager(Context context) {

mDBHelper= new WcdbHelper(context,name,password.getBytes(),null,1,null);

mDB=mDBHelper.getWritableDatabase();

addTable();

}public booleanaddFavoritesData(String tradingPair) {try{

mDB.beginTransaction();final String sql = "INSERT INTO favorites VALUES(NULL,?)";

Object[] objects= newObject[]{tradingPair};

mDB.execSQL(sql, objects);

mDB.setTransactionSuccessful();

}catch(Exception e){return false;

}finally{

mDB.endTransaction();

}return true;

}public booleanaddFavoritesData(Favorites favorites) {try{

mDB.beginTransaction();final String sql = "INSERT INTO favorites VALUES(NULL,?)";

Object[] objects= newObject[]{favorites.getTradingPair()};

mDB.execSQL(sql, objects);

mDB.setTransactionSuccessful();

}catch(Exception e){return false;

}finally{

mDB.endTransaction();

}return true;

}public boolean addFavoritesList(Listlist) {try{

mDB.beginTransaction();for(Favorites favorites : list) {

Object[] objects= newObject[]{favorites.getTradingPair()};final String sql = "INSERT INTO favorites VALUES(NULL,?)";

mDB.execSQL(sql, objects);

}

mDB.setTransactionSuccessful();

}catch(Exception e) {return false;

}finally{

mDB.endTransaction();

}return true;

}public booleandelFavoritesByTradingPair(String tradingPair) {try{

mDB.beginTransaction();

mDB.delete("favorites","tradingPair=?",newString[]{tradingPair});

mDB.setTransactionSuccessful();

}catch(Exception e) {return false;

}finally{

mDB.endTransaction();

}return true;

}publicFavorites getFavoritesByTradingPair(String tradingPair){

String sql= "select * from favorites where tradingPair=?";

Cursor cursor= mDB.rawQuery(sql, newString[]{tradingPair});while(cursor.moveToNext()){

Favorites favorites= newFavorites();

favorites.setTradingPair(cursor.getString(cursor.getColumnIndex("tradingPair")));returnfavorites;

}return null;

}public ListgetFavoritesListData() {

List listData = new ArrayList<>();

Cursor c=getAllFavoritesInfo();while(c.moveToNext()) {

Favorites favorites= newFavorites();

favorites.setTradingPair(c.getString(c.getColumnIndex("tradingPair")));

listData.add(favorites);

}

c.close();returnlistData;

}privateCursor getAllFavoritesInfo() {return mDB.rawQuery("SELECT * FROM favorites", null);

}public booleanupdateFavoritesByName(String tradingPair){

ContentValues values= newContentValues();

values.put("tradingPair", tradingPair);int flag = mDB.update("favorites", values, "tradingPair=?", newString[]{tradingPair});if (flag > 0) {return true;

}else{return false;

}

}public voidcloseDB() {

mDB.close();

}publicBoolean deleteDatabase(String name) {returnmDBHelper.onDelete(name);

}public voiddeleteFavoritesData() {

mDB.execSQL("DELETE FROM favorites;");

}public voidaddTable() {

String SQL_CREATE= "CREATE TABLE IF NOT EXISTS favorites (_id INTEGER PRIMARY KEY AUTOINCREMENT , tradingPair VARCHAR(50) )";

mDB.execSQL(SQL_CREATE);

}

}