<select id="selectUserById" parameterClass="int"
resultMap="userRlt">
<![CDATA[
select ID, userName,serialNumber, createDate,updateDate,activeStatus,address,telephoneNumber,
createUser,updateUser,updateStatusDate,mobileNumber,email
from tb_user
where ID = #ID:DECIMAL#
]]>
</select>
表中的列都需列出,不能用*号
resultMap="userRlt">
<![CDATA[
select ID, userName,serialNumber, createDate,updateDate,activeStatus,address,telephoneNumber,
createUser,updateUser,updateStatusDate,mobileNumber,email
from tb_user
where ID = #ID:DECIMAL#
]]>
</select>
表中的列都需列出,不能用*号