springboot项目启动报错。
报错信息.png查看代码:
@Select({"<script>" +
"select t.days surgeryDate,count(os.operation_type) surgeryCount " +
"from " +
"(select to_char(trunc(sysdate - #{day})+rownum, 'yyyy-MM-dd') as days from dual connect by rownum <= #{day}-1) t " +
"left join operationscheduling os " +
"on to_char(os.REALITY_TIME, 'yyyy-MM-dd') = t.days and os.order_state = '已排班' and CEIL((os.expected_time - os.reality_time) *24*60) between -#{timeScope} and #{timeScope} " +
"group by t.days " +
"order by t.days asc " +
"</script>"})
List<SurgeryAnalysisVO> getSurgeryOpenByTime(Integer day, Integer timeScope);
发现问题出现在 <= 这里,mybatis解析运算符大于小于号时出错,于是乎将 <= 转换为 <= 即可。
网友评论