一
c = db.query(PersonDBHelper.TABLE_NAME,
PersonDBHelper.LIST,PersonDBHelper.NAME + " like \"" + keys + "%\" or " +
PersonDBHelper.PHONE + " like \"" + keys + "%\" or " +
PersonDBHelper.FULL_PINYIN + " like \"" + keys + "%\" or " +
PersonDBHelper.ACRONYM + " like \"" + keys + "%\" ",
null, null, null,
PersonDBHelper.ORDER );
c = db.rawQuery("select * from (select * from person order by \"full_pinyin\" asc) where " +
" \"name\" like ? or " +
" \"phone\" like ? or " +
" \"full_pinyin\" like ? or " +
" \"acronym\" like ? " +
" order by \"show_order\" asc"
, new String[]{keys+"%",keys+"%",keys+"%",keys+"%"});
二
c = db.query(PersonDBHelper.TABLE_NAME, PersonDBHelper.LIST, PersonDBHelper.DEPARTMENT_ID + " = \""+departID+"\"", null, null, null, null);
c = db.rawQuery("select * from (select * from person order by \"full_pinyin\" asc) where " +
" \"departmentID\" = ? " +
" order by \"show_order\" asc"
, new String[]{departID});
三
c = db.query(PersonDBHelper.TABLE_NAME, PersonDBHelper.LIST, null, null, null, null,
PersonDBHelper.ORDER );
c = db.rawQuery("select * from (select * from person order by \"full_pinyin\" asc) " +
" order by \"show_order\" asc"
,null);