mybatis selectKey

<insert id="saveBaseMeterInfo" parameterType="com.aneng.order.model.PcMeter">
<selectKey keyProperty="meterid" resultType="Long" order="AFTER">
select S_pc_meter.CURRVAL as meterid from dual
</selectKey>
insert into pc_meter(meterid,metertime,starttime,endtime,orderid,createuserid) values
(#{meterid,jdbcType=DECIMAL},
#{metertime,jdbcType=TIMESTAMP},
#{starttime,jdbcType=TIMESTAMP},
#{endtime,jdbcType=TIMESTAMP},
#{orderid,jdbcType=DECIMAL},#{createuserid,jdbcType=DECIMAL})
</insert>

<insert id="insertBatch" useGeneratedKeys="false">
insert ALL
<foreach collection="list" item="item" index="index" >
into PC_SETTLEINCOME_COSTTYPE
(
gridsettleid,
type,
typename,
el,
price,
amount,
remark,
createuserid
)values
(
#{item.gridsettleid},
#{item.type,jdbcType=INTEGER},
#{item.typename,jdbcType=VARCHAR},
#{item.el,jdbcType=DECIMAL},
#{item.price,jdbcType=DECIMAL},
#{item.amount,jdbcType=DECIMAL},
#{item.remark,jdbcType=VARCHAR},
#{item.createuserid,jdbcType=INTEGER}
)
</foreach>
SELECT 1 FROM DUAL
</insert>

原文地址:https://www.cnblogs.com/newlangwen/p/12263649.html