内容提供者的基本使用

本文的场景MusicServer提供数据库及内容提供者给其它应用使用,及观察数据库变化，好刷新自身应用的列表，ALiCocoMusicPlayer为第三方应用，其作用是为了使用ContentResolover对MusicServer中数据库中的表进行操作。

MusicServer

db,dao,测试类代码

db

public class MusicDBHelper extends BaseSqliteDbHelper {
    public MusicDBHelper(Context context) {
        super(context, MusicAppConst.KEYSETS.MUSIC_DB_NAME, MusicAppConst.KEYSETS
                .MUSIC_DB_VERSION);
    }

    @Override
    protected String getDbCreateSql() {
        StringBuilder sqlSb = new StringBuilder();

        sqlSb.append("create table IF NOT EXISTS ").append(MusicTabinfo.TABLE_NAME).append(" (");
        sqlSb.append(MusicTabinfo.COLOUMN_NAME_ID).append(" integer primary key autoincrement , ");
        sqlSb.append(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME).append(" varchar(20) , ");
        sqlSb.append(MusicTabinfo.COLOUMN_NAME_AUTHOR).append(" varchar(20) , ");
        sqlSb.append(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME).append(" varchar(30) ,");
        sqlSb.append(MusicTabinfo.COLOUMN_NAME_DESC).append(" text");
        sqlSb.append(" )");

        return sqlSb.toString();
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

dao

public class MusicDBDAO extends BaseDAO<MusicTabinfo> {
    private static MusicDBDAO INSTANCE = null;

    private MusicDBDAO() {
        mSqliteDbHelper = new MusicDBHelper(BaseApp.getAppInstance());
    }

    public static MusicDBDAO getInstance() {
        if (INSTANCE == null) {
            synchronized (MusicDBDAO.class) {
                if (INSTANCE == null) {
                    INSTANCE = new MusicDBDAO();
                }
            }
        }
        return INSTANCE;
    }

    @Override
    public int add(MusicTabinfo musicTabinfo) {
        LoggerUtils.loge("add");
        if (musicTabinfo == null)
            return -1;

        sqlBuilder.setLength(0);
        sqlBuilder.append("insert into ").append(MusicTabinfo.TABLE_NAME).append(" ( ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME).append(" , ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_AUTHOR).append(" , ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME).append(" , ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_DESC).append(" ) values ( ");
        sqlBuilder.append("?,?,?,? ) ");

        printLog();
        try {
            getWriteDb().execSQL(sqlBuilder.toString(), new String[]{
                    musicTabinfo.getMusicName(), musicTabinfo.getAuthor(), musicTabinfo
                    .getPublishTime(), musicTabinfo.getDesc()});
            return 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return -1;
        }
    }


    @Override
    public int addAll(List<MusicTabinfo> list) {
        LoggerUtils.loge("addAll");
        int errorNum = 0;
        for (MusicTabinfo tabinfo : list) {
            try {
                add(tabinfo);
            } catch (Exception e) {
                e.printStackTrace();
                errorNum++;
            }
        }
        // 有出错则返回-1
        return (errorNum == 0 ? 0 : -1);
    }

    @Override
    public int delete(MusicTabinfo musicTabinfo) {
        LoggerUtils.loge("delete");
        sqlBuilder.setLength(0);

        sqlBuilder.append("delete from ").append(MusicTabinfo.TABLE_NAME);
        sqlBuilder.append(" where ").append(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME).append(" = ? ");
        sqlBuilder.append(" & ").append(MusicTabinfo.COLOUMN_NAME_ID).append(" = ? ");
        printLog();

        try {
            getWriteDb().execSQL(sqlBuilder.toString(), new String[]{musicTabinfo.getMusicName(),
                    musicTabinfo.getMusicId() + ""});
            return 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return -1;
        }
    }

    @Override
    public int deleteById(int id) {
        LoggerUtils.loge("deleteById");
        sqlBuilder.setLength(0);

        sqlBuilder.append("delete from ").append(MusicTabinfo.TABLE_NAME);
        sqlBuilder.append(" where ").append(MusicTabinfo.COLOUMN_NAME_ID).append(" = ? ");
        printLog();

        try {
            getWriteDb().execSQL(sqlBuilder.toString(), new String[]{id + ""});
            return 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return -1;
        }
    }


    @Override
    public int update(MusicTabinfo musicTabinfo) {
        LoggerUtils.loge("update");
        if (musicTabinfo == null)
            return -1;
        sqlBuilder.setLength(0);


        // 先查询再更新避免没有设置的数据被清除掉了
        sqlBuilder.append("update ").append(MusicTabinfo.TABLE_NAME);
        sqlBuilder.append(" set ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_AUTHOR).append(" = ? , ");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME).append(" = ? ,");
        sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_DESC).append(" = ? ");
        sqlBuilder.append(" where ").append(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME).append(" = ? ");

        try {
            printLog();
            getWriteDb().execSQL(sqlBuilder.toString(), new String[]{musicTabinfo.getAuthor(),
                    musicTabinfo.getPublishTime(), musicTabinfo.getDesc(), musicTabinfo
                    .getMusicName()});
            return 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return -1;
        }
    }

    @Override
    public int updateById(int id, Map<String, Object> params) {
        LoggerUtils.loge("updateById");
        if (id == -1 || id == 0 || params == null || params.size() == 0)
            return -1;

        // 先查询在数据库中是否存在
        MusicTabinfo dbInfo = queryById(id);

        Set<String> keySet = params.keySet();
        if (dbInfo != null) {
            // 存在就更新
            fillTabData(params, dbInfo, keySet);

            sqlBuilder.setLength(0);
            sqlBuilder.append("update ").append(MusicTabinfo.TABLE_NAME);
            sqlBuilder.append(" set ");
            sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_AUTHOR).append(" = ? , ");
            sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME).append(" = ? , ");
            sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_DESC).append(" = ? , ");
            sqlBuilder.append(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME).append(" = ? ");
            sqlBuilder.append(" where ").append(MusicTabinfo.COLOUMN_NAME_ID).append(" = ?");
            printLog();
            try {
                getWriteDb().execSQL(sqlBuilder.toString(), new String[]{dbInfo.getAuthor(),
                        dbInfo.getPublishTime(), dbInfo.getDesc(), dbInfo.getMusicName(),
                        id + ""});
                return 0;
            } catch (SQLException e) {
                e.printStackTrace();
                return -1;
            }
        } else {
            // 不存在就创建,并插入数据库
            dbInfo = new MusicTabinfo();
            fillTabData(params, dbInfo, keySet);
            return add(dbInfo);
        }
    }

    private void fillTabData(Map<String, Object> params, MusicTabinfo dbInfo, Set<String> keySet) {
        // 数据库中不存在就添加到数据库中
        if (keySet.contains(MusicTabinfo.COLOUMN_NAME_AUTHOR)) {
            dbInfo.setAuthor((String) params.get(MusicTabinfo.COLOUMN_NAME_AUTHOR));
        }

        if (keySet.contains(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME)) {
            dbInfo.setPublishTime((String) params.get(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME));
        }

        if (keySet.contains(MusicTabinfo.COLOUMN_NAME_DESC)) {
            dbInfo.setDesc((String) params.get(MusicTabinfo.COLOUMN_NAME_DESC));
        }

        if (keySet.contains(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME)) {
            dbInfo.setMusicName((String) params.get(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME));
        }
    }


    @Override
    public MusicTabinfo queryById(int id) {
        LoggerUtils.loge("queryById");
        MusicTabinfo tabinfo = new MusicTabinfo();
        sqlBuilder.setLength(0);

        sqlBuilder.append("select * from ").append(MusicTabinfo.TABLE_NAME);
        sqlBuilder.append(" where ").append(MusicTabinfo.COLOUMN_NAME_ID).append(" = ?");

        Cursor cursor = null;
        try {
            cursor = getReadDb().rawQuery(sqlBuilder.toString(), new String[]{id + ""});
            cursor.moveToFirst();
            int _id = cursor.getInt(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_ID));
            String _name = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_MUSIC_NAME));
            String _author = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_AUTHOR));
            String _publish_time = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_PUBLISH_NAME));
            String _desc = cursor.getString(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_DESC));
            tabinfo = new MusicTabinfo(_id, _name, _publish_time, _author, _desc);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (cursor != null)
                cursor.close();
        }

        return tabinfo;
    }

    @Override
    public List<MusicTabinfo> queryAll() {
        LoggerUtils.loge("queryAll");
        Cursor cursor = getReadDb().rawQuery("select * from " + MusicTabinfo.TABLE_NAME, null);
        List<MusicTabinfo> list = new ArrayList<>();
        MusicTabinfo tabinfo = null;
        while (cursor.moveToNext()) {
            int _id = cursor.getInt(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_ID));
            String _name = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_MUSIC_NAME));
            String _author = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_AUTHOR));
            String _publish_time = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                    .COLOUMN_NAME_PUBLISH_NAME));
            String _desc = cursor.getString(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_DESC));
            tabinfo = new MusicTabinfo(_id, _name, _publish_time, _author, _desc);
            list.add(tabinfo);
        }
        cursor.close();
        return list;
    }
}

