public long create(LotteryApp accessInfo) { ContentValues values = new ContentValues(); values.put(AccessInfoColumn.USERID, accessInfo.getWeiboUserID()); values.put(AccessInfoColumn.ACCESS_TOKEN, accessInfo.getAccessToken()); values.put(AccessInfoColumn.ACCESS_SECRET, accessInfo.getAccessSecret()); return newsDB.insert(DBHelper.ACCESSLIB_TABLE, null, values); }
public boolean update(LotteryApp accessInfo) { ContentValues values = new ContentValues(); values.put(AccessInfoColumn.USERID, accessInfo.getWeiboUserID()); values.put(AccessInfoColumn.ACCESS_TOKEN, accessInfo.getAccessToken()); values.put(AccessInfoColumn.ACCESS_SECRET, accessInfo.getAccessSecret()); String whereClause = AccessInfoColumn.USERID + "=" + accessInfo.getWeiboUserID(); return newsDB.update(DBHelper.ACCESSLIB_TABLE, values, whereClause, null) > 0; }
public ArrayList<LotteryApp> getAccessInfos() { ArrayList<LotteryApp> list = new ArrayList<LotteryApp>(); LotteryApp accessInfo = null; Cursor cursor = newsDB.query( DBHelper.ACCESSLIB_TABLE, AccessInfoColumn.PROJECTION, null, null, null, null, null); if (cursor.getCount() > 0) { for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { accessInfo = new LotteryApp(); accessInfo.setWeiboUserID(cursor.getString(AccessInfoColumn.USERID_COLUMN)); accessInfo.setAccessToken(cursor.getString(AccessInfoColumn.ACCESS_TOKEN_COLUMN)); accessInfo.setAccessSecret(cursor.getString(AccessInfoColumn.ACCESS_SECRET_COLUMN)); list.add(accessInfo); } } cursor.close(); cursor = null; return list; }