android ContentResolver 多表联合查询
16lz
2021-01-23
阅读更多
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")));}
更多相关文章
- andorid RecyclerView下拉刷新，上拉加载更多
- OpenGL ES教程V之更多3D模型(原文对照)
- Android从零撸美团(四) - 美团首页布局解析及实现 - Banner+自定
- EditText设置更多文字为省略号
- 短视频PHP源码Android 打造专属的下拉刷新 加载更多
- Android 1.6 支持更多的屏幕大小和分辨率
- NestedScrollView+RecyclerView滑动冲突问题，加载更多
- Activity生命周期的回调，你应该知道得更多！--Android源码剖析（上）
- Android中文文档v0.1 beta低调发布,期待更多同学来参加review