public static String stringForQuery(SQLiteDatabase paramSQLiteDatabase, String paramString, String[] paramArrayOfString) { paramSQLiteDatabase = paramSQLiteDatabase.compileStatement(paramString); try { paramString = stringForQuery(paramSQLiteDatabase, paramArrayOfString); return paramString; } finally { paramSQLiteDatabase.close(); } }
public static ParcelFileDescriptor blobFileDescriptorForQuery(SQLiteDatabase paramSQLiteDatabase, String paramString, String[] paramArrayOfString) { paramSQLiteDatabase = paramSQLiteDatabase.compileStatement(paramString); try { paramString = blobFileDescriptorForQuery(paramSQLiteDatabase, paramArrayOfString); return paramString; } finally { paramSQLiteDatabase.close(); } }
private SQLiteStatement getStatement(boolean paramBoolean) { if (paramBoolean) { if (mReplaceStatement == null) { if (mInsertSQL == null) { buildSQL(); } String str = "INSERT OR REPLACE" + mInsertSQL.substring(6); mReplaceStatement = mDb.compileStatement(str); } return mReplaceStatement; } if (mInsertStatement == null) { if (mInsertSQL == null) { buildSQL(); } mInsertStatement = mDb.compileStatement(mInsertSQL); } return mInsertStatement; }
private void buildSQL() { Object localObject1 = null; StringBuilder localStringBuilder1 = new StringBuilder(128); localStringBuilder1.append("INSERT INTO "); localStringBuilder1.append(mTableName); localStringBuilder1.append(" ("); StringBuilder localStringBuilder2 = new StringBuilder(128); localStringBuilder2.append("VALUES ("); Cursor localCursor; for (;;) { try { localCursor = mDb.rawQuery("PRAGMA table_info(" + mTableName + ")", null); localObject1 = localCursor; mColumns = new HashMap(localCursor.getCount()); int i = 1; localObject1 = localCursor; if (!localCursor.moveToNext()) { break; } localObject1 = localCursor; String str1 = localCursor.getString(1); localObject1 = localCursor; String str3 = localCursor.getString(4); localObject1 = localCursor; mColumns.put(str1, Integer.valueOf(i)); localObject1 = localCursor; localStringBuilder1.append("'"); localObject1 = localCursor; localStringBuilder1.append(str1); localObject1 = localCursor; localStringBuilder1.append("'"); if (str3 == null) { localObject1 = localCursor; localStringBuilder2.append("?"); localObject1 = localCursor; if (i == localCursor.getCount()) { str1 = ") "; localObject1 = localCursor; localStringBuilder1.append(str1); localObject1 = localCursor; if (i != localCursor.getCount()) { break label335; } str1 = ");"; localObject1 = localCursor; localStringBuilder2.append(str1); i += 1; } } else { localObject1 = localCursor; localStringBuilder2.append("COALESCE(?, "); localObject1 = localCursor; localStringBuilder2.append(str3); localObject1 = localCursor; localStringBuilder2.append(")"); continue; } str2 = ", "; } finally { if (localObject1 != null) { ((Cursor)localObject1).close(); } } continue; label335: String str2 = ", "; } if (localCursor != null) { localCursor.close(); } localStringBuilder1.append(localStringBuilder2); mInsertSQL = localStringBuilder1.toString(); }