在mapper.xml的<insert>标签里插入语句里面添加:
<selectKey resultType="java.math.BigDecimal" order="AFTER" keyProperty="id">
SELECT ARCHIVES_GROUP.CURRVAL as ID from DUAL
</selectKey>
或者
<selectKey resultType="java.math.BigDecimal" order="BEFORE" keyProperty="id">
SELECT ARCHIVES_GROUP.Nextval as ID from DUAL
</selectKey>
//ARCHIVES_GROUP是序列
severice层获取返回的主键
TBaseArchivesGroup archg = new TBaseArchivesGroup();
archg.setGroupname(groupName);
archg.setStatus(new BigDecimal(1));
archg.setUptime(new Date());
groupMapper.insertReturnId(archg);
//插入数据后返回主键
BigDecimal groupid = archg.getId();
Oracled主键的自增长实现:创建表后,先创建序列号,然后创建触发器;sql在插入数据之前会触发触发器,获取一个值作为这个将要插入的数据的ID。