一、mysql
1、设置主键为自增长,插入的时候可以插入NULL或者直接不插入,即可完成主键的自增长
2、插入完成以后需要获取添加的主键,可以使用select LAST_INSERT_ID() 来获取,使用方式参照:
<insert id="insert" parameterClass="customer">
insert into customer(address,postcode,sex,name) values(#address#,#postcode#,#sex#,#name#)
<selectKey keyProperty="id" resultClass="long">
select LAST_INSERT_ID()
</selectKey>
</insert>
二、oracle
1、通过sequence获取ID再插入
<selectKey resultClass="int" keyProperty="id"> SELECT SEQ_CUSTOM.NEXTVAL AS ID FROM DUAL </selectKey> insert into customer(ID,address,postcode,sex,name) values(#id#,#address#,#postcode#,#sex#,#name#)
其中
public class Customer {
private Long id;
private String name;
private String address;
private String postcode;
private String sex;
}