Mybaties 中的 Tag name expected问题
Mybaties在mapper.xml文件编写sql语句时,提示Tag name expected,原因是特殊字符需要转义。
<select id="findUserByLoginNameAndPassword" parameterType="String" resultType="User">
select * from USER_INFO where LOGINNAME = #{loginName} and PASSWORD = #{password} and ROWNUM <= 1
</select>
上述代码中"and ROWNUM <= 1"的"<"符号会报错Tag name expected,修改为:
<select id="findUserByLoginNameAndPassword" parameterType="String" resultType="User">
select * from USER_INFO where LOGINNAME = #{loginName} and PASSWORD = #{password} and ROWNUM <= 1
</select>