<!-- 类别名定义 -->
<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>