iBatis insert

一、创建Employee POJO类

public class Employee {
	private Integer id;
	private String name;
	private Integer gender;
	private Integer salary;
	
	public Employee() {}
	
	public Employee(String name,Integer gender,Integer salary){
		this.name = name;
		this.gender = gender;
		this.salary = salary;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getGender() {
		return gender;
	}

	public void setGender(Integer gender) {
		this.gender = gender;
	}

	public Integer getSalary() {
		return salary;
	}

	public void setSalary(Integer salary) {
		this.salary = salary;
	}
	
	
	
}

二、修改 Employee.xml文件

在Employee.xml文件中，我们用<insert>标签，这样ibatis执行时就会帮我们执行SQL的insert操作了，其中employee表的主键id是auto increment的，我们可以使用<selectKey>标签生成id。

<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>
</sqlMap>

三、java测试程序

public static void main(String[] args) throws IOException, SQLException{
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		
		
		//insert--------------------------------------------------
		
		System.out.println("ready to insert...");
		
		Employee em = new Employee("weken1",1,7000);
		sqlMapClient.insert("Employee.insert",em);
		
		System.out.println("finish insert...");
}