country.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="Country" type="cn.com.tarena.ecport.pojo.Country" />
	<typeAlias alias="ContactInfo"
		type="cn.com.tarena.ecport.pojo.ContactInfo" />
	<typeAlias alias="Province"
		type="cn.com.tarena.ecport.pojo.Province" />

	<resultMap id="Country_base"
		class="cn.com.tarena.ecport.pojo.Country">
		<result property="id" column="id" />
		<result property="name" column="name" />
	</resultMap>

	<resultMap id="Country_result"
		class="cn.com.tarena.ecport.pojo.Country" extends="Country_base">
		<result property="provinces" column="id"
			select="Provincebycountryid" />
	</resultMap>
	<resultMap id="Country_result2"
		class="cn.com.tarena.ecport.pojo.Country" extends="Country_result">
		<result property="contactinfos" column="id"
			select="getcontactinfobycountryid" />
	</resultMap>
	<select id="Provincebycountryid" parameterClass="int"
		resultClass="Province">
		select * from province where countryid=#countryid#
	</select>

	<select id="getcontactinfobycountryid" parameterClass="long"
		resultClass="ContactInfo">
		select * FROM contactInfo where countryid = #countryid#
	</select>

	<select id="findAllCountry" resultMap="Country_result2">
		select * from country
	</select>

	<delete id="deleteCountry" parameterClass="Country">
		delete from country where id=#id#
	</delete>
	<select id="findCountryById" parameterClass="long"
		resultMap="Country_result2">
		select * from country where id=#id#
	</select>

	<insert id="saveCountry" parameterClass="Country">
		<selectKey resultClass="long" keyProperty="id">
			select studentPKSequence.nextVal from dual
		</selectKey>
		insert into country(id,name) values (#id#,#name#)
	</insert>
	<update id="modifyCountry" parameterClass="Country">
		update Country set name=#name# where id=#id#
	</update>
</sqlMap>