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

解决MyBatis配置中使用小于号导致的Tomcat启动异常

转载于 2015-08-05 19:00:00 发布 · 87 阅读

文章标签：

#java

本文详细介绍了在使用MyBatis时遇到的配置问题，即在配置文件中出现小于号导致的SAXParseException异常，并通过修改条件语句解决了Tomcat无法启动的问题。

今天用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>

问题竟然解决了....