ibatis的映射

ibatis分为内联映射和显示映射，内联映射就是把类字段和数据库字段之间的关系在SQL语句中对应，显示映射是把类字段和数据库字段之间的关系同过一个ResultMap来对应.

内联映射:

<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>

显示映射：

<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>