ㄓㄤㄑㄧㄤ

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

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

问题竟然解决了....

posted @ 2015-08-05 19:00  ㄓㄤㄑㄧㄤ  阅读(2506)  评论(0编辑  收藏  举报
哈哈,页脚部分。