orderline.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="OrderLine"
		type="cn.com.tarena.ecport.pojo.OrderLine" />
		<typeAlias alias="Orders" type="cn.com.tarena.ecport.pojo.Orders" />
		<typeAlias alias="Product" type="cn.com.tarena.ecport.pojo.Product" />
  <resultMap id="OrderLine_base"
		class="cn.com.tarena.ecport.pojo.OrderLine">
		<result property="lineid" column="lineid" />
		<result property="amount" column="amount" />
		<result property="productid" column="productid" />
		<result property="orderid" column="orderid" />
	</resultMap>

	<resultMap id="OrderLine_result1"
		class="cn.com.tarena.ecport.pojo.OrderLine" extends="OrderLine_base">
		<result property="product" column="productid"
			select="getproductbylineid" />
		<result property="orders" column="orderid"
			select="getordersbylineid" />
	</resultMap>
		
	<select id="getproductbylineid" parameterClass="Long"
		resultClass="Product">
		select * from product where productid=#productid#
	</select>
	
	<select id="getordersbylineid" parameterClass="Long"
		resultClass="Orders">
		select * from Orders where orderid=#orderid#
	</select>
	
	<select id="findAllOrderLine" resultMap="OrderLine_result1">
		select * from orderline
	</select>
	
	<select id="findOrderLineById" parameterClass="Long"
		resultMap="OrderLine_result1">
		select * from orderline where lineid = #id#
	</select>
	<delete id="deleteOrderLineByPojo" parameterClass="OrderLine">
		delete from OrderLine where lineid = #lineid#
	</delete>
	
	
	<insert id="insertOrderLine" parameterClass="OrderLine">
           <selectKey resultClass="long" keyProperty="lineid">
			select studentPKSequence.nextVal from dual
		</selectKey>
		insert into OrderLine(lineid,amount,productid,orderid) values(#lineid#,#amount#,#productid#,#orderid#)
	</insert>
	
	<update id="updateOrderLine" parameterClass="OrderLine">
		update OrderLine set
		amount= #amount# ,
		productid= #productid# ,
		orderid= #orderid# 
		where lineid =#lineid#
	</update>
	
</sqlMap>