ibatis分为内联映射和显示映射,内联映射就是把类字段和数据库字段之间的关系在SQL语句中对应,显示映射是把类字段和数据库字段之间的关系同过一个ResultMap来对应.
[color=red]内联映射:[/color]
[color=red]显示映射:[/color]
[color=red]内联映射:[/color]
<select id="selectUserById" resultClass="User" parameterClass="int">
select T_ID as id, T_NAME as name, T_SEX as sex, T_ADDRESS as address
from t_user where id = #id#
</select>
[color=red]显示映射:[/color]
<resultMap id="UserResult" class="User">
<result property="id" column="T_ID"/>
<result property="name" column="T_NAME"/>
<result property="sex" column="T_SEX"/>
<result property="address" column="T_ADDRESS"/>
</resultMap>
<select id="selectAllUser" resultMap="UserResult">
select * from t_user
</select>