user.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="User" type="cn.com.tarena.ecport.pojo.User" />
	<typeAlias alias="Orders" type="cn.com.tarena.ecport.pojo.Orders" />
	<typeAlias alias="ContactInfo" type="cn.com.tarena.ecport.pojo.ContactInfo"/>
	<resultMap id="user_base"
		class="cn.com.tarena.ecport.pojo.User">
		<result property="userid" column="userid" />
		<result property="password" column="password" />
	</resultMap>
	
	<resultMap id="user_result"
		class="cn.com.tarena.ecport.pojo.User" extends="user_base">
		<result property="contactinfo" column="userid"
			select="getContactInfoId1" />
		<result property="orderses" column="userid"
			select="getOrdersesId2" />
	</resultMap>
	
	<select id="getOrdersesId2" parameterClass="String" resultClass="Orders">
		SELECT * FROM Orders where userid = #userid#
	</select>
	
	<select id="getContactInfoId1" parameterClass="String" resultClass="Contactinfo">
		SELECT * FROM contactinfo where userid = #userid#
	</select>
	<select id="findAllUsers" resultMap="user_result">
		select * from users
	</select>
	<!--
		<select id="findAllUsers" resultClass="User">
		select * from users
		</select>
		
	-->
	<insert id="saveUser" parameterClass="User">
		insert into users(userid,password) values(#userid#,#password#)
	</insert>

	<select id="findUserById" parameterClass="String"
		resultMap="user_result">
		select * from Users where userid=#userid#
	</select>

	<delete id="deleteUser" parameterClass="User">
		delete from Users where userid=#userid#  
	</delete>

	<update id="saveorUpdateUser" parameterClass="User">
		update Users set password=#password# where userid=#userid#
	</update>
</sqlMap>