iBATIS笔记

最新推荐文章于 2022-10-09 21:58:00 发布

原创最新推荐文章于 2022-10-09 21:58:00 发布 · 204 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#iBATIS #Oracle #MySQL #SQL Server #XML

Framework 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一对多关联查询的两种方式：子查询和联合查询，并展示了如何在iBATIS中配置这些查询。此外，还提供了在不同数据库（如Oracle、SQL Server和MySQL）中获取自增主键的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1: 一对多关联
持有复杂类型的类为一方,复杂类型为多方.

2: 一对多关联 :

		<!-- 多（book）对一（catelog）子查询方式

		<resultMap class="book" id="getBook">

		  <!-- 普通property -->
			<result property="bookid" column="bookid"/>
			<result property="bookname" column="bookname"/>
			<result property="price" column="price"/>
			<result property="picture" column="picture"/>

			<!-- 一方 -->
		  <result property="catelog" column="catelogid" 
		    	    select="getCategory"/><!-- 注意 1 getCategory -->
		</resultMap>

		<resultMap class="catelog" id="getCatelog">
			<result property="catelogid" column="catelogid"/>
			<result property="catelogname" column="catelogname"/>
		</resultMap>

		<select id="findBookByProperty"
				parameterClass="pv"
				resultMap="getBook">
			SELECT bookid, catelogid, bookname, price, picture, jointime 
			FROM book
			WHERE $property$=#value#
		</select>

		<!-- 注意 对应 1 -->
		<select id="getCategory" parameterClass="int" 
				resultMap="getCatelog">
			SELECT catelogid, catelogname 
			FROM catelog 
			WHERE catelogid=#catelogid#
		</select> 
	 -->

3: 一对多关联 : 联合查询方式

	<!-- 多（book）对一（catelog）联合查询方式 -->
	 <resultMap class="book" id="getBook">

	 	<!-- 普通property -->
		<result property="bookid" column="bookid"/>
		<result property="bookname" column="bookname"/>
		<result property="price" column="price"/>
		<result property="picture" column="picture"/>

		<!-- 一方 -->
	  <result property="catelog.catelogid" column="catelogid" />
	  <result property="catelog.catelogname" column="catelogname" />
	</resultMap>

	 <select id="findBookByProperty"
			parameterClass="pv"
			resultMap="getBook">
		SELECT bookid, book.catelogid, bookname, price, picture, jointime, catelog.catelogid, catelogname 
		FROM book, catelog
		WHERE book.catelogid=catelog.catelogid
		AND `book`.$property$=#value#
	</select>

4:iBATIS在各主流数据库中获得自增主键的方式

	<!-- Oracle SEQUENCE Example -->
	<insert id="insertProduct-ORACLE" parameterClass="com.domain.Product">
		<selectKey resultClass="int" keyProperty="id" >
			SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
		</selectKey>
		insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
		values (#id#,#description#)
	</insert>

	<!-- Microsoft SQL Server IDENTITY Column Example -->
	<insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">
		insert into PRODUCT (PRD_DESCRIPTION)
		values (#description#)
		<selectKey resultClass="int" keyProperty="id" >
			SELECT @@IDENTITY AS ID
		</selectKey>
	</insert>

	<!-- MySQL auto_increment Column Example -->
	<insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">
		insert into PRODUCT (PRD_DESCRIPTION)
		values (#description#)
		<selectKey resultClass="int" keyProperty="id" >
			SELECT last_insert_id()
		</selectKey>
	</insert>