java 递归查询树形结构

最新推荐文章于 2024-08-15 03:17:06 发布

果冻_布丁

最新推荐文章于 2024-08-15 03:17:06 发布

阅读量5.6k

点赞数 1

分类专栏： java

本文链接：https://blog.csdn.net/ygd266/article/details/9119983

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

  CREATE TABLE "T_MB_PEAK_POWERTYPE"
   (	"TYPEID" NUMBER(4,0) NOT NULL ENABLE, 
	"TYPENAME" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"UPTYPEID" NUMBER(4,0), 
	"TYPELEVEL" NUMBER(4,0) NOT NULL ENABLE, 
	"ORDERNO" NUMBER(4,0), 
	"DESCRIBE" VARCHAR2(255 BYTE), 
	"VALID" VARCHAR2(8 BYTE)）

   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."TYPEID" IS '类别ID';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."TYPENAME" IS '类别名称';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."UPTYPEID" IS '父类别ID';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."TYPELEVEL" IS '类别级别';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."ORDERNO" IS '显示顺序';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."DESCRIBE" IS '注释信息';
 
   COMMENT ON COLUMN "BSP_HUABEI"."T_MB_PEAK_POWERTYPE"."VALID" IS '是否有效(Y有效N表示无效)';
    /**     * 查询树形结构     * @param id : 父id     */    @SuppressWarnings("unchecked")    public void iterative(int id){         String sql = "select typeid , typename , uptypeid , typelevel , orderno  from T_MB_PEAK_POWERTYPE where uptypeid = ? ";       List<HashMap<String , Object>> list = super.getJdbcTemplate().query(sql, new Object[]{id} ,new MyRowMapper()) ;      if(list!=null && list.size() >0){        for(HashMap<String , Object> map : list){          // 主键id          int typeid = TypeUtil.toInt(map.get("typeid"));          String typename = String.valueOf(map.get("typename"));          System.out.println(typename);          iterative(typeid);        }      }     }