String sql = "select * from base_perfpoint t where t.name='住院收入'";
List<Object[]> listSql = systemService.findListbySql(sql);
for (Object[] obj : listSql) {
// Map<String, Object> map = new HashMap<String, Object>();
Clob sc = (Clob) obj[6];
String countSQL = ClobToString(sc).toString();
for (int j = 0; j < dataList.size(); j++) {
String month = dataList.get(j).substring(5, 7);
list1.add(month);
StringBuffer sb = new StringBuffer();
if (type.equals("quanyuan")) {
sb.append("select l.rq,sum(l.sr) from (" + countSQL
+ " and t.统计时间='" + dataList.get(j)
+ "') l group by l.rq ");
}
if (type.equals("zhixi")) {
sb.append("select l.rq,sum(l.sr) from (" + countSQL
+ " and t.统计时间='" + dataList.get(j)
+ "' and t.ksbm='" + ksdpt + "') l group by l.rq ");
}
String str = sb.toString();
List<Object> list = systemService.findListbySql(str);
for (int i = 0; i < list.size(); i++) {
Map<String, Object> map = new HashMap<String, Object>();
Object[] objList = (Object[]) list.get(i);
for (int h = 0; h < objList.length; h++) {
map.put("name", objList[0]);
map.put("value", objList[1]);
}
list2.add(map);
}
自己使用