插入后获取主键:sqlserver
#插入后获取主键:sqlserver
<insert id="insertrecord" parameterType="weaver.monitor.server.bean.Record ">
<selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id">
select @@identity
</selectKey>
INSERT INTO record(customerId,customerName)
VALUES (#{customerId,jdbcType=BIGINT}, #{customerName,jdbcType=VARCHAR})
</insert>
Record record = new record();
int num = repairRecordDao.insertrecord(record);
if(num>0){
int id = record.getId();
}