payway.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="PayWay" type="cn.com.tarena.ecport.pojo.PayWay"/>
   <typeAlias alias="Orders" type="cn.com.tarena.ecport.pojo.Orders" />
   
   <resultMap id="payway_base"
		class="cn.com.tarena.ecport.pojo.PayWay">
		<result property="paywayid" column="paywayid" />
		<result property="paystyle" column="paystyle" />
	</resultMap>
	
   <resultMap id="payway_result"
		class="cn.com.tarena.ecport.pojo.PayWay" extends="payway_base">
		<result property="orderses" column="paywayid"
			select="getOrdersesByPaywayid" />
	</resultMap>
	
	<select id="getOrdersesByPaywayid" parameterClass="Long" resultClass="Orders">
		SELECT * FROM Orders where paywayid =#paywayid#
	</select>
	
   <select id="findAllPayWay" resultMap="payway_result">
     select * from PayWay
   </select>
   
   <insert id="savePayWay" parameterClass="PayWay">
   <selectKey resultClass="Long" keyProperty="paywayid">
   select studentPKSequence.nextVal from dual
   </selectKey>
     insert into PayWay(paywayid,paystyle)
     values(#paywayid#,#paystyle#)
   </insert>
   
   <select id="findPayWayById" 
   parameterClass="Long" resultMap="payway_result">
   select  * 
   from PayWay 
   where paywayid=#paywayid#
   </select>
   
   <delete id="deletePayWay" parameterClass="PayWay">
      delete 
      from PayWay
      where paywayid=#paywayid#
   </delete>
   
   <update id="saveorUpdatePayWay" parameterClass="PayWay">
   update PayWay
   set paystyle=#paystyle#       
       where paywayid=#paywayid#
   </update>
 </sqlMap>