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,即可递归查询子节点;常用于菜单或树形展示