query和rawQuery

一

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);