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>
