public SQLiteDatabase openReader() { return helper.getReadableDatabase(); }
/** * Open the database when the read data. * * @return {@link SQLiteDatabase}. */ protected final SQLiteDatabase getReader() { return liteOpenHelper.getReadableDatabase(); }
/** * Get readable database * * @param helper * @return readable database or null if it failed to create/open */ protected SQLiteDatabase getReadable(SQLiteOpenHelper helper) { try { return helper.getReadableDatabase(); } catch (SQLiteException e1) { // Make second attempt try { return helper.getReadableDatabase(); } catch (SQLiteException e2) { return null; } } }
SQLiteOpenHelper sqLiteOpenHelper = new SQLiteOpenHelper( context, DATABASE_NAME, null, DATABASE_VERSION); SQLiteDatabase sqLiteDatabase = sqLiteOpenHelper.getReadableDatabase(); String query = "SELECT * FROM clients ORDER BY company_name ASC"; // No trailing ';' Cursor cursor = sqLiteDatabase.rawQuery(query, null); ClientCursorAdapter adapter = new ClientCursorAdapter( this, R.layout.clients_listview_row, cursor, 0 ); this.setListAdapter(adapter);
@Override public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) { switch (URI_MATCHER.match(uri)) { case URI_MATCHER_CODE_TWEETS: return sqLiteOpenHelper .getReadableDatabase() .query( TweetsTable.TABLE, projection, selection, selectionArgs, null, null, sortOrder ); default: return null; } }
public ProfileResultAdapter(Context context) { ViewInspector.runtimeComponentMap.get(((ContextThemeWrapper) context).getBaseContext()) .inject(this); mLayoutInflater = LayoutInflater.from(context); String avgsql = "select avg(" + ViewProfile.MEASURE_DURATION + "), " + "avg(" + ViewProfile.LAYOUT_DURATION + "), " + "avg(" + ViewProfile.DRAW_DURATION + ") " + "from " + ViewProfile.TABLE; Cursor cursor = db.getReadableDatabase().rawQuery(avgsql, null); cursor.moveToNext(); mAvgMeasure = cursor.getLong(0) / 1000.0; mAvgLayout = cursor.getLong(1) / 1000.0; mAvgDraw = cursor.getLong(2) / 1000.0; cursor.close(); }
+ "), " + "avg(" + ViewProfile.DRAW_DURATION + ") " + " from " + ViewProfile.TABLE + " where " + ViewProfile.VIEW_HASHCODE + " = ?"; Cursor cursor = db.getReadableDatabase() .rawQuery(sql, new String[] { Integer.toHexString(view.hashCode()) }); if (cursor.moveToNext()) {
/** * Query tables for columns * * @param helper * @param tables * @param columns * @param selection * @param selectionArgs * @return cursor */ protected Cursor query(SQLiteOpenHelper helper, String tables, String[] columns, String selection, String[] selectionArgs) { SQLiteQueryBuilder builder = new SQLiteQueryBuilder(); builder.setTables(tables); return builder.query(helper.getReadableDatabase(), columns, selection, selectionArgs, null, null, null); }
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
database = dbHelper.getReadableDatabase();
public T get(long id) { SQLiteDatabase db = dbHelper.getReadableDatabase(); String where = getIdColumnName() + " = " + id; try (Cursor cursor = db.query(getMergedViewName(), null, where, null, null, null, null, "1")) { if (!cursor.moveToFirst()) return null; return createObjectFrom(cursor); } }
public T get(long id) { SQLiteDatabase db = dbHelper.getReadableDatabase(); String where = getIdColumnName() + " = " + id; try (Cursor cursor = db.query(getTableName(), null, where, null, null, null, null, "1")) { if (!cursor.moveToFirst()) return null; return createObjectFrom(cursor); } }