多表关联的例子
<sqlMap namespace="ProductCategory">
<resultMap id=”categoryResult” class=”com.ibatis.example.Category” groupBy=”id”>
<result property=”id” column=”CAT_ID”/>
<result property=”description” column=”CAT_DESCRIPTION”/>
<result property=”productList” resultMap=”ProductCategory.productResult”/>
</resultMap>
<resultMap id=”productResult” class=”com.ibatis.example.Product”>
<result property=”id” column=”PRD_ID”/>
<result property=”description” column=”PRD_DESCRIPTION”/>
</resultMap>
<select id=”getCategory” parameterClass=”int” resultMap=”categoryResult”>
select C.CAT_ID, C.CAT_DESCRIPTION, P.PRD_ID, P.PRD_DESCRIPTION
from CATEGORY C
left outer join PRODUCT P
on C.CAT_ID = P.PRD_CAT_ID
where CAT_ID = #value#
</select>
</sqlMap>
多表关联的例子
<sqlMap namespace="ProductCategory">
<resultMap id=”categoryResult” class=”com.ibatis.example.Category” groupBy=”id”>
<result property=”id” column=”CAT_ID”/>
<result property=”description” column=”CAT_DESCRIPTION”/>
<result property=”productList” resultMap=”ProductCategory.productResult”/>
</resultMap>
<resultMap id=”productResult” class=”com.ibatis.example.Product”>
<result property=”id” column=”PRD_ID”/>
<result property=”description” column=”PRD_DESCRIPTION”/>
</resultMap>
<select id=”getCategory” parameterClass=”int” resultMap=”categoryResult”>
select C.CAT_ID, C.CAT_DESCRIPTION, P.PRD_ID, P.PRD_DESCRIPTION
from CATEGORY C
left outer join PRODUCT P
on C.CAT_ID = P.PRD_CAT_ID
where CAT_ID = #value#
</select>
</sqlMap>
分享到:
相关推荐
ibatis-2.3.4.726.jar,ibatis-2.3.0.677.jar,ibatis-2.3.3.720.jar下载,都已放入一个压缩包下。
ibatis-2.3.3.720.jar
IBatis.DataMapper.1.6.2 和 IBatis.DataMapper.1.9 开发包
Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf Manning.iBATIS.in.Action.Jan.2007.eBook-BBL.pdf
ibatis-2.3.2.715源代码
ibatis-2.3.4.732.jar
ibatis-2.3.3.7.jar
ibatis-2.3.4.726最新API chm格式 非常好用
ibatis-2.3.0.677-sources.jar 值得学习的源码资源,不容错过。
搭建mybatis所需包org.apache.ibatis.annotations.Param @Param
ibatis-2.3.4.726官方最新开发包 和官方资料
ibatis-core-3.0.jar 找了半天,终于找到了,很好的解决了我的问题,给所需要之人!~
ibatis-dao-2.jar gggggggggggg
ibatis-2.3.0.677 ibatis-2.3.0.677 ibatis-2.3.0.677 ibatis-2.3.0.677 ibatis-2.3.0.677 ibatis-2.3.0.677 ibatis-2.3.0.677
ibatis-2.3.4.726-src 源代码,很难找的代码。用来调试和学习很方便。
ibatis-common-2.jar...........
ibatis 2.3 为最稳定Ibatis包版本 该压缩包中还包含ibatis的doc使用文档
ibatis-2.3.2.715.jar包
ibatis.net官方组件 IBatis.DataMapper.1.6.2 IBatis.DataAccess.1.9.2
ibatis-sqlmap ibatis-sqlmap-2 ibatis-sqlmap-2.jar.zip