列名和属性名都用的驼峰命名法并且名子相同可以用
<setting name="mapUnderscoreToCamelCase" value="true"/>
将自动匹配开启
在一个就是取别名
select is_admin isadmin from t_user where use_id=?;
若是比较多的话就要整体的对应
<resultMap id="myResultMap" type="com.qf.java2107.pojo.User">
<!--
id : 映射主键列,只是一个标识作用,也可以用result
column : 查询的结果集的列名
property : JavaBean的属性名
-->
<id column="uid" property="userId"/>
<!-- result : 映射普通列 -->
<result column="username" property="username"/>
<result column="password" property="password"/>
<result column="name" property="nickName"/>
<result column="is_admin" property="isAdmin"/>
<result column="phone" property="phone"/>
<result column="sex" property="gender"/>
<result column="birth" property="birth"/>
<result column="user_status" property="userStatus"/>
<result column="ctime" property="userCreateTime"/>
<result column="user_update_time" property="userUpdateTime"/>
<result column="is_delete" property="isDelete"/>
<result column="is_member" property="isMember"/>
<result column="balance" property="balance"/>
</resultMap>
<!-- User findByIdUseResultMap(Long userId); -->
<select id="findByIdUseResultMap" parameterType="java.lang.Long" resultMap="myResultMap">
SELECT
user_id uid, username, password, nick_name name, is_admin, phone, gender sex,
birth, user_status, user_create_time ctime, user_update_time, is_delete, is_member, balance
FROM
t_user
WHERE user_id = #{userId}
</select>