测试类

@RunWith(AndroidJUnit4.class)
public class MusicDBDAOTest {

    private MusicDBDAO mDbdao;

    @Before
    public void setUp() throws Exception {
        mDbdao = MusicDBDAO.getInstance();
    }

    @Test
    public void add() {
        MusicTabinfo tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("光辉岁月");
        tabinfo.setAuthor("boyone");
        tabinfo.setPublishTime("1983-12-31");
        tabinfo.setDesc("激情，青春，有活力");
        mDbdao.add(tabinfo);
    }

    @Test
    public void addAll() {
        List<MusicTabinfo> list = new ArrayList<>();
        MusicTabinfo tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("光辉岁月");
        tabinfo.setAuthor("boyone");
        tabinfo.setPublishTime("1983-12-31");
        tabinfo.setDesc("激情，青春，有活力");
        list.add(tabinfo);

        tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("追梦赤子心");
        tabinfo.setAuthor("gala");
        tabinfo.setPublishTime("1983-11-31");
        tabinfo.setDesc("奔放，激情");
        list.add(tabinfo);

        tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("海阔天空");
        tabinfo.setAuthor("boyone");
        tabinfo.setPublishTime("1984-12-31");
        tabinfo.setDesc("用心向往");
        list.add(tabinfo);

        tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("the mass");
        tabinfo.setAuthor("era");
        tabinfo.setPublishTime("1986-12-31");
        tabinfo.setDesc("暴力，突破");
        list.add(tabinfo);

        tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("reborn");
        tabinfo.setAuthor("era");
        tabinfo.setPublishTime("1989-12-31");
        tabinfo.setDesc("重生,向往");
        list.add(tabinfo);

        mDbdao.addAll(list);
    }

