元素内容必须由格式正确的字符数据或标记组成。
2019-08-09 本文已影响0人
平面小狮子
springboot项目启动报错。
![](https://img.haomeiwen.com/i11449491/7f7e81b30a2847da.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解析运算符大于小于号时出错,于是乎将 <= 转换为 <= 即可。