orders.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="Orders" type="cn.com.tarena.ecport.pojo.Orders" />
	<typeAlias alias="OrderStatus"
		type="cn.com.tarena.ecport.pojo.OrderStatus" />
	<typeAlias alias="PayWay" type="cn.com.tarena.ecport.pojo.PayWay" />
	<typeAlias alias="OrderLine"
		type="cn.com.tarena.ecport.pojo.OrderLine" />
	<typeAlias alias="User" type="cn.com.tarena.ecport.pojo.User" />

	<resultMap id="Orders_base"
		class="cn.com.tarena.ecport.pojo.Orders">
		<result property="orderid" column="orderid" />
		<result property="statusid" column="statusid" />
		<result property="name" column="name" />
		<result property="cost" column="cost" />
		<result property="paywayid" column="paywayid" />
		<result property="userid" column="userid" />
	</resultMap>

	<resultMap id="Orders_result1"
		class="cn.com.tarena.ecport.pojo.Orders" extends="Orders_base">
		<result property="users" column="userid"
			select="getUserbyorderId" />
		<result property="orderstatus" column="statusid"
			select="getstatusbyorderId" />
		<result property="payway" column="paywayid"
			select="getpaywaybyorderId" />
	</resultMap>

	<resultMap id="Orders_result2"
		class="cn.com.tarena.ecport.pojo.Orders" extends="Orders_result1">
		<result property="orderlines" column="orderid"
			select="getorderlinesbyorderId" />
	</resultMap>
	<select id="getUserbyorderId" parameterClass="String"
		resultClass="User">
		select * from users where userid=#userid#
	</select>

	<select id="getstatusbyorderId" parameterClass="long"
		resultClass="OrderStatus">
		select * from OrderStatus where statusid=#statusid#
	</select>
	
	<select id="getpaywaybyorderId" parameterClass="long"
		resultClass="PayWay">
		select * from PayWay where paywayid=#paywayid#
	</select>
	
	
	<select id="getorderlinesbyorderId" parameterClass="long"
		resultClass="OrderLine">
		select * from OrderLine where orderid=#orderid#
	</select>



	<select id="findAllOrders" resultMap="Orders_result2">
		select * from orders
	</select>

	<insert id="saveOrders" parameterClass="Orders">
		<selectKey resultClass="Long" keyProperty="orderid">
			select studentPKSequence.nextVal from dual
		</selectKey>
		insert into Orders(orderid,name,cost,userid,paywayid,statusid)
		values(#orderid#,#name#,#cost#,#userid#,#paywayid#,#statusid#)
	</insert>

	<select id="findOrdersById" parameterClass="Long"
		resultMap="Orders_result2">
		select * from Orders where orderid=#orderid#
	</select>

	<delete id="deleteOrders" parameterClass="Orders">
		delete from Orders where orderid=#orderid#
	</delete>

	<update id="saveorUpdateOrders" parameterClass="Orders">
		update Orders set 
		 name=#name#,
		 cost = #cost#,
		 userid=#userid#,
		 paywayid=#paywayid#,
		 statusid=#statusid#
	     where
		 orderid=#orderid#
	</update>
</sqlMap>