    @Test
    public void delete() {
    }

    @Test
    public void deleteById() {
        mDbdao.deleteById(3);
    }

    @Test
    public void update() {
        MusicTabinfo tabinfo = new MusicTabinfo();
        tabinfo.setMusicName("光辉岁月2");
        tabinfo.setAuthor("boyone223");
        tabinfo.setPublishTime("1982-11-1");
        mDbdao.update(tabinfo);
    }

    @Test
    public void updateById() {
        Map<String, Object> param = new HashMap<>();
        param.put(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME, "光辉岁月431");
        param.put(MusicTabinfo.COLOUMN_NAME_AUTHOR, "boyone155");
        param.put(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME, "1980-1-1");
        mDbdao.updateById(4, param);
    }

    @Test
    public void queryById() {
        MusicTabinfo tabinfo = mDbdao.queryById(2);
        LoggerUtils.loge(tabinfo.toString());
    }

    @Test
    public void queryAll() {
        List<MusicTabinfo> list = mDbdao.queryAll();
        if (list != null && list.size() > 0) {
            for (MusicTabinfo tabinfo : list) {
                LoggerUtils.loge(tabinfo.toString());
            }
        }
    }
}

content provider配置及源代码

public class MusicContentProvider extends ContentProvider {
    /**
     * URI匹配器
     */
    private static final UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);
    private static final int INSERT = 0;
    private static final int DELETE = 1;
    private static final int UPDATE = 2;
    private static final int SELECT = 3;
    private static final int SELECT_ONE = 4;
    private static String tabName = MusicTabinfo.TABLE_NAME;

    static {
        /**
         * 添加匹配规则
         */
        matcher.addURI(MusicAppConst.AUTHORIES_SERVER_CP, tabName + "/insert", INSERT);
        matcher.addURI(MusicAppConst.AUTHORIES_SERVER_CP, tabName + "/delete", DELETE);
        matcher.addURI(MusicAppConst.AUTHORIES_SERVER_CP, tabName + "/update", UPDATE);
        matcher.addURI(MusicAppConst.AUTHORIES_SERVER_CP, tabName + "/select", SELECT);
        // 允许携带参数：select * from _music where id = ?
        // query/# 后面就是匹配这个id
        matcher.addURI(MusicAppConst.AUTHORIES_SERVER_CP, tabName + "/query/#", SELECT_ONE);
    }

    private final String LOG_TAG = getClass().getSimpleName();
    private MusicDBHelper mDbHelper;
    private BaseApp appInstance;

    /**
     * 被创建的时候做一些初始化的操作
     */
    @Override
    public boolean onCreate() {
        log("onCreate appInstance = " + appInstance);
        appInstance = MusicServerApp.getAppInstance();
        mDbHelper = MusicServerApp.getDbHelper();
        return true;
    }

    @Nullable
    @Override
    public Cursor query(@NonNull Uri uri, @Nullable String[] projection, @Nullable String selection,
                        @Nullable String[] selectionArgs, @Nullable String sortOrder) {
        log("query mDbHelper = " + mDbHelper + " , appInstance = " + appInstance);
        //　清单文件中注册不会走onreate方法，需要重新初始化
        reInitDb();
        int match = matchUri(uri);
        if (match == SELECT) {
            SQLiteDatabase database = mDbHelper.getReadableDatabase();
            // 由别人控制要查询哪些，这就是不用dao的原因，行为由用户自己控制
            Cursor cursor = database.query(tabName, projection, selection, selectionArgs, null,
                    null, sortOrder);
            // cursor不能关闭，由调用者关闭，要不然会把其它地方给坑死的
            return cursor;
        } else if (match == SELECT_ONE) {
            // 这里是根据id进行查询
            long id = ContentUris.parseId(uri);
            SQLiteDatabase database = mDbHelper.getReadableDatabase();
            // 由别人控制要查询哪些，这就是不用dao的原因，行为由用户自己控制
            Cursor cursor = database.query(tabName, projection, "music_id = ?", new String[]{id +
                            ""}, null, null,
                    sortOrder);
            // cursor不能关闭，由调用者关闭，要不然会把其它地方给坑死的
            return cursor;
        } else {
            printErrorUri();
        }
        return null;
    }

    private void reInitDb() {
        if (appInstance == null)
            appInstance = MusicServerApp.getAppInstance();
        if (mDbHelper == null) mDbHelper = MusicServerApp.getDbHelper();
    }

    private int matchUri(@NonNull Uri uri) {
        return matcher.match(uri);
    }

    private void printErrorUri() {
        log("请求的uri不匹配");
    }

    @Nullable
    @Override
    public String getType(@NonNull Uri uri) {
        reInitDb();
        log("getType");
        //The returned MIME type should start with vnd.android.cursor.item for a single record,
        // or vnd.android.cursor.dir/ for multiple items
        int matchUri = matchUri(uri);
        if (matchUri == SELECT) {
            // 多条数据
            return "vnd.android.cursor.dir/" + tabName;
        } else if (matchUri == SELECT_ONE) {
            // 单条数据
            return "vnd.android.cursor.item/" + tabName;
        } else {
            printErrorUri();
        }
        return null;
    }

    @Nullable
    @Override
    public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {
        reInitDb();
        log("insert");
        int matchUri = matchUri(uri);
        if (matchUri == INSERT) {
            SQLiteDatabase database = mDbHelper.getWritableDatabase();
            database.insert(tabName, null, values);
            // 通知内容观察者发生变化
            appInstance.getContentResolver().notifyChange(uri, null);
            // 数据库别关闭了，否则会出现问题
        } else {
            printErrorUri();
        }
        return null;
    }

    @Override
    public int delete(@NonNull Uri uri, @Nullable String selection, @Nullable String[]
            selectionArgs) {
        reInitDb();
        log("delete");
        int matchUri = matchUri(uri);
        if (matchUri == DELETE) {
            SQLiteDatabase database = mDbHelper.getWritableDatabase();
            database.delete(tabName, selection, selectionArgs);
            // 数据库别关闭了，否则会出现问题
            // 通知内容观察者发生变化
            appInstance.getContentResolver().notifyChange(uri, null);
        } else {
            printErrorUri();
        }
        return 0;
    }

    @Override
    public int update(@NonNull Uri uri, @Nullable ContentValues values, @Nullable String selection,
                      @Nullable String[] selectionArgs) {
        reInitDb();
        log("update");
        int matchUri = matchUri(uri);
        if (matchUri == UPDATE) {
            SQLiteDatabase database = mDbHelper.getWritableDatabase();
            database.update(tabName, values, selection, selectionArgs);
            // 数据库别关闭了，否则会出现问题
            // 通知内容观察者发生变化
            appInstance.getContentResolver().notifyChange(uri, null);
        } else {
            printErrorUri();
        }

        return 0;
    }

    private void log(String str) {
        LoggerUtils.loge(LOG_TAG + " " + str);
    }
}

