ibatis sql地图

ibatis sqlmap
ibatis  一对多  配置   注：返回一个类对象时 sql 语句中
SELECT T.REPLY_ID replyId,T.MESSAGE_ID messageId,T.REPLY_CONTENT replyContent FROM B2B_REPLY T
如果字段名称与实体bean中的不对应  则在sql中应指定对应的bean 名称  否则查询结果为null



<resultMap id="result1" extends="MessageInfo">
        <result property="replys" column="MESSAGE_ID" select="B2B_MASSAGE.getReplyByMsgId"/>
</resultMap>
   
    <select id="getMessageById" parameterresultMap="result1">
<![CDATA[
SELECT
BM.MESSAGE_ID, BM.TITLE, BM.CONTENT, BM.FKMES_ID, BM.FKMES_NAME, BM.TAG, BM.MESSAGE_TIME,
BM.URL, BM.FLAG, BM.LUID, BM.LUNAME, BM.SHOPID
FROM B2B_MASSAGE BM WHERE BM.FKMES_ID=#fkmesId#  ORDER BY BM.MESSAGE_TIME DESC
]]>
</select>
   
   <select id="getReplyByMsgId" parameterresultClass="reply">
<![CDATA[
SELECT T.REPLY_ID replyId,T.MESSAGE_ID messageId,T.REPLY_CONTENT replyContent FROM B2B_REPLY T WHERE T.MESSAGE_ID=#fkmesId#
]]>
</select>