需求:领导需要数据统计,要求能够展示x表每天新增的条数,并已日历图的形式展示。
- 数据库查询:
SELECT
substr( t.createDate, 6, 5 ) AS DAY,
count( * ) AS num
FROM
TABLE t
WHERE
createDate LIKE '2019%'
GROUP BY
substr( t.createDate, 1, 10 )
查询结果如下
- 放入二维数组中:
int[][] arr = new int[31][12];
for (int i = 0; i < 31; i++) {
for (int j = 0; j < 12; j++) {
for (Map<String, Object> map : list) {//list为sql查询结果
day = (String) map.get("day");
if (j + 1 == Integer.parseInt(day.substring(0, 2)) && i + 1 ==
Integer.parseInt(day.substring(3))) {
arr[i][j] = Integer.parseInt((String) map.get("num").toString());
}
}
}
}
-
最后,将此二维数组返回给前端,页面效果为: