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;
}
