1.取别名 (as)
2.创建resultMap
(1)整数的jdbcType是INTEGER
(2)字符串的jdbcType是VARCHAR
(3)时间的jdbcType是DATE(年月日),TIMESTAMP(年月日时分秒)
<resultMap id="UserInfo(随便取)" type="实体类位置">
<id column="id" jdbcType="INTEGER" property="id"/>
<result column="user_name" jdbcType="VARCHAR" property="userName"/>
<result column="user_phone" jdbcType="VARCHAR" property="userPhone"/>
<result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
<result column="update_time" jdbcType="TIMESTAMP" property="updateTime"/>
</resultMap>