SgFriendsGroupService.java

public PageList getAllFriendsNotCoAuthor(int offset, int pageCapacity,

Long psUserId, String searchname,Long resourceId,String type){

String totalsql="select count(sgf.id) from Sgfriends sgf,User us where us.id=sgf.userfriend.id and sgf.user.id=" + psUserId+ " and sgf.status=1";

  totalsql +=" and NOT EXISTS (select kar from KoAuthorRelation kar where kar.user.id=sgf.userfriend.id and kar.authority=2 and kar.status=1 and kar.type='"+type+"' and kar.resourceId="+resourceId+")";

String sql = "select us from Sgfriends sgf,User us where us.id=sgf.userfriend.id and sgf.user.id=" + psUserId+ " and sgf.status=1";

  sql +=" and NOT EXISTS (select kar from KoAuthorRelation kar where kar.user.id=sgf.userfriend.id and kar.authority=2 and kar.status=1 and kar.type='"+type+"' and kar.resourceId="+resourceId+")";

PageList pageList = this.dao.pageList(offset, pageCapacity, totalsql, sql);

return pageList;

}

在mysql中，and的优先级比or高

在具有and以及or的sql语句中，要想改变执行的顺序，就要将or语句用（）括起来

详情参见：http://www.lmwlove.com/ac/ID790