Mybatis环境的xml配置文件的注意事项

<configuration>
        <!-- 类别名定义 -->
                  <typeAliases>
             <typeAlias alias="user" type="com.user.User"/>
                  </typeAliases>
<!-- 配置Mybatis的环境，事务及数据源等等 -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>

</environments>

      <!-- 指定映射文件或者映射类 -->
<mappers>
<mapper resource="com/user/user.xml" />
</mappers>

</configuration>

===========================================================================================

映射文件（com/user/user.xml）
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">


<mapper namespace="user">


<resultMap type="user" id="userResult">
<result property="userId" column="user_id" jdbcType="INTEGER"
javaType="int" />
<result property="userName" column="user_name" />
<result property="userAccount" column="user_account" />
<result property="userPassword" column="user_password" />
<result property="userPicture" column="user_picture" />
<result property="userStatus" column="user_status" />
<result property="userEmail" column="user_email" />
<result property="userPhone" column="user_phone" />
<result property="dpId" column="depart_id" />
<result property="dpName" column="depart_name" />
<result property="user_role_id" column="user_role_id" />
<result property="user_sex" column="user_sex" />
</resultMap>
       <select id="findUserById" parameterType="user" resultMap="userResult">
SELECT * FROM tb_user where depart_id IS NULL
AND user_status=0
<if test="userId!=null and userId!=0">
AND user_id=#{userId}
</if>
</select>

</mapper>