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);