Android CursorAdapter 查詢連絡人過濾

一、使用sqlite 資料庫查詢時，用於模糊查詢的方法

    like

    % ： 表示有0個或多個字元

    _  ： 表示1個字元

 

二、去掉連絡人電話號碼中的空格:

"replace"(data1, ' ', '') LIKE '13_________'

 

三、查詢符合手機號碼格式的號碼

public Loader<Cursor> onCreateLoader(int id, Bundle args) {    String phone = "\"replace\"(" + ContactsContract.CommonDataKinds.Phone.NUMBER + ",' ','')";    String expression = phone + " LIKE ? or " + phone + " LIKE ? or (" + phone + " LIKE ? and " + phone + " NOT LIKE ?)"+ " or " + phone + " LIKE ? or " + phone + " LIKE ? or (" + phone + " LIKE ? and " + phone + " NOT LIKE ?)"+ " or " + phone + " LIKE ? or " + phone + " LIKE ? or (" + phone + " LIKE ? and " + phone + " NOT LIKE ?)";    String[] filter = new String[]{        "13_________", "18_________" , "15_________", "154________",         "013_________", "018_________", "015_________", "0154________",        "+8613_________", "+8618_________", "+8615_________", "+86154________"};    CursorLoader cursorLoader = new CursorLoader(InvitePeopleActivity.this, ContactsContract.CommonDataKinds.Phone.CONTENT_URI, new String[]{ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME, ContactsContract.CommonDataKinds.Phone.NUMBER}, expression, filter,ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME);    return cursorLoader;}