一、创建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...");
}