<select id="count" parameterType="User" resultType="java.lang.Integer">
SELECT id FROM USER
</select>
<select id=”selectUsers” parameterType=”int” resultType=”hashmap”>
select id, username, hashedPassword
from some_table
where id = #{id}
</select>
<typeAlias type=”com.entity.User” alias=”User”/>
设了别名 就不用使用全名了。