select id, username, password as pwd from db4.user
id username password 数据库----cloumn
id username pwd 实体类----property
<resultMap id="UserMap" type="User">
<result column="id" property="id"/>
<result column="username" property="username"/>
<result column="password" property="pwd"/>
</resultMap>
<select id="getUserList" resultMap="UserMap">
select id, username, password
from db4.user
</select>
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
原文:https://www.cnblogs.com/changebaobao/p/15149540.html