62,621
社区成员
发帖
与我相关
我的任务
分享
class User {
private String catalogId;
private String serviceId;
private String parentId;
public String getCatalogId() {
return catalogId;
}
public void setCatalogId(String catalogId) {
this.catalogId = catalogId;
}
public String getServiceId() {
return serviceId;
}
public void setServiceId(String serviceId) {
this.serviceId = serviceId;
}
public String getParentId() {
return parentId;
}
public void setParentId(String parentId) {
this.parentId = parentId;
}
}
javaBean这样就可以了
然后你在循环取数据的代码里,例如(伪代码)
List list = new ArrayList();
for(循环记录集) {
String catalogId = rs.getString("catalog_ID");
String catalogId = rs.getString("serviceId");
String catalogId = rs.getString("parentId");
//进行设值
User user = new User();
user.setCatalogId(catalogId )
....
....
list.add(user);
}
setAttribute("treeData",list); select id,parent_id,LEVEL from table start with id='根结点ID' connect by prior id=parent_id