orderstatus.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="OrderStatus" type="cn.com.tarena.ecport.pojo.OrderStatus"/>
   <typeAlias alias="Orders" type="cn.com.tarena.ecport.pojo.Orders" />
   
   <resultMap id="status_base"
		class="cn.com.tarena.ecport.pojo.OrderStatus">
		<result property="statusid" column="statusid" />
		<result property="name" column="name" />
		<result property="description" column="description" />
	</resultMap>
	
   <resultMap id="payway_result"
		class="cn.com.tarena.ecport.pojo.OrderStatus" extends="status_base">
		<result property="orderses" column="statusid"
			select="getOrdersesBystatusid" />
	</resultMap>
	
	<select id="getOrdersesBystatusid" parameterClass="Long" resultClass="OrderStatus">
		SELECT * FROM OrderStatus where statusid =#statusid#
	</select>
	
   <select id="findAllOrderStatus" resultMap="payway_result">
     select * from OrderStatus
   </select>
   
   <insert id="saveOrderStatus" parameterClass="OrderStatus">
   <selectKey resultClass="Long" keyProperty="statusid">
   select studentPKSequence.nextVal from dual
   </selectKey>
     insert into OrderStatus(statusid,name)
     values(#statusid#,#name#)
   </insert>
   
   <select id="findOrderStatusById" 
   parameterClass="Long" resultMap="payway_result">
   select  * 
   from OrderStatus 
   where statusid=#statusid#
   </select>
   
   <delete id="deleteOrderStatus" parameterClass="OrderStatus">
      delete 
      from OrderStatus
      where statusid=#statusid#
   </delete>
   
   <update id="saveorUpdateOrderStatus" parameterClass="OrderStatus">
   update OrderStatus
   set name=#name#       
       where statusid=#statusid#
   </update>
 </sqlMap>