Mybatis 注解 @Many 一对多 传递多个参数问题

Mybatis 注解 @Many 一对多 传递多个参数问题

如果@Many调用的方法需要传递空值，那么就不写该参数值。

column 参数写法 ：{@Param 名称 = column 字段名 , @Param 名称 = column 字段名 ...}以逗号隔开

示例：方法不重要，重要的是使用方式

/**
     * 查询所有1级与2级菜单信息
     *
     * @return
     */
    @Select(" SELECT * FROM z_function_menu WHERE zfm_level = 1 ORDER BY zfm_order")
    @Results(id = "MenuDTO", value = {
            @Result(column = "{id = zfm_id}", property = "sonMenu", many = @Many(select = 					"com.inphase.wxVip.mapper.menu.ZFunctionMenuMapper.selectSonMenu"))
    })
    List<ZFunctionMenuDTO> selectL1L2AllMenu();

    /**
     * 查询子菜单
     *
     * @param fatherId 父菜单id
     * @param authSigns 权限标识
     * @return
     */
    @Select(" <script>" +
            " SELECT * FROM z_function_menu WHERE zfm_father_id = #{id} " +
            " <if test = 'signs != null'>" +
            "   AND auth_sign IN " +
            "   <foreach collection = 'signs' item = 'sign' open = '(' separator = ',' close = ')'>" +
            "       #{sign}" +
            "   </foreach>" +
            " </if>" +
            " ORDER BY zfm_area,zfm_order" +
            " </script>")
    List<ZFunctionMenu> selectSonMenu(@Param("id") Integer fatherId, @Param("signs") List<String> authSigns);