iBatis insert

来源：互联网发布：知羽电子相册模板30套编辑：程序博客网时间：2024/05/08 16:02

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

0 0