android ContentResolver 多表联合查询

 

			String [] projection= new String[]{
			Phones._ID,
			Phones.TYPE,
			Phones.NUMBER,
			"(SELECT NAME FROM PEOPLE AS people WHERE PEOPLE._id =PERSON) AS peopleName",
//			new StringBuilder().append("(SELECT NAME FROM PEOPLE AS people WHERE PEOPLE._id =").append(Phones.PERSON_ID)
//			.append(") AS peopleName").toString(),
			"(SELECT DATA FROM PHOTOS AS PHOTOS WHERE PHOTOS.PERSON =PERSON) AS peopleLogo",
//			new StringBuilder().append("(SELECT DATA FROM PHOTOS AS PHOTOS WHERE PHOTOS.PERSON =").append(Phones.PERSON_ID)
//			.append(") AS peopleLogo").toString()
			
		}; 	

		String selection = "0==0) GROUP BY (PERSON";
		Cursor cursor = context.getContentResolver().query(Phones.CONTENT_URI, projection, selection, null, null);
		while(cursor.moveToNext()){
			System.out.println(cursor.getString(cursor.getColumnIndex(Phones.NUMBER)));
			System.out.println(cursor.getString(cursor.getColumnIndex("peopleName")));
		}

评论

4 楼 zengyan2012 2011-12-21  

2025hawk 写道

我查了源码，我用的sdk是2.2.2.2开始限制在contacts的各种表操作中添加as

  恩..那以后的版本就不能用了.呵呵.

3 楼 2025hawk 2011-12-20  

我查了源码，我用的sdk是2.2.2.2开始限制在contacts的各种表操作中添加as

2 楼 zengyan2012 2011-12-13  

2025hawk 写道

确定可以？12-12 08:24:37.701: ERROR/DatabaseUtils(161): java.lang.IllegalArgumentException: Invalid column  (sort_key) AS xsort

我随便写个都暴错

  我确定能用.  因为这是我项目一面写出来的.  这是adk2.1 以下查询联系人的.

1 楼 2025hawk 2011-12-12  

确定可以？12-12 08:24:37.701: ERROR/DatabaseUtils(161): java.lang.IllegalArgumentException: Invalid column  (sort_key) AS xsort

我随便写个都暴错