元素内容必须由格式正确的字符数据或标记组成。

2019-08-09  本文已影响0人  平面小狮子

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解析运算符大于小于号时出错,于是乎将 <= 转换为 <= 即可。

上一篇 下一篇

猜你喜欢

热点阅读