String[] selectionArgs, String groupBy, String having, String sortOrder) { // We won't bother checking the validity of params here, but you should! // SQLiteQueryBuilder is the helper class that creates the // proper SQL syntax for us. SQLiteQueryBuilder qBuilder = new SQLiteQueryBuilder(); // Set the table we're querying. qBuilder.setTables(DATABASE_TABLE_NAME); // If the query ends in a specific record number, we're // being asked for a specific record, so set the // WHERE clause in our query. if((URI_MATCHER.match(uri)) == SPECIFIC_MESSAGE){ qBuilder.appendWhere("_id=" + uri.getPathLeafId()); } // Set sort order. If none specified, use default. if(TextUtils.isEmpty(sortOrder)){ sortOrder = DEFAULT_SORT_ORDER; } // Make the query. Cursor c = qBuilder.query(mDb, projection, selection, selectionArgs, groupBy, having,
Other popular examples for SQLiteQueryBuilder
150: SQLiteQueryBuilder qBuilder = new SQLiteQueryBuilder();
-
157: qBuilder.setTables(TABLE_ROSTER + " " + QUERY_ALIAS);
-
162: qBuilder.setTables(TABLE_ROSTER + " " + QUERY_ALIAS);
163: qBuilder.appendWhere(RosterConstants.GROUP + "=");
164: qBuilder.appendWhere(url.getPathSegments().get(1));
-
168: qBuilder.setTables(TABLE_ROSTER + " " + QUERY_ALIAS);
-
172: qBuilder.setTables(TABLE_ROSTER + " " + QUERY_ALIAS);
173: qBuilder.appendWhere("_id=");
174: qBuilder.appendWhere(url.getPathSegments().get(1));
-
189: Cursor ret = qBuilder.query(db, projectionIn, selection, selectionArgs,
Full Snippet Info133: SQLiteQueryBuilder qBuilder = new SQLiteQueryBuilder();
-
139: qBuilder.setTables(TABLE_NAME);
-
143: qBuilder.setTables(TABLE_NAME);
144: qBuilder.appendWhere("_id=");
145: qBuilder.appendWhere(uri.getPathSegments().get(SETTINGS_ID));
-
160: Cursor ret = qBuilder.query(db, projection, selection, selectionArgs, null, null, orderBy);
Full Snippet Info62: SQLiteQueryBuilder qb=new SQLiteQueryBuilder();
-
64: qb.setTables(TABLE);
-
75: Cursor c=
Full Snippet Info