第三方应用在调用的时候,query,insert中的db可能会空，需要重新初始化，这里是一个坑，明明在onCreate中定义了，但是调用的时候，对象均为空，原因暂时未找到，这里做了容错，不影响使用

xml中的配置

<provider
        android:authorities="com.cokuq.t_music"
        android:name=".provider.MusicContentProvider"
        android:exported="true"
        />

使用ContentObserver观察者观察数据库内容的变化

public class MainActivity extends BaseSampleActivity {

    @BindView(R.id.recyclerView)
    RecyclerView mRecyclerView;
    @BindView(R.id.rl_loading_view)
    View loadingView;
    private List<MusicTabinfo> mList = new ArrayList<>();
    private Disposable mDisposable;
    private MusicListAdapter mMusicListAdapter;

    @Override
    public void initView() {
        mRecyclerView.setLayoutManager(new LinearLayoutManager(mContext));

        mMusicListAdapter = new MusicListAdapter(mContext, mList);
        mRecyclerView.setAdapter(mMusicListAdapter);
    }

    @Override
    public void initData() {
        LoggerUtils.loge("initData");
        ThreadUtils.executeBySingleThread(() -> {
            // 注册观察者监听数据库的变化
            getContentResolver().registerContentObserver(Uri.parse("content://com.kuqi" +
                    ".provider_1/t_music"), true, new MusicDBObserver(mH));
        });
        loadPageData();
    }

