/** 系统菜单 */ public class SysMenu { private int menuid; // 菜单编号 private String menuname; // 菜单名 private SysMenu parent; // 父菜单编号 private List<SysMenu> children; //子菜单 private int isleaf; // 是否是叶子节点 private String action; // 响应类在缓存中的key private int sort; // 序号 private int activity; // 是否可用 private String describe; // 描述
<resultMap type="sysMenu" id="sysMenuResult"> <id property="menuid" column="menuid"/> <result property="menuname" column="menuname"/> <result property="isleaf" column="isleaf"/> <result property="action" column="action"/> <result property="sort" column="sort"/> <result property="activity" column="activity"/> <result property="describe" column="describe"/> </resultMap> <select id="searchMenusByParentId" parameterType="int" resultMap="sysMenuResult"> select `menuid` , `menuname` , `parentid` , `isleaf` , `action` , `sort` , `activity` , `describe` from `sys_menu` where `activity` = 1 and `parentid` = #{menuid} </select>
关于属性 : private SysMenu parent; // 父菜单编号
private List<SysMenu> children; //子菜单
resultMap 中的写法?