android資料庫操作：根據過濾條件擷取部分通訊錄資訊

    讀取全部的通訊錄，但是過濾掉黑名單中已經存在的記錄，其中過濾條件必須輸入為People._id，不然會報錯：

03-22 14:37:51.951: ERROR/DatabaseUtils(108): android.database.sqlite.SQLiteException: ambiguous column name: _id: , while compiling: SELECT people._id AS _id, (CASE WHEN (name IS NOT NULL AND name != '') THEN name ELSE (CASE WHEN primary_organization is NOT NULL THEN (SELECT company FROM organizations WHERE organizations._id = primary_organization) ELSE (CASE WHEN primary_phone IS NOT NULL THEN (SELECT number FROM phones WHERE phones._id = primary_phone) ELSE (CASE WHEN primary_email IS NOT NULL THEN (SELECT data FROM contact_methods WHERE contact_methods._id = primary_email) ELSE null END) END) END) END)  AS display_name FROM people LEFT OUTER JOIN phones ON people.primary_phone=phones._id LEFT OUTER JOIN presence ON (presence.person=people._id) WHERE (_id = 1)

很明顯，這裡要指定_id對應的具體表明

 

/*<br /> * (non-Javadoc)<br /> *<br /> * @see org.xiangjie.dao.IContactDAO#getAllContactInfomation()<br /> */<br />@Override<br />public Cursor getAllContactInfomation(Activity activity) {<br />return activity.getContentResolver().query(People.CONTENT_URI,<br />new String[] { People._ID, People.DISPLAY_NAME },<br />" People._id not in (?)", new String[] { getIDList() }, null);<br />}

 

圖片顯示如下：

全部連絡人清單：

 

 

黑名單資訊：

 

連絡人清單（已經將黑名單中的資訊移除）：