@Select("SELECT  u.* , ur.role_id , r.role_name  from  sys_user_role  ur , sys_role r , sys_user u ,sys_user_depart ud " +
			"where  ur.role_id = r.id  and ur.user_id = u.id and u.id = ud.user_id " +
			"and ud.create_user_id in (${createUserId})")
	public Page<SysRoleDeptVO>  getUserByCreateUserIds(Page page, @Param("createUserId") String createUserId);

    @Override
    public Page<SysRoleDeptVO> getByUserIds(Page<SysRoleDeptVO> page, List<String> userIds) {
        /** 如果當(dāng)前部門下沒(méi)用戶的話,就傳個(gè) ""  過(guò)去   由于 mybatis 解析后空字符串
         *  后是什么都沒(méi)有, 這里用  in ()  如果這樣,就會(huì)異常 ,所以當(dāng)用戶為空的話,
         *  傳 "''"  這樣解析后 變成了 in ('')
         * */
        String userids = "''" ;
        if(userIds != null && userIds.size() != 0){
            StringBuilder stringBuilder = new StringBuilder("");
            for (int i = 0; i < userIds.size(); i++) {
                stringBuilder.append("'");
                stringBuilder.append(userIds.get(i));
                stringBuilder.append("'");
                stringBuilder.append(",");
            }
            userids = stringBuilder.substring(0, stringBuilder.length() - 1);
        }
        return  userMapper.getByUserIds(page,userids);

<![CDATA[ ? ? ?]]>?

@Select("<script>" +
? ? ? ? ? ? "select * from article where id in " +
? ? ? ? ? ? "<foreach item='item' index='index' collection='articleIds' open='(' separator=', ' close=')'>" +
? ? ? ? ? ? ? ? "#{item}" +
? ? ? ? ? ? "</foreach>" +
? ? ? ? "</script>")
List<Article> getArticlesByIds(@Param("articleIds") List<Long> articleIds);