android ContentResolver 多表联合查询

最新推荐文章于 2025-07-02 21:44:15 发布

iteye_8859

最新推荐文章于 2025-07-02 21:44:15 发布

阅读量816

点赞数

CC 4.0 BY-SA版权

分类专栏： android-->非界面文章标签： android系统表多表查询多表查询 AS

本文链接：https://blog.youkuaiyun.com/iteye_8859/article/details/82132960

android-->非界面专栏收录该内容

46 篇文章

订阅专栏

本文展示如何通过SQL查询操作，获取联系人的电话号码及姓名，并打印结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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