public int selectCountDB(int aSelectType, String aParam) { int count = 0; Cursor cursor = null; String[] selectionArgs = {aParam + ""}; switch (aSelectType) { case DBValue.TYPE_SELECT_DAY_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_DAY_COUNT, null); break; case DBValue.TYPE_SELECT_PRE_DAY_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_PRE_DAY_COUNT, selectionArgs); break; case DBValue.TYPE_SELECT_TOTAL_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_TOTAL_COUNT, null); break; case DBValue.TYPE_SELECT_URL_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_URL_COUNT, null); break; case DBValue.TYPE_SELECT_DISLIKE_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_DISLIKE_COUNT, null); break; case DBValue.TYPE_SELECT_LIKE_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_LIKE_COUNT, null); break; case DBValue.TYPE_SELECT_DISLIKE_PACKAGE_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_DISLIKE_PACKAGE_COUNT, null); break; case DBValue.TYPE_SELECT_PACKAGE_INFO_COUNT: cursor = mDbManager.query(DBValue.SQL_SELECT_PACKAGE_INFO_COUNT, selectionArgs); break; default: break; } if (null == cursor) { return count; } cursor.moveToFirst(); count = cursor.getInt(0); cursor.close(); return count; }
public Cursor selectDBData(int aSelectType, String aParam) { String[] selectionArgs = {aParam + ""}; switch (aSelectType) { case DBValue.TYPE_SELECT_PACKAGE_INFO: return mDbManager.query(DBValue.SQL_SELECT_PACKAGE_INFO, selectionArgs); case DBValue.TYPE_SELECT_FILTER_PACKAGE: return mDbManager.query(DBValue.SQL_SELECT_FILTERPKG_PACKAGENAME, selectionArgs); case DBValue.TYPE_SELECT_FILTERWORD_INFO: return mDbManager.query(DBValue.SQL_SELECT_FILTERWORD_INFO, selectionArgs); case DBValue.TYPE_SELECT_FILTERPKG_INFO: return mDbManager.query(DBValue.SQL_SELECT_FILTERPKG_INFO, null); case DBValue.TYPE_SELECT_DAILY_NOTI_INFO: return mDbManager.query(DBValue.SQL_SELECT_DAILY_NOTI_INFO, null); case DBValue.TYPE_SELECT_PACKAGE_NOTI_INFO: return mDbManager.query(DBValue.SQL_SELECT_PACKAGE_NOTI_COUNT, null); case DBValue.TYPE_SELECT_DISLIKE_PKG_INFO: return mDbManager.query(DBValue.SQL_SELECT_DISLIKE_PKG_INFO, null); case DBValue.TYPE_SELECT_NOTI_INFO: return mDbManager.query(DBValue.SQL_SELECT_NOTI_INFO, null); default: break; } return null; }