Go语言视频零基础入门到精通

8jnuj3

显示的时候总是显示同一个头像,把sql语句放数据库中执行也是如此。后面在数据库中写了 没有错误数据的sql语句……



　　想查询出通话日志中的通讯录,发现如果用
　　String selection ="0=0) group by (date"
　　String [] projection = new String []{
　　"_id",
　　"(select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = number)) as avatars", // 头像
　　};
　　query(URI,projection,selection,null,null,null);
　　显示的时候总是显示同一个头像,
　　把sql语句放数据库中执行也是如此.
　　后面在数据库中写了 没有错误数据的sql语句:
　　select _id,
　　(select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = as calls. number)) as avatars
　　from calls as calls
　　这里用到了 as..
　　但是却在java中怎么写卡住了.
　　后面结果版主的指点
　　写法如下:
　　String [] projection = new String []{
　　"_id, (select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = as calls. number)) as avatars
　　from calls as calls --" // 用到了 "--" 注释 //注释所有以后系统自动生成的sql语句
　　};
　　query(URL,projection,null,null,null,null);
　　达到了想要的效果.