ibatis问题求教

Question

现有商户表:MERCHANT(MER_ID,NAME),商户合同表:CONTRACT(ID,MER_ID,CONTENT)
要用ibatis在contract.xml查询，查询结果为;商户名称，合同编号，合同内容
应该怎样配置呢？

Answer 1

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Contract">
<typeAlias alias="contract" type="xxx.xxx.Contract"></typeAlias>
<select id="getContractInfo" resultClass="contract">
        <![CDATA[
           select NAME,ID,CONTENT from MERCHANT a,CONTRACT,b
           where a.MER_ID=b.MER_ID
        ]]>
</select>
</sqlMap>