50,526
社区成员
发帖
与我相关
我的任务
分享
public class ConstructionPointPo {
private String fstrId;//编号
...
private List<ConstructionRoadInfoPo> roadInfoList=null;
}
public class ConstructionRoadInfoPo {
private String fstrRoadInfoId;//编号
private String fstrConsId;//关联编号
..
private List<RoadProperty> sectionList;
private List<RoadProperty> roadSectList;
private List<RoadProperty> departList;
private List<RoadProperty> roadNatureList;
...
}
public class RoadProperty {
private String consrId;
private String propertyType;
private String propertyValue;
private String propertyValueName;
}
select a.FSTR_ID fstrId,
a.FSTR_NAME fstrName,
a.FSTR_CODE fstrCode,
b.fstr_id fstrRoadInfoId,
b.fstr_consid fstrConsId,
c.fstr_consrid consrId,
c.fstr_propertytype propertyType,
c.fstr_propertyvalue propertyValue,
d.fstr_roadname propertyValueName
from rt_construction a
left join rt_construction_roadinfo b on a.fstr_id = b.fstr_consid
left join rt_construction_roadproperty c on b.fstr_id = c.fstr_consrid
left join tbl_roadsect d on d.fstr_roadsectid = c.fstr_propertyvalue
and c.fstr_propertytype = 'roadSect'