iBatis select for resultMap

一、修改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">
	
	<insert id="insert" parameterClass="model.Employee">
		
		insert into Employee (name,gender,salary)
		values (#name#,#gender#,#salary#)
		
		<selectKey resultClass="int" keyProperty="id">
			select last_insert_id() as id
		</selectKey>
	</insert>
	
	<select id="select*" resultClass="java.util.HashMap" parameterClass="int">
		select * from Employee where id = #id#
	</select>
	
	<update id="update#name" parameterClass="model.Employee">
		update Employee set name = #name# where id = #id#
	</update>
	
	<delete id="delete" parameterClass="int">
		delete from Employee where id = #id#
	</delete>
	
	<resultMap id="resultMap" class="model.Employee">
		<result property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="gender" column="gender"/>
		<result property="salary" column="salary"/>
	</resultMap>
	<select id="selectForResultMap" resultMap="resultMap" parameterClass="int">
		select id,name,gender,salary from employee where id = #id#
	</select>

</sqlMap>

二、java测试程序

public static void main(String[] args) throws IOException, SQLException{
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		
		//select for resultMap--------------------------------------------------
		
		System.out.println("ready to select for resultMap...");
		
		Employee employee = (Employee) sqlMapClient.queryForObject("Employee.selectForResultMap",1);
		
		System.out.println("finish select for resultMap...");

}