Question

mybatis解析标签错误SAXParseException，提示namespace必须声明，麻烦大家给看一下

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.login">
<select id="checkUser" parameterType="int" resultType="int">
<![CDATA[
select count(user_id) from sys_user where user_name = '#userName'
]]>
</select>

<resultMap type="tprivilegeUser" id="tprivilegeUser">
<id column="USER_ID" property="userId"></id>
<result column="USER_NAME" property="userName"></result>
<result column="USER_SEX" property="sex"></result>
<result column="USER_PWD" property="password"></result>
<result column="USER_ADDRES" property="addres"></result>
<result column="USER_EMAIL" property="email"></result>
<result column="USER_QQ" property="qq"></result>
<result column="USER_MOBILE_PHONE" property="mobilePhone"></result>
<result column="ONLINE" property="online"></result>
<result column="VALID" property="valid"></result>
</resultMap>

<select id="getTprivilegeUser" parameterType="String" resultType="tprivilegeUser" resultMap="tprivilegeUser">
<![CDATA[
select * from T_TPRIVILEGE_USER where USER_NAME = '#identify' or USER_EMAIL='#identify' or USER_MOBILE_PHONE = '#identify'
]]>
</select>

</mapper>
在加载的时候提示Caused by: org.xml.sax.SAXParseException: Attribute "namespace" must be declared for element type "mapper".
我在开头已经定义过了，不知道为什么还报这个错
麻烦帮忙看一下，感激不尽

Answer 1

这么一个简单问题 几年没人回答 我也是新手 还没学完 我都看得到
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
那个Config应该换成Mapper就对了

Answer 2

mybatis-3-mapper.dtd 没找着，解压一下出来本地指定相对路径，很方便

Answer 3

如果没猜错，提示应该是
‘namespace’must be declared for mapper
这个意思是namespace必须在dtd中被定义为mapper结点的元素，建议楼主用alt+/看一下是不是还可以出来一个namespace，如果出来就表示是拼写错了