    private void loadPageData() {
        List<MusicTabinfo> dbList = MusicDBDAO.getInstance().queryAll();
        // rxjava2 延迟10秒回调obsesrver
        mDisposable = RxUtils.createFlowableData(dbList)
                .delay(10, TimeUnit.SECONDS)
                .subscribeOn(Schedulers.io()).observeOn(AndroidSchedulers.mainThread())
                .subscribe(_list -> {
                    LoggerUtils.loge("数据获取完毕，刷新界面");
                    mMusicListAdapter.setData(_list);
                    LoggerUtils.loge("刷新界面");
                    mMusicListAdapter.notifyItemRangeChanged(0, _list.size());
                    hideLoading();

                });
    }

    private void hideLoading() {
        if (loadingView.getVisibility() != View.GONE) {
            loadingView.setVisibility(View.GONE);
        }
    }

    @Override
    public int getContentId() {
        return R.layout.activity_main;
    }

    @Override
    protected void onDestroy() {
        if (mDisposable != null) {
            if (!mDisposable.isDisposed()) {
                mDisposable.dispose();
            }
        }
        super.onDestroy();
    }

    @OnClick({R.id.btn_refresh})
    public void onViewClick(View v) {
        showLoading();
        loadPageData();
    }

    private void showLoading() {
        if (loadingView.getVisibility() != View.VISIBLE) {
            loadingView.setVisibility(View.VISIBLE);
        }
    }

    /**
     * 数据库内容观察者
     */
    private class MusicDBObserver extends ContentObserver {
        public MusicDBObserver(Handler handler) {
            super(handler);
        }

        @Override
        public void onChange(boolean selfChange, Uri uri) {
            String host = uri.getHost();
            String path = uri.getPath();
            String scheme = uri.getScheme();
            String query = uri.getQuery();
            LoggerUtils.loge("MusicDBObserver onChange uri = " + uri.toString() + " threadId = "
                    + Thread.currentThread().getId());
            LoggerUtils.loge("MusicDBObserver onChange host = " + host + " , path = " + path + " " +
                    ", scheme = " + scheme + " , query = " + query);
            if (EmptyUtils.isNotEmpty(path)) {
                path = path.substring(path.lastIndexOf("/") + 1, path.length());
                LoggerUtils.loge("path = " + path);
                if ("insert".equalsIgnoreCase(path)) {
                    LoggerUtils.loge("添加了新数据");
                } else if ("update".equalsIgnoreCase(path)) {
                    LoggerUtils.loge("更新了数据");
                } else if ("delete".equalsIgnoreCase(path)) {
                    LoggerUtils.loge("删除了数据");
                }

                UiUtils.runInMainThread(() -> {
                    LoggerUtils.loge("重新刷新界面");
                    loadPageData();
                });
            }
        }
    }
}

ALiCocoMusicPlayer客户端代码

public class MainActivity extends BaseSampleActivity {

    private ContentResolver mContentResolver;

    @Override
    public void initData() {
        mContentResolver = getContentResolver();
    }

    @OnClick({R.id.btn_add, R.id.btn_add_all,R.id.btn_query, R.id.btn_query_all})
    public void onViewClick(View view) {
        Uri uri = null;
        ContentValues contentValues = null;
        Cursor cursor = null;
        MusicTabinfo tabinfo = null;
        switch (view.getId()) {
            case R.id.btn_add:
                contentValues = new ContentValues();
                contentValues.put(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME, "我的中国心");
                contentValues.put(MusicTabinfo.COLOUMN_NAME_AUTHOR, "张明明");
                contentValues.put(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME, "1989-12-11");
                contentValues.put(MusicTabinfo.COLOUMN_NAME_DESC, "爱国歌曲");
                // 拼接uri
                uri = Uri.parse(ALCooConst.KEY_RSCP_AU_PIREFIX + "insert");
                printUri(uri);
                // 插入数据
                mContentResolver.insert(uri, contentValues);
                break;
            case R.id.btn_add_all:
                String[] musicNames = {
                        "冰雨", "天涯", "谢谢你的爱", "我不够爱你", "你爱我像谁", "你是我的温柔", "17岁"
                };
                for (String musicName : musicNames) {
                    contentValues = new ContentValues();
                    contentValues.put(MusicTabinfo.COLOUMN_NAME_MUSIC_NAME, musicName);
                    contentValues.put(MusicTabinfo.COLOUMN_NAME_AUTHOR, "不详");
                    contentValues.put(MusicTabinfo.COLOUMN_NAME_PUBLISH_NAME, "1983-1-1");
                    contentValues.put(MusicTabinfo.COLOUMN_NAME_DESC, "不详");
                    // 拼接uri
                    uri = Uri.parse(ALCooConst.KEY_RSCP_AU_PIREFIX + "insert");
                    printUri(uri);
                    // 插入数据
                    mContentResolver.insert(uri, contentValues);
                }
                break;
            case R.id.btn_query:
                uri = Uri.parse(ALCooConst.KEY_RSCP_AU_PIREFIX + "select");
                printUri(uri);
                cursor = mContentResolver.query(uri, null, MusicTabinfo.COLOUMN_NAME_ID + " = ?", new String[]{3 + ""},"desc");
                if (cursor != null && cursor.moveToFirst()) {
                    int _id = cursor.getInt(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_ID));
                    String _name = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_MUSIC_NAME));
                    String _author = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_AUTHOR));
                    String _publish_time =
                            cursor.getString(cursor.getColumnIndex(MusicTabinfo
                                    .COLOUMN_NAME_PUBLISH_NAME));
                    String _desc = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_DESC));
                    tabinfo = new MusicTabinfo(_id, _name, _publish_time, _author, _desc);
                }

                LoggerUtils.loge("tabinfo = " + tabinfo);
                break;
            case R.id.btn_query_all:
                uri = Uri.parse(ALCooConst.KEY_RSCP_AU_PIREFIX + "select");
                printUri(uri);
                cursor = mContentResolver.query(uri, null, null, null, "desc");
                List<MusicTabinfo> list = new ArrayList<>();

                while (cursor != null && cursor.moveToNext()) {
                    int _id = cursor.getInt(cursor.getColumnIndex(MusicTabinfo.COLOUMN_NAME_ID));
                    String _name = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_MUSIC_NAME));
                    String _author = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_AUTHOR));
                    String _publish_time =
                            cursor.getString(cursor.getColumnIndex(MusicTabinfo
                                    .COLOUMN_NAME_PUBLISH_NAME));
                    String _desc = cursor.getString(cursor.getColumnIndex(MusicTabinfo
                            .COLOUMN_NAME_DESC));
                    tabinfo = new MusicTabinfo(_id, _name, _publish_time, _author, _desc);
                    list.add(tabinfo);
                }

                if (list.size() > 0) {
                    UiUtils.showToastSafe("查询到了 " + list.size() + " 条数据...");
                    for (MusicTabinfo musicTabinfo : list) {
                        LoggerUtils.loge(musicTabinfo.toString());
                    }
                }
                break;
        }
    }

    private void printUri(Uri uri) {
        LoggerUtils.loge(uri.toString());
    }
}

public class ALCooConst {
    // content://content provider authories/tablename
    public static final String KEY_RSCP_AU_PIREFIX = "content://com.cokuq.t_music/t_music/";
}

image