Mybatis 异常: The content of elements must consist of well-formed character data or markup

来源:互联网 发布:潜泳技巧 知乎 编辑:程序博客网 时间:2024/05/16 04:44

 今天用mybatis弄一个小玩意,发现Mapper中以下语句报错,且会导致Tomcat无法正常启动

    <select id="getAmountByTimePeriod"  resultMap="seatHisAmountMap">
        select
        sum(nightFare) as nightAmount , sum(fare) as seatAmount ,#{0} as starttime,
        #{1} as endtime
        from nightfare
        where
          endtime >=#{0}
        and
          endtime <=#{1}
    </select>

异常如下:
     SAXParseException: The content of elements must consist of well-formed character data or markup.

百度一下得到一个匪夷所思的答案:

     记住:在ibatis的配置文件中不能出现小于号

抱着试试看的态度试验了一下,代码改为:

  <select id="getAmountByTimePeriod"  resultMap="seatHisAmountMap">
        select
        sum(nightFare) as nightAmount , sum(fare) as seatAmount ,#{0} as starttime,
        #{1} as endtime
        from nightfare
        where
          endtime >=#{0}
        and
          #{1}>=endtime
    </select>
问题竟然解决了....

0 0
原创粉丝点击