山坡羊潼关怀古图片:ibatis 框架中的一一映射能否实现两个表之间的连接

ibatis 框架中的一一映射能否实现两个表之间的连接
<select id="getPartBookInfo" resultMap="bookInfoResult" >
select BOOKID,BOOKNAME,AUTHOR,PUBLISHER,BOOKTYPE,PRICE,QUANTITY,REGISTERDAY,COMMENTS from BOOKINFO B,LENDINFO L
WHERE B.BOOKID=L.BOOKID
</select>

<sqlMap namespace="BookInfo">
<typeAlias alias="bookinfo" type="cn.com.dis.weboa.domain.BookInfo"/>

<resultMap id="bookInfoResult" class="bookinfo">
<result property="bookID" column="BOOKID"/>
<result property="bookName" column="BOOKNAME"/>
<result property="bookType" column="BOOKTYPE"/>
<result property="price" column="PRICE"/>
<result property="registerDay" column="REGISTERDAY"/>
<result property="publisher" column="PUBLISHER"/>
<result property="author" column="AUTHOR"/>
<result property="comments" column="COMMENTS"/>
<result property="quantity" column="QUANTITY"/>

<result property="edition" column="EDITION"/>
<result property="bookISBN" column="ISBN"/>
<result property="bookSN" column="SN"/>
<result property="paper" column="PAPER"/>
<result property="words" column="WORDS"/>
<result property="pages" column="PAGES"/>
<result property="prints" column="PRINTS"/>
<result property="printstamp" column="PRINTSTAMP"/>
<result property="contents" column="CONTENTS"/>
<result property="publishDay" column="PUBLISHIDAY"/>

</resultMap>
看到我的等值连接语句了吧!不好使,因为没有加入另一个lendinfo.xml,但我不知道怎么实现?
我的lendifo.xml
<sqlMap namespace="LendInfo">

<typeAlias alias="lendinfo" type="cn.com.dis.weboa.domain.LendInfo"/>

<resultMap id="lendInfoResult" class="lendinfo">
<result property="bookID" column="BOOKID"/>
<result property="userID" column="USERID"/>
<result property="lendDay" column="LENDDAY"/>
<result property="returnDay" column="RETURNDAY"/>
<result property="holdDay" column="HOLDDAY"/>
<result property="lendConfirmDay" column="LENDCONFIRMDAY"/>
<result property="lendConfirmUserID" column="LENDCONFIRMUSERID"/>

<result property="returnConfirmDay" column="RETURNCONFIRMDAY"/>
<result property="returnConfirmUserID" column="RETURNCONFIRMUSERID"/>
</resultMap>
<select id="getAllLendInfo" resultMap="lendInfoResult" >
select BOOKID,USERID,LENDDAY,RETURNDAY,HOLDDAY,LENDCONFIRMDAY,LENDCONFIRMUSERID,RETURNCONFIRMDAY,RETURNCONFIRMUSERID
from LENDINFO
</select>