iBatis update

一、修改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="org.lam.ibatis.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="org.lam.ibatis.model.Employee">
		update Employee set name = #name# where id = #id#
	</update>

</sqlMap>

二、java测试程序

public static void main(String[] args) throws IOException, SQLException{
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		
		
		//update--------------------------------------------------
		
		System.out.println("ready to update...");
        Employee em = new Employee();
        em.setId(1);
        em.setName("new name");
        sqlMapClient.update("Employee.update#name", em);
        
        List<Employee> employees = sqlMapClient.queryForList("Employee.select*",Employee.class);
        
        System.out.println("finish update...");
}