1 数据库对应实体 ReportDeleteIndex.java
/**
* 作者 : **
* 时间 : 20170519
* 类描述 : 问题屏蔽
* 表 TB_JN_INDEX_DELETE
* */
public class ReportDeleteIndex {
private Integer id; //id
private Integer pid; // 父级id
private String indexName; // 指标名称
private Integer order; // 排序
private String delSql; // 删除语句
private List<ReportDeleteIndex> reportDeleteIndexList = new ArrayList<ReportDeleteIndex>();
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public String getIndexName() {
return indexName;
}
public void setIndexName(String indexName) {
this.indexName = indexName;
}
public Integer getOrder() {
return order;
}
public void setOrder(Integer order) {
this.order = order;
}
public String getDelSql() {
return delSql;
}
public void setDelSql(String delSql) {
this.delSql = delSql;
}
public List<ReportDeleteIndex> getReportDeleteIndexList() {
return reportDeleteIndexList;
}
public void setReportDeleteIndexList(
List<ReportDeleteIndex> reportDeleteIndexList) {
this.reportDeleteIndexList = reportDeleteIndexList;
}
}
3 实现方法
public String getReportDeleteIndexs(HttpServletRequest request, HttpServletResponse response){
String result = null;
List<ReportDeleteIndex> reportDeleteIndexList = this.reportDeleteIndexService.getReportDeteleIndexs();
if(reportDeleteIndexList==null||reportDeleteIndexList.size()==0) return JsonUtil.getJson(false, "暂无数据");
Map<Integer,ReportDeleteIndex> reportDeleteIndexMap = new HashMap<Integer,ReportDeleteIndex>();
List<ReportDeleteIndex> resultList = new ArrayList<ReportDeleteIndex>();
for(ReportDeleteIndex reportDeleteIndex:reportDeleteIndexList){
Integer id = reportDeleteIndex.getId();
Integer pid = reportDeleteIndex.getPid();
reportDeleteIndex.setDelSql("");
reportDeleteIndexMap.put(id, reportDeleteIndex);
if(!reportDeleteIndexMap.containsKey(pid)){
resultList.add(reportDeleteIndex);
}else{
ReportDeleteIndex parentReportDeleteIndex = reportDeleteIndexMap.get(pid);
parentReportDeleteIndex.getReportDeleteIndexList().add(reportDeleteIndex);
}
}
result = JsonUtil.getJson(true, "查询成功", resultList);
LOG.debug("result = " + result);
return result;
}