Java DatabaseUtilsCompat.appendSelectionArgs方法代码示例

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
@Override
public Loader<List<com.rks.musicx.data.model.Album>> onCreateLoader(int id, Bundle args) {
    if (id == albumLoaders) {
        AlbumLoader albumLoader = new AlbumLoader(getContext());
        String[] selectargs = getSelectionArgs();
        String selection = getSelection();
        if (artist.getName() != null) {
            selection = DatabaseUtilsCompat.concatenateWhere(selection, MediaStore.Audio.Albums.ARTIST + " = ?");
            selectargs = DatabaseUtilsCompat.appendSelectionArgs(selectargs, new String[]{artist.getName()});
        }
        albumLoader.setSortOrder(Extras.getInstance().getArtistAlbumSort());
        albumLoader.filterartistsong(selection, selectargs);
        return albumLoader;
    }
    return null;
}
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
@Nullable
protected Cursor getCursor(Uri musicUri, String[] projection, String selection, String[] selectionArgs, String filteredFieldName, String filter, String orderBy) {
    if (!Utils.checkPermission(getContext(), Manifest.permission.READ_EXTERNAL_STORAGE)) {
        return null;
    }

    Cursor cursor;
    if (filter != null) {
        if (filter.equals("")) {
            return null; // empty filter means that we don't want any result
        }
        selection = DatabaseUtilsCompat.concatenateWhere(selection, filteredFieldName + " LIKE ?");
        selectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs, new String[]{"%" + filter + "%"});

    }

    cursor = getContext().getContentResolver().query(musicUri, projection,
            selection, selectionArgs,
            orderBy);


    return cursor;
}
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
private Cursor getAlbumCursor() {

        Uri musicUri = MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI;

        String selection = getSelectionString();
        String[] selectionArgs = getSelectionArgs();
        if (mArtist != null) {
            selection = DatabaseUtilsCompat.concatenateWhere(selection, MediaStore.Audio.Albums.ARTIST + " = ?");
            selectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs, new String[]{mArtist});

        }

        String fieldName = MediaStore.Audio.Albums.ALBUM;
        String filter = getFilter();
        return getCursor(musicUri, sProjection, selection, selectionArgs, fieldName, filter);
    }
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
@Nullable
private Cursor getCursor(Uri musicUri, String[] projection, String selection, String[] selectionArgs, String filteredFieldName, String filter, String orderBy) {
    if (!Permissions.checkPermission(getContext())) {
        return null;
    }


    if (filter != null) {
        if ("".equals(filter)) {
            return null; // empty filter means that we don't want any result
        }
        selection = DatabaseUtilsCompat.concatenateWhere(selection, filteredFieldName + " LIKE ?");
        selectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs, new String[]{"%" + filter + "%"});

    }


    return getContext().getContentResolver().query(musicUri, projection, selection, selectionArgs, orderBy);
}
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
/**
 * Handle incoming queries.
 */
@Override
public Cursor query(Uri uri, String[] projection, String selection,
        String[] selectionArgs, String sortOrder) {

    // Constructs a new query builder and sets its table name
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
    qb.setTables(MainTable.TABLE_NAME);

    switch (mUriMatcher.match(uri)) {
        case MAIN:
            // If the incoming URI is for main table.
            qb.setProjectionMap(mNotesProjectionMap);
            break;

        case MAIN_ID:
            // The incoming URI is for a single row.
            qb.setProjectionMap(mNotesProjectionMap);
            qb.appendWhere(MainTable._ID + "=?");
            selectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs,
                    new String[] { uri.getLastPathSegment() });
            break;

        default:
            throw new IllegalArgumentException("Unknown URI " + uri);
    }


    if (TextUtils.isEmpty(sortOrder)) {
        sortOrder = MainTable.DEFAULT_SORT_ORDER;
    }

    SQLiteDatabase db = mOpenHelper.getReadableDatabase();

    Cursor c = qb.query(db, projection, selection, selectionArgs,
            null /* no group */, null /* no filter */, sortOrder);

    c.setNotificationUri(getContext().getContentResolver(), uri);
    return c;
}
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
private Cursor getAlbumCursor(String nomartist) {

        Uri musicUri = MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI;

        String selection = getSelectionString();
        String[] selectionArgs = getSelectionArgs();


        Log.d(TAG, "getAlbumCursor() " + nomartist  );

        if (mArtist != null) {

            Log.d(TAG, "getAlbumCursor() (mArtist != null) "  );

            selection = DatabaseUtilsCompat.concatenateWhere(selection, MediaStore.Audio.Albums.ARTIST + " = ?");
            selectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs, new String[]{nomartist});

        }

        String fieldName = MediaStore.Audio.Albums.ALBUM;
        String filter = getFilter();
        return getCursor(musicUri, sProjection, selection, selectionArgs, fieldName, filter);
    }
 

import android.support.v4.database.DatabaseUtilsCompat; //导入方法依赖的package包/类
@Override
public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder)
{
	// Constructs a new query builder and sets its table name
	SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
	String finalSortOrder = sortOrder;
	String[] finalSelectionArgs = selectionArgs;
	String finalGrouping = null;
	String finalHaving = null;
	int matched = URI_MATCHER.match(uri);
	boolean isMatch = false;
	int length = tableInfos.length;
	for (int i = 0; i < length; i++)
	{
		TableInfo tableInfo = tableInfos[i];
		if (matched == tableInfo.table)
		{
			qb.setTables(tableInfo.tableName);
			if (sortOrder == null)
			{
				finalSortOrder = tableInfo.field_id + " ASC";
			}
			isMatch = true;
			break;
		}
		else if (matched == tableInfo.table_id)
		{
			qb.setTables(tableInfo.tableName);
			qb.appendWhere(tableInfo.field_id + " = ? ");
			finalSelectionArgs = DatabaseUtilsCompat.appendSelectionArgs(selectionArgs, new String[]{uri.getLastPathSegment()});
			isMatch = true;
			break;
		}
	}
	if (!isMatch)
	{
		throw new IllegalArgumentException(UNKNOWN_URI_LOG + uri);
	}
	SQLiteDatabase db = mOpenHelper.getReadableDatabase();
	Cursor c = qb.query(db, projection, selection, finalSelectionArgs, finalGrouping, finalHaving, finalSortOrder);
	return c;
}