省份/品种树查询

最新推荐文章于 2024-08-12 16:47:32 发布

weixin_44735409

最新推荐文章于 2024-08-12 16:47:32 发布

阅读量52

点赞数

文章标签： java

本文链接：https://blog.csdn.net/weixin_44735409/article/details/128835509

版权

建表sql

CREATE TABLE "public"."sys_dict_data" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "parent_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "parent_ids" varchar(2000) COLLATE "pg_catalog"."default" NOT NULL,
  "tree_sort" numeric(10,0) NOT NULL,
  "tree_sorts" varchar(1200) COLLATE "pg_catalog"."default" NOT NULL,
  "tree_leaf" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "tree_level" numeric(4,0) NOT NULL,
  "tree_names" varchar(2000) COLLATE "pg_catalog"."default" NOT NULL,
  "dict_label" varchar COLLATE "pg_catalog"."default" NOT NULL,
  "dict_value" varchar COLLATE "pg_catalog"."default" NOT NULL,
  "dict_type" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "is_sys" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "description" varchar(500) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default",
  "create_date" timestamp(6),
  "update_by" varchar(64) COLLATE "pg_catalog"."default",
  "update_date" timestamp(6),
  "remarks" varchar(500) COLLATE "pg_catalog"."default",
  "del_flag" varchar(10) COLLATE "pg_catalog"."default",
  "value_type" varchar(255) COLLATE "pg_catalog"."default",
  "value_dict_type" varchar(255) COLLATE "pg_catalog"."default",
  "extend" varchar COLLATE "pg_catalog"."default",
  CONSTRAINT "sys_dict_data_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "public"."sys_dict_data" 
  OWNER TO "postgres";

COMMENT ON COLUMN "public"."sys_dict_data"."id" IS '字典编码';

COMMENT ON COLUMN "public"."sys_dict_data"."parent_id" IS '父级编号';

COMMENT ON COLUMN "public"."sys_dict_data"."parent_ids" IS '所有父级编号';

COMMENT ON COLUMN "public"."sys_dict_data"."tree_sort" IS '本级排序号（升序）';

COMMENT ON COLUMN "public"."sys_dict_data"."tree_sorts" IS '所有级别排序号';

COMMENT ON COLUMN "public"."sys_dict_data"."tree_leaf" IS '是否最末级';

COMMENT ON COLUMN "public"."sys_dict_data"."tree_level" IS '层次级别';

COMMENT ON COLUMN "public"."sys_dict_data"."tree_names" IS '全节点名';

COMMENT ON COLUMN "public"."sys_dict_data"."dict_label" IS '字典标签';

COMMENT ON COLUMN "public"."sys_dict_data"."dict_value" IS '字典键值';

COMMENT ON COLUMN "public"."sys_dict_data"."dict_type" IS '字典类型';

COMMENT ON COLUMN "public"."sys_dict_data"."is_sys" IS '系统内置（1是 0否）';

COMMENT ON COLUMN "public"."sys_dict_data"."description" IS '字典描述';

COMMENT ON COLUMN "public"."sys_dict_data"."create_by" IS '创建者';

COMMENT ON COLUMN "public"."sys_dict_data"."create_date" IS '创建时间';

COMMENT ON COLUMN "public"."sys_dict_data"."update_by" IS '更新者';

COMMENT ON COLUMN "public"."sys_dict_data"."update_date" IS '更新时间';

COMMENT ON COLUMN "public"."sys_dict_data"."remarks" IS '备注信息';

COMMENT ON COLUMN "public"."sys_dict_data"."del_flag" IS '删除标记(0:正常;1:删除)';

COMMENT ON COLUMN "public"."sys_dict_data"."value_type" IS '字典键值类型';

COMMENT ON COLUMN "public"."sys_dict_data"."value_dict_type" IS '字段值-挂载字典';

COMMENT ON COLUMN "public"."sys_dict_data"."extend" IS '是否开启扩展';

COMMENT ON TABLE "public"."sys_dict_data" IS '字典数据表';

数据

树查询需要的dto

@Table("sys_dict_data")
public class SysDictDataVO implements Serializable {

	/**
	 * 字典编码
	 */
	@Name
	@Prev(els = {@EL("uuid()")})
	@Column("id")
	private String id;
	/**
	 * 父级编号
	 */
	@Column("parent_id")
	private String parentId;

	private  String parentName;
	/**
	 * 所有父级编号
	 */
	@Column("parent_ids")
	private String parentIds;
	/**
	 * 本级排序号（升序）
	 */
	@Column("tree_sort")
	private Long treeSort;
	/**
	 * 所有级别排序号
	 */
	@Column("tree_sorts")
	private String treeSorts;
	/**
	 * 是否最末级 (0:末级、1:不是末级)
	 */
	@Column("tree_leaf")
	private String treeLeaf;
	/**
	 * 层次级别
	 */
	@Column("tree_level")
	private Integer treeLevel;
	/**
	 * 全节点名
	 */
	@Column("tree_names")
	private String treeNames;
	/**
	 * 字典标签
	 */
	@Column("dict_label")
	private String dictLabel;
	/**
	 * 字典键值
	 */
	@Column("dict_value")
	private String dictValue;
	/**
	 * 字典类型
	 */
	@Column("dict_type")
	private String dictType;
	/**
	 * 系统内置（1是 0否）
	 */
	@Column("is_sys")
	private String isSys;
	/**
	 * 字典描述
	 */
	@Column("description")
	private String description;

	/**
	 * 创建者
	 */
	@Column("create_by")
	private String createBy;
	/**
	 * 创建时间
	 */
	@Column("create_date")
	private java.util.Date createDate;
	/**
	 * 更新者
	 */
	@Column("update_by")
	private String updateBy;
	/**
	 * 更新时间
	 */
	@Column("update_date")
	private java.util.Date updateDate;
	/**
	 * 备注信息
	 */
	@Column("remarks")
	private String remarks;


	/**
	 * 删除标记(0:正常;1:删除)
	 */
	@Column("del_flag")
	private String delFlag;

	private List<SysDictDataVO> children;
	}

用到的工具类


```java
package cn.agriculture.sharing.admin.sys.utils;

import cn.agriculture.sharing.admin.sys.common.Const;
import cn.agriculture.sharing.admin.sys.common.CrmException;
import cn.agriculture.sharing.admin.sys.common.SystemCodeEnum;
import cn.hutool.core.bean.BeanUtil;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Objects;

/**
 * @author zhangzhiwei
 * 递归相关的util包
 */
public class RecursionUtil {

    /**
     * 递归查询列表
     *
     * @param allList    总数据
     * @param parentName 上级的key
     * @param parentId   上级的值
     * @param idName     本级ID的key
     * @param returnName 返回的类型 null代表返回对象类型
     * @param <R>        list类型
     * @param <T>        返回类型
     * @return
     */
    public static <R, T> List<T> getChildList(List<R> allList, String parentName, Object parentId, String idName, String returnName) {
        return getChildList(allList, parentName, parentId, idName, returnName, 20);
    }

    /**
     * 递归查询列表
     *
     * @param allList    总数据
     * @param parentName 上级的key
     * @param parentId   上级的值
     * @param idName     本级ID的key
     * @param returnName 返回的类型,null代表返回对象类型
     * @param depth      最大递归层级
     * @param <R>
     * @param <T>
     * @return
     */
    @SuppressWarnings("unchecked")
    public static <R, T> List<T> getChildList(List<R> allList, String parentName, Object parentId, String idName, String returnName, Integer depth) {
        depth--;
        List<T> arrList = new ArrayList<>();
        if (depth < 0) {
            return arrList;
        }
        for (R r : allList) {
            Map<String, Object> beanMap = BeanUtil.beanToMap(r);
            if (!(beanMap.containsKey(idName) && beanMap.containsKey(parentName))) {
                throw new CrmException(SystemCodeEnum.SYSTEM_NO_SUCH_PARAMENT_ERROR);
            }
            if (Objects.equals(parentId, beanMap.get(parentName))) {
                if (returnName == null) {
                    arrList.add((T) r);
                } else {
                    arrList.add((T) beanMap.get(returnName));
                }
                arrList.addAll(getChildList(allList, parentName, beanMap.get(idName), idName, returnName, depth));
            }
        }
        return arrList;
    }

    /**
     * 递归查询列表数
     *
     * @param allList    总数据
     * @param parentName 上级的key
     * @param parentId   上级的值
     * @param idName     本级ID的key
     * @param treeName   子级树名称
     * @param <R>        list类型
     * @return
     */
    public static <R, T> List<T> getChildListTree(List<R> allList, String parentName, Object parentId, String idName, String treeName, Class<T> clazz) {
        return getChildListTree(allList, parentName, parentId, idName, treeName, clazz, Const.AUTH_DATA_RECURSION_NUM);
    }

    /**
     * 递归查询列表树
     *
     * @param allList    总数据
     * @param parentName 上级的key
     * @param parentId   上级的值
     * @param idName     本级ID的key
     * @param treeName   子级树名称
     * @param depth      最大递归层级
     * @return data
     */

    public static <R, T> List<T> getChildListTree(List<R> allList, String parentName, Object parentId, String idName, String treeName, Class<T> clazz, Integer depth) {
        depth--;
        List<T> arrList = new ArrayList<>();
        if (depth < 0) {
            return arrList;
        }
        for (R data : allList) {
            Map<String, Object> beanMap = BeanUtil.beanToMap(data);
            if (!(beanMap.containsKey(idName) && beanMap.containsKey(parentName))) {
                throw new CrmException(SystemCodeEnum.SYSTEM_NO_SUCH_PARAMENT_ERROR);
            }
            if (Objects.equals(parentId, beanMap.get(parentName))) {
                beanMap.put(treeName, getChildListTree(allList, parentName, beanMap.get(idName), idName, treeName, clazz, depth));
                T toBean = BeanUtil.mapToBean(beanMap, clazz, true);
                arrList.add(toBean);
            }
        }
        return arrList;
    }

}

控制层

```java
public class ChLivestockTreeController {

    @Inject
    private ChLivestockTreeService chLivestockTreeService;

    @At("livestockTree")
    public Object queryLivestockTree(){
        List<SysDictDataVO> list = chLivestockTreeService.queryLivestockTree();
        return Result.success("OK", list);
    }

}

业务层

public interface ChLivestockTreeService {

    List<SysDictDataVO> queryLivestockTree();

}

package cn.agriculture.sharing.admin.sys.service.impl;

import cn.agriculture.framework.base.service.impl.BaseServiceImpl;
import cn.agriculture.sharing.admin.sys.entity.SysDictData;
import cn.agriculture.sharing.admin.sys.entity.SysDictDataVO;
import cn.agriculture.sharing.admin.sys.service.ChLivestockTreeService;
import cn.agriculture.sharing.admin.sys.utils.RecursionUtil;
import org.nutz.dao.Cnd;
import org.nutz.dao.Dao;
import org.nutz.ioc.loader.annotation.IocBean;

import java.util.List;


public class ChLivestockTreeServiceImpl extends BaseServiceImpl<SysDictData> implements ChLivestockTreeService {
    public ChLivestockTreeServiceImpl(Dao dao) {
        super(dao);
    }
    @Override
    public List<SysDictDataVO> queryLivestockTree() {
        Cnd cnd = Cnd.where("del_flag","=","0");
        cnd.and("dict_type","=","ch_animal_species");
        //查询结果
        List<SysDictData> query = this.query(cnd.asc("tree_sort"));
        List<SysDictDataVO> deptIdList = RecursionUtil.getChildListTree(query, "parentId", "0", "id", "children", SysDictDataVO.class);
        return deptIdList;
    }
}