一、修改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>
</sqlMap>
二、java测试程序
public static void main(String[] args) throws IOException, SQLException{
Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
//delete--------------------------------------------------
System.out.println("ready to delete...");
sqlMapClient.delete("Employee.delete",1);
List<Object> employees = sqlMapClient.queryForList("Employee.select*",2);
System.out.println("finish delete...");
}