employees_parametermap.xml

利用iBatis架构开发Web应用程序的初学实例。

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="Employees" 
xmlns="http://ibatis.apache.org/mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
	<alias>
		<typeAlias alias="Employee" type="DaoProvider.Employee"/>
	</alias>
	
	<statements>
		<select id="Employees_SelectWithParameterClass" parameterClass="Employee" resultClass="Employee" listClass="ArrayList">
			SELECT EmployeeID,LastName,FirstName FROM Employees WHERE EmployeeID = #EmployeeID# OR LastName = #LastName#
		</select>
		<select id="Employees_SelectWithParameterMap1" parameterMap="Employee_SelectParameterMap" resultClass="Employee" listClass="ArrayList">
			SELECT EmployeeID,LastName,FirstName FROM Employees WHERE EmployeeID = #EmployeeID# OR LastName = #LastName# OR Country = #Country#
		</select>
		<select id="Employees_SelectWithParameterMap2" parameterMap="Employee_SelectParameterMap" resultClass="Employee" listClass="ArrayList">
			SELECT EmployeeID,LastName,FirstName FROM Employees WHERE EmployeeID = ? OR LastName = ? OR Country = ?
		</select>

		<insert id="Employee_InsertWithParameterClass" parameterClass="Employee" >
			INSERT INTO Employees(LastName,FirstName) VALUES(#LastName#,#FirstName#)
			<selectKey property="EmployeeID" resultClass="int" type="post">
				SELECT @@IDENTITY AS value
			</selectKey>
		</insert>
		<insert id="Employee_InsertWithParameterMap1" parameterMap="Employee_InsertParameterMap1" >
			INSERT INTO Employees(LastName,FirstName)  VALUES(#LastName#,#FirstName#)
			<selectKey property="EmployeeID" resultClass="int" type="post">
				SELECT @@IDENTITY AS value
			</selectKey>
		</insert>
		<insert id="Employee_InsertWithParameterMap2" parameterMap="Employee_InsertParameterMap1" >
			INSERT INTO Employees(LastName,FirstName)  VALUES(?,?)
			<selectKey property="EmployeeID" resultClass="int" type="post">
				SELECT @@IDENTITY AS value
			</selectKey>
		</insert>
		<insert id="Employee_InsertWithParameterMap3" parameterMap="Employee_InsertParameterMap2" >
			INSERT INTO Employees(LastName,FirstName)  VALUES(?,?)
			<selectKey property="EmployeeID" resultClass="int" type="post">
				SELECT @@IDENTITY AS value
			</selectKey>
		</insert>
		<procedure id="Employee_InsertWithProcedure" parameterMap="Employee_InsertParameterMap2" resultClass="int">
			InsertEmployee
		</procedure>
	</statements>
	
	<parameterMaps>
		<parameterMap class="Employee" id="Employee_SelectParameterMap">
			<parameter property="EmployeeID" dbType="int" type="int" direction="Input"/>
			<parameter property="LastName" dbType="nvarchar" type="string" direction="Input"/>
			<parameter property="Country" dbType="nvarchar" type="string" direction="Input"/>
		</parameterMap>
		
		<parameterMap class="Employee" id="Employee_InsertParameterMap1">
			<parameter column="LastName" property="LastName" dbType="nvarchar" type="string" direction="Input"/>
			<parameter column="FirstName" property="FirstName" dbType="nvarchar" type="string" direction="Input"/>
		</parameterMap>

		<parameterMap class="Employee" id="Employee_InsertParameterMap2" >
			<parameter column="@FirstName" property="FirstName" dbType="nvarchar" type="string" direction="Input"/>
			
		</parameterMap>
	</parameterMaps>
</sqlMap>