ibatis的sqlMap的配置的resultMap元素和resultClass元素的区别。

resultMap自定义Bean和数据库表字段之间的映射关系，如下定义：

<sqlMap namespace="Attendance_exp">

<resultMap class="com.attendance.domain.SignBean" id="signMap">
   <result property="id" column="id"/>
<result property="dept_name" column="dept_name"/>
<result property="sname" column="sname"/>
<result property="sex" column="sex"/>
<result property="mobile_phone" column="mobile_phone"/>
<result property="signin" column="signin"/>
<result property="signout" column="signout"/>
<result property="sts" column="sts"/>
</resultMap>

//resultClass用法如下：

        //typeAlias 定义MagnInfoBean的别名为magnBean。

<typeAlias alias="magnBean" type="com.attendance.domain.MagnInfoBean" />

<select id="MagnInfoDomain_exp_getyyyymmList" parameterClass="map"
resultClass="magnBean">
SELECT T.*,D.NAME,L.DNAME
FROM T_ATT_MAGNINFO T
LEFT JOIN T_ATT_WORK D
ON D.ID = T.WORK_PK
LEFT JOIN T_DISTRICT L
ON T.LO_PK = L.ID
WHERE T.USER_PK = #user_pk#
<isNotEmpty prepend="and" property="yyyymm">
   TO_CHAR(T.WORK_DATE,'YYYYMM')= #yyyymm#
</isNotEmpty>
ORDER BY T.WORK_DATE DESC
</select>

//resultClass再如：

<select id="RecordDomain_exp_getNoAddrRecordList" resultClass="com.attendance.domain.RecordBean">
          SELECT R.id,R.LATITUDE,R.LONGITUDE,R.ADDRESS,R.ENDLATITUDE,R.ENDLONGITUDE,R.ENDADDRESS
 FROM T_ATT_RECORD R
 WHERE R.STS = 'Y' AND (
  ((R.ADDRESS IS NULL OR R.ADDRESS='' OR R.ADDRESS ='(NULL)') 
            AND (R.LONGITUDE IS NOT NULL AND R.LONGITUDE!='0.000000')) 
            or ((R.ENDADDRESS IS NULL OR R.ENDADDRESS='' OR R.ENDADDRESS ='(NULL)') 
            AND (R.ENDLATITUDE IS NOT NULL AND R.ENDLATITUDE!='0.000000' AND R.ENDLATITUDE!='0.0'))
            )
<isNotEmpty prepend="AND" property="org_pk">
R.ORG_PK = #org_pk# 
</isNotEmpty>  
ORDER BY R.ID DESC
</select>

</sqlMap>