推荐 通过来映射字段名和实体类属性名的一一对应关系
<?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="com.lin.dao.UserDao">
<resultMap id="BaseResultMap" type="com.lin.domain.User">
<id column="USER_ID" property="userId" jdbcType="INTEGER" />
<result column="USER_NAME" property="userName" jdbcType="CHAR" />
<result column="USER_PASSWORD" property="userPassword" jdbcType="CHAR" />
<result column="USER_EMAIL" property="userEmail" jdbcType="CHAR" />
</resultMap>
<select id="selectUserByName" parameterType="String" resultMap="BaseResultMap">
SELECT * FROM t_user WHERE USER_NAME = #{userName}
</select>
具体分析
以下面为例
<result column="USER_NAME" property="userName" jdbcType="CHAR" />
USER_NAME:数据库字段名
userName:实体类属性名
ok