List中map泛型对应mybatis的返回类型
List<Map<String,Object>>在mybatis对应
resultType="java.util.HashMap"
</select>
<select id="selectExceptionCountBymonths" resultType="java.util.HashMap" >
SELECT
DATE_FORMAT( report_date, '%Y%m' ) label ,
COUNT( 0 ) value
FROM
t_smoke_detector_record
WHERE tsdr_type != "火灾告警"
GROUP BY
label
</select>
@ApiOperation(value = "按照月份统计报警条数",notes = "按照月份统计报警条数")
@GetMapping(value = "warnCountStatistics")
@ActionLog(value = "按照月份统计所有报警条数")
public List<Map<String,Object>> warnCountStatistics(){
List list = smokeDetectorRecordMapper.selectWarnCountBymonths();
return list;
返回结果
fa