Mybatis 递归查询树形菜单

1、数据库表结构

CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL COMMENT '部门名称',
  `parentId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门表';

2、查询结果展示

3、实体类Department.java

public class Department implements Serializable {
    private Integer id;
    private String name;
    private Integer parentId;
    private List<Department> children = new ArrayList<>();
    //省略get\set

4、DepartmentMapper.xml

  <resultMap id="deptTree" type="com.chouxiaozi.vhr.model.Department">
      <id column="id" property="id" jdbcType="INTEGER" />
      <result column="name" property="name" jdbcType="VARCHAR" />
      <result column="parentId" property="parentId" jdbcType="INTEGER" />
    <!--id作为参数递归调用getDeptTree，查询子节点-->
    <collection property="children" column="id" select="getDeptTree" ofType="com.chouxiaozi.vhr.model.Department"></collection>
  </resultMap>
  <!--根据父id获取子节点-->
  <select id="getDeptTree" resultMap="deptTree">
    select * from department where parentId = #{id}
  </select>

5、DepartmentMapper.java

    List<Department> getDeptTree(@Param("id") Integer parentId);

调用接口传入父id，即可递归查询子节点；常用于菜单或树形展示