province.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="Province"
		type="cn.com.tarena.ecport.pojo.Province" />
		
  <resultMap id="Province_base"
		class="cn.com.tarena.ecport.pojo.Province">
		<result property="id" column="id" />
		<result property="name" column="name" />
		<result property="countryid" column="countryid" />
	</resultMap>
	
	<resultMap id="Province_result"
		class="cn.com.tarena.ecport.pojo.Province" extends="Province_base">
		<result property="country" column="countryid"
			select="getprovincebycountryid" />
		</resultMap>
	
	<resultMap id="Province_result2"
		class="cn.com.tarena.ecport.pojo.Province" extends="Province_base">
	   <result property="contactinfos" column="countryid"
			select="getcontactinfobyprovinceid" />
	</resultMap>
	
	<select id="getcontactinfobyprovinceid" resultClass="ContactInfo">
		select * from ContactInfo where  provinceid=#provinceid#
	</select>
	
	<select id="getprovincebycountryid" resultClass="Province">
			select * from province where countryid=#countryid#
	</select>
		
		
    <select id="selectAllProvince" resultMap="Province_base">
		select * from province
	</select>
	<delete id="deleteprovince" parameterClass="Province">
		delete from Province where   id=#id#
	</delete>
	<select id="findProvinceById" parameterClass="long"  resultMap="Province_base">
		select * from province where id=#id#
	</select>
	
	<select id="getProvinceOfCountry" parameterClass="int"  resultMap="Province_base">
		select * from province where countryid=#countryid#
	</select>
	
	<insert id="saveProvince" parameterClass="Province">
		<selectKey resultClass="long" keyProperty="id">
			select studentPKSequence.nextVal from dual
		</selectKey>
		insert into province(id,name,countryid) values (#id#,#name#,#countryid#)
	</insert>
	<update id="modifyProvince" parameterClass="Province">
		update province set name=#name#,countryid=#countryid#
		where id=#id#
	</update>
</sqlMap>