查询共享专业

 查询共享专业以及对比两个list的内容确定是否授权查看：

public PageList<TeachResource> findProfList(int page, int pageSize, Long profid,String tag) {
		User user1 = (User) ServletActionContext.getRequest().getSession().getAttribute("users");
		PageList<TeachResource> p=new PageList<TeachResource>();
		p.setObjectsPerPage(pageSize);
		p.setPageNumber(page);
		StringBuilder sb = new StringBuilder();
		sb.append("select t from TeachResource t where t.status = 1 and t.rtype = 1 and t.profession.id ="+profid);
		sb.append(" order by t.createTime desc");
		//查询列表
		Query query=em.createQuery(sb.toString());
		query.setFirstResult((page-1)*pageSize);
		query.setMaxResults(pageSize);
		List<TeachResource> list = query.getResultList();  //查询所有的数据
		
		if(tag.equals("login")){  //用户登录以后才处理是否授权查看该资源
			sb.setLength(0);
			sb.append("select t from TeachResource t where t.status = 1 and t.rtype = 1 and t.profession.id ="+profid);
			if(user1.getUserType() == UserType.TEACHER){  //用户类型：教师   则匹配用户专业id 或者该资源是自己上传的
				sb.append(" and (");
				sb.append("t.sharepro like '%,"+user1.getProfession().getId()+",%' or t.user.id ="+user1.getId()+" ");
				sb.append(")");
			}else if(user1.getUserType() == UserType.DEPARTADMIN){  //用户类型：系管理员   则匹配该系的所有专业id 或者该资源是自己上传的
				String proIDs = findDeparrProID(user1.getDepart().getId()); //该系对应的专业ids
				String[] proids = proIDs.split(",");
				sb.append(" and (");
				for (int i = 0; i < proids.length; i++) {
					if(i < proids.length-1){
						sb.append(" find_in_set("+proids[i]+",t.sharepro)>0 or");
					}else{
						sb.append(" find_in_set("+proids[i]+",t.sharepro)>0 or t.user.id ="+user1.getId()+" ");
					}
					
				}
				sb.append(")");
			}
			sb.append(" order by t.createTime desc");
			query=em.createQuery(sb.toString());
			//query.setFirstResult((page-1)*pageSize);
			//query.setMaxResults(pageSize);
			List<TeachResource> olist = query.getResultList();  //查询自己有权限查看的数据
			
			Set<TeachResource> olistSet = new HashSet<TeachResource>();
		    for (TeachResource t1 : olist) {
		    	olistSet.add(t1);
			}
		    for (TeachResource t2 : list) {
		    	if (olistSet.contains(t2)) {
	               t2.setCanSee("true");  //标识  有权限查看的资源
	            }
			}
		}
		
		p.setList(list);
		//查询总数
		sb.setLength(0);
		sb.append("select count(*) from TeachResource t where t.status = 1 and t.rtype = 1 and t.profession.id ="+profid);
		query=em.createQuery(sb.toString());
		p.setFullListSize(((Long)query.getSingleResult()).intValue());
		return p;
	}