private static ArrayList<Application> select(String whereClause, String[] selectionArgs) { ArrayList<Application> applications = new ArrayList<>(); DataAccess da = new DataAccess(); SQLiteDatabase db = da.getReadableDB(); Cursor cursor = null; try { String query = "Select * From " + TableName + " " + whereClause; cursor = db.rawQuery(query, selectionArgs); if (cursor != null && cursor.moveToFirst()) { do { Application app = new Application( cursor.getInt(cursor.getColumnIndex(Id)), cursor.getInt(cursor.getColumnIndex(Uid)), cursor.getString(cursor.getColumnIndex(AppName)), cursor.getString(cursor.getColumnIndex(PackageName)), cursor.getInt(cursor.getColumnIndex(Removed)) == 1); applications.add(app); } while (cursor.moveToNext()); } } catch (MyRuntimeException e) { e.printStackTrace(); } finally { if (cursor != null && !cursor.isClosed()) cursor.close(); if (db != null && db.isOpen()) db.close(); } return applications; }
private static ArrayList<SystemSetting> select(String whereClause, String[] selectionArgs) { ArrayList<SystemSetting> settings = new ArrayList<>(); DataAccess da = new DataAccess(); SQLiteDatabase db = da.getReadableDB(); Cursor cursor = null; try { String query = "Select * From " + TableName + " " + whereClause; cursor = db.rawQuery(query, selectionArgs); if (cursor != null && cursor.moveToFirst()) { do { SystemSetting systemSetting = new SystemSetting( cursor.getInt(cursor.getColumnIndex(Id)), cursor.getInt(cursor.getColumnIndex(Installed)) == 1, cursor.getString(cursor.getColumnIndex(RingingToneUri)), cursor.getString(cursor.getColumnIndex(AlarmRingingTone)), cursor.getInt(cursor.getColumnIndex(VibrateInAlarms)) == 1, cursor.getInt(cursor.getColumnIndex(SoundInAlarms)) == 1); settings.add(systemSetting); } while (cursor.moveToNext()); } } catch (MyRuntimeException e) { e.printStackTrace(); } finally { if (cursor != null && !cursor.isClosed()) cursor.close(); if (db != null && db.isOpen()) db.close(); } return settings; }