Using Ibatis 一

Using Ibatis 1
1.mapping file: site.xml

<?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 namespace="SiteConfig">

	<typeAlias alias="SiteConfig"
		type="com.dingfei.vo.SiteConfig" />
		
	<resultMap id="SiteConfigMap" class="SiteConfig">
		<result property="siteID" column="SITEID"/>
		<result property="itemName" column="ITEMNAME"/>
		<result property="itemValue" column="ITEMVALUE"/>
	</resultMap>
	
	<parameterMap id="SiteConfigParamMap" class="SiteConfig">
		<parameter property="siteID" />
		<parameter property="itemName" />
		<parameter property="itemValue" />
	</parameterMap>

	<!-- using VOMap as resultMap -->
	<select id="selectAllSiteConfig" resultMap="SiteConfigMap">
		Select SITEID,ITEMNAME,ITEMVALUE from siteConfig
	</select>
	
	<select id="updateSite" parameterClass="java.util.HashMap">
		update siteConfig
		set ITEMVALUE=#itemvalue#
		where SITEID = #siteid# and ITEMNAME=#itemname#
	</select>
	
	<!-- using HashMap as  parameterClass-->
	<insert id="insertSiteByMap" parameterClass="java.util.HashMap"> 
		insert into siteConfig(SITEID,ITEMNAME,ITEMVALUE)
		values(#siteid#,#itemname#,#itemvalue#)
	</insert>
	
	<!-- using HashMap as parameterClass, PK-siteid is auto-increment -->
	<insert id="insertSiteByMapWithoutSiteID" parameterClass="java.util.HashMap"> 
		insert into siteConfig(ITEMNAME,ITEMVALUE)
		values(#itemname#,#itemvalue#)
	</insert>
	
	<!-- using VO mapping as parameterClass -->
	<insert id="insertSiteByVO" parameterClass="SiteConfig"> 
		insert into siteConfig(SITEID,ITEMNAME,ITEMVALUE)
		values(#siteID#,#itemName#,#itemValue#)
	</insert>
	
	<!-- using  VOMap as parameterMap-->
	<insert id="insertSiteByVOMap" parameterMap="SiteConfigParamMap"> 
		insert into siteConfig(SITEID,ITEMNAME,ITEMVALUE)
		values(?,?,?)
	</insert>
	
	<delete id="deleteSiteBySiteID">
		delete 
		from siteConfig
		where siteID = #siteid#
	</delete>
</sqlMap>

2. employee.xml

  <?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 namespace="Employee">

	<typeAlias alias="Employee"
		type="com.dingfei.vo.Employee" />
		
	<resultMap id="EmployeeMap" class="Employee">
		<result property="userName" column="username"/>
		<result property="email" column="email"/>
	</resultMap>

	<select id="selectAllEmployee" resultMap="EmployeeMap">
		Select * from Employee
	</select>
</sqlMap>