安卓-sqlite-模糊查询

private void query() throws UnsupportedEncodingException {
        detailList.clear();
        SQLiteDatabase db=SQLiteDatabase.openOrCreateDatabase(ImportDB.DB_PATH + "/" + ImportDB.DB_NAME, null);
        StringBuilder sb = new StringBuilder();
        String temp = edit_search.getText().toString().trim();
        if (!temp.equals("")) {
            SQLiteDatabase db_search = openOrCreateDatabase("libo.db", Context.MODE_PRIVATE, null);
            Cursor csearch = db_search.rawQuery("SELECT * FROM moon WHERE name LIKE '%" + temp + "%'", null);
            while (csearch.moveToNext()) {
                String name = csearch.getString(csearch.getColumnIndex("name"));
                String amount = csearch.getString(csearch.getColumnIndex("amount"));
                String note = csearch.getString(csearch.getColumnIndex("note"));
                DetailBean data = new DetailBean(name,amount,note);
                detailList.add(data);
            }
            db_search.close();
            csearch.close();
                detailAdapter.notifyDataSetChanged();
            detailAdapter = new DetailAdapter(detailList);//适配器对象
            recyclerView.setAdapter(detailAdapter);//设置适配器为上米娜的对象
            }
        }