加载 树形结构

//Demo 5 解决双层for循环性能问题.
@ResponseBody
@RequestMapping("/loadData")
public Object loadData() {

AjaxResult result = new AjaxResult();

try {

List<Permission> root = new ArrayList<Permission>();

Permission parent = null ;

List<Permission> allPermissionList = permissionService.queryAllPermission();



Map<Integer,Permission> allPermissionMap = new HashMap<Integer,Permission>();
for (Permission permission : allPermissionList) {
allPermissionMap.put(permission.getId(), permission);
}

for (Permission permission : allPermissionList) {
Permission child = permission;
if(permission.getPid()==0) { //根
parent = permission ;
}else {
Permission permissionObj = allPermissionMap.get(child.getPid());
permissionObj.getChildren().add(child);
}
}

root.add(parent);
result.setData(root);
result.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
result.setSuccess(false);
}

return result;
}

// Demo4 - 改进查询语句的条数,进行一次加载,在内存中组合数据关系.
/*@ResponseBody
@RequestMapping("/loadData")
public Object loadData() {

AjaxResult result = new AjaxResult();

try {

List<Permission> root = new ArrayList<Permission>();

Permission parent = null ;

List<Permission> allPermissionList = permissionService.queryAllPermission();


//a : 
for (Permission permission : allPermissionList) {
Permission child = permission;
if(permission.getPid()==0) { //根
parent = permission ;
}else {
for (Permission permissionObj : allPermissionList) {
if(child.getPid() == permissionObj.getId()) { //通过子来 查找父
permissionObj.getChildren().add(child); //组合父与子的关系.
//break a;
break ;
}
}
}
}

root.add(parent);
result.setData(root);
result.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
result.setSuccess(false);
}

return result;
}*/

//Demo 3 递归
/*@ResponseBody
@RequestMapping("/loadData")
public Object loadData() {

AjaxResult result = new AjaxResult();

try {

List<Permission> root = new ArrayList<Permission>();

Permission parent = permissionService.getPermissionRoot(); //根节点

relationPermission(parent);


root.add(parent);

result.setData(root);
result.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
result.setSuccess(false);
}

return result;
}

private void relationPermission(Permission permission) {
List<Permission> children = permissionService.getPermissionByPid(permission.getId()); 
permission.setChildren(children);

if(children.size()>0) {
for (Permission permissionObj : children) {
relationPermission(permissionObj);
}
}
}*/

//Demo 2 循环
/*@ResponseBody
@RequestMapping("/loadData")
public Object loadData() {

AjaxResult result = new AjaxResult();

try {

List<Permission> root = new ArrayList<Permission>();

Permission parent = permissionService.getPermissionRoot(); //根节点

List<Permission> children = permissionService.getPermissionByPid(parent.getId()); //子节点: 分支节点

parent.setChildren(children);

for (Permission permission : children) {
List<Permission> childrenList = permissionService.getPermissionByPid(permission.getId()); // 子节点: 叶子节点 

permission.setChildren(childrenList);
}

root.add(parent);

result.setData(root);
result.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
result.setSuccess(false);
}

return result;
}*/

//Demo1
/*@ResponseBody
@RequestMapping("/loadData")
public Object loadData() {

AjaxResult result = new AjaxResult();

try {

List<Permission> root = new ArrayList<Permission>();

Permission parent = new Permission(); //真正的根节点.
parent.setName("系统权限菜单");

List<Permission> children = new ArrayList<Permission>();

Permission child1 = new Permission();
child1.setName("控制面板");


Permission child2 = new Permission();
child2.setName("权限管理");

children.add(child1);
children.add(child2);


parent.setChildren(children);

root.add(parent);


result.setData(root);
result.setSuccess(true);
} catch (Exception e) {
e.printStackTrace();
result.setSuccess(false);
}

return result;

}*/

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.atguigu.atcrowdfunding.manager.dao.PermissionMapper">
<resultMap id="BaseResultMap" type="com.atguigu.atcrowdfunding.bean.Permission">
<id column="id" property="id" jdbcType="INTEGER" />
<result column="pid" property="pid" jdbcType="INTEGER" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="icon" property="icon" jdbcType="VARCHAR" />
<result column="url" property="url" jdbcType="VARCHAR" />
</resultMap>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
delete from t_permission
where id = #{id,jdbcType=INTEGER}
</delete>
<insert id="insert" parameterType="com.atguigu.atcrowdfunding.bean.Permission">
insert into t_permission (id, pid, name,
icon, url)
values (#{id,jdbcType=INTEGER}, #{pid,jdbcType=INTEGER},
#{name,jdbcType=VARCHAR},
#{icon,jdbcType=VARCHAR}, #{url,jdbcType=VARCHAR})
</insert>
<update id="updateByPrimaryKey" parameterType="com.atguigu.atcrowdfunding.bean.Permission">
update t_permission
set 
name = #{name,jdbcType=VARCHAR},
icon = #{icon,jdbcType=VARCHAR},
url = #{url,jdbcType=VARCHAR}
where id = #{id,jdbcType=INTEGER}
</update>
<select id="selectByPrimaryKey" resultMap="BaseResultMap"
parameterType="java.lang.Integer">
select id, pid, name, icon, url
from t_permission
where id = #{id,jdbcType=INTEGER}
</select>
<select id="queryAllPermission" resultMap="BaseResultMap">
select id, pid, name, icon, url
from t_permission
</select>

<select id="getPermissionRoot" resultMap="BaseResultMap">
select id, pid, name, icon, url
from t_permission where pid=0 
</select>

<select id="getPermissionByPid" resultMap="BaseResultMap" parameterType="int">
select id, pid, name, icon, url
from t_permission where pid = #{id} 
</select>










</mapper>