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>
问题竟然解决了....