1.建一个菜单表(menu),数据中除了常规字段之外,还有一个字段是parent,表示这个菜单的父菜单。
建表语句如下:
CREATE TABLE `menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(64) DEFAULT NULL,
`path` varchar(64) DEFAULT NULL,
`component` varchar(64) DEFAULT NULL,
`name` varchar(64) DEFAULT NULL,
`iconCls` varchar(64) DEFAULT NULL,
`keepAlive` tinyint(1) DEFAULT NULL,
`requireAuth` tinyint(1) DEFAULT NULL,
`parentId` int(11) DEFAULT NULL,
`enabled` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `parentId` (`parentId`),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
在Java代码中建一个菜单实体类。
public class Menu{
private Integer id;
private String url;
private String path;
private String component;
private String name;
private String iconCls;
private Meta meta;
private Integer parentId;
private Boolean enabled;
private List<Menu> children;
private List<Role> roles;
// get、set方法
}
建Mapper接口。
public interface MenuMapper {
List<Menu> getMenusByHrId(Integer hrid);
}
写xml文件,用sql实现方法。
<resultMap id="BaseResultMap" type="org.javaboy.vhr.model.Menu" >
<id column="id" property="id" jdbcType="INTEGER" />
<result column="url" property="url" jdbcType="VARCHAR" />
<result column="path" property="path" jdbcType="VARCHAR" />
<result column="component" property="component" jdbcType="VARCHAR" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="iconCls" property="iconCls" jdbcType="VARCHAR" />
<result column="parentId" property="parentId" jdbcType="INTEGER" />
<result column="enabled" property="enabled" jdbcType="BIT" />
<association property="meta" javaType="org.javaboy.vhr.model.Meta">
<result column="keepAlive" property="keepAlive" jdbcType="BIT" />
<result column="requireAuth" property="requireAuth" jdbcType="BIT" />
</association>
</resultMap>
<resultMap id="Menus2" type="org.javaboy.vhr.model.Menu" extends="BaseResultMap">
<collection property="children" ofType="org.javaboy.vhr.model.Menu">
<id column="id2"