Mybatis总结(3)--之数据库字段名和实体类属性名不一致

推荐 通过来映射字段名和实体类属性名的一一对应关系

<?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