下面就是将主键id自动生成,累加1的实现方法
<selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >
select get_seq_next('Engine_Line_Stock') from dual
</selectKey>
这个需要你建一个名字叫做ENGINE_LINE_STOCK_SEQ的序列
<insert id="insertEngineLineStock" parameterType="cn.evun.srm.psc.mes.model.EngineLineStock" >
<selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >
select get_seq_next('Engine_Line_Stock') from dual
</selectKey>
insert into Engine_Line_Stock
<trim prefix="(" suffix=")" suffixOverrides="," >
ID,
FC_CODE,
MT_CODE,
CURR_STOCK,
UPLOAD_