Cacher is the code snippet organizer for pro developers

#插入后获取主键：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();
}