product.xml

这是一个用ibatis实现持久层的 配置文件的例子 希望对初学者有帮助。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
<typeAlias alias="Product" type="cn.com.tarena.ecport.pojo.Product" />
<typeAlias alias="OrderLine"
		type="cn.com.tarena.ecport.pojo.OrderLine" />
<typeAlias alias="Category"
		type="cn.com.tarena.ecport.pojo.Category" />		

<resultMap id="result_base"
		class="cn.com.tarena.ecport.pojo.Product">
		<result property="productid" column="productid" />
		<result property="name" column="name" />
		<result property="baseprice" column="baseprice" />
		<result property="description" column="description" />
		<result property="author" column="author" />
		<result property="publish" column="publish" />
		<result property="pages" column="pages" />
		<result property="images" column="images" />
		<result property="categoryid" column="categoryid" />
	</resultMap>
	<resultMap id="Product_result"
		class="cn.com.tarena.ecport.pojo.Product" extends="result_base">
		<result property="category" column="categoryid"
			select="getcategorybyproductid" />
	</resultMap>
	
	<resultMap id="Product_result2"
		class="cn.com.tarena.ecport.pojo.Product" extends="Product_result">
		<result property="orderlines" column="productid"
			select="getorderlinesbypriductid" />
	</resultMap>
	
	<select id="getcategorybyproductid" parameterClass="Long" resultClass="Category">
		SELECT * FROM  Category  where categoryid = #categoryid#
	</select>
	
	<select id="getorderlinesbypriductid" parameterClass="Long" resultClass="OrderLine">
		SELECT * FROM OrderLine where productid = #productid#
	</select>
   	
	<select id="findAllProduct" resultMap="Product_result2">
		select * from product
	</select>
	
	<delete id="deleteProductByPojo" parameterClass="Product">
		delete from Product where productid = #productid#
	</delete>

	<select id="findProductById" parameterClass="Long"
		resultMap="Product_result2">
		select * from product where productid = #id#
	</select>

	<insert id="insertProduct" parameterClass="Product">
		<selectKey resultClass="long" keyProperty="productid">
			select studentPKSequence.nextVal from dual
		</selectKey>
		insert into
		Product(productid,name,basePrice,description,author,publish,pages,images,categoryid)
		values(#productid#,#name#,#baseprice#,#description#,#author#,#publish#,#pages#,#images#,#categoryid#)
	</insert>

	<update id="updateProduct" parameterClass="Product">
		update 
		product 
		set name = #name#,
		baseprice = #baseprice#,
		description = #description#,
		author = #author#, 
		publish =#publish#,
		pages = #pages# ,
		images = #images# ,
		categoryid = #categoryid# 
		where productid
		= #productid#
	</update>
</sqlMap>