JAva再帰クエリーツリー構造
2496 ワード
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); } } }