MyBitys
1、批量保存
<insert id="Report_insert" parameterType="upc.jxzygl.entity.Security.Risk.RiskReportEntity" >
insert into
Tab(
id,name, type,oilfield,ip
)
select aqsc_seq.nextval,da.* from(
<foreach collection="el" index="" item="item" separator="union all">
select
#{item.name,jdbcType=VARCHAR},
#{item.type,jdbcType=VARCHAR},
#{oilfield,jdbcType=VARCHAR},
#{ip,jdbcType=VARCHAR}
from dual
</foreach>)da
</insert>
2、批量修改
<update id="Report_update" parameterType="upc.jxzygl.entity.Security.Risk.RiskReportEntity" >
<foreach collection="el" item="item" index="index" open="begin" close=";end;" separator=";">
update PC_AQSC_RISK_REPORT
<set>
<if test="item.type!=null and item.type.length() > 0">
type ='${item.type}',
</if>
last_time=sysdate
</set>
where risk_id = #{item.risk_id,jdbcType=INTEGER}
</foreach>
</update>
3、插入并返回id
<insert id="insert1" parameterType="com.dhop.scjh.model.Cc_GroupEntity">
<selectKey keyProperty="group_id" order="BEFORE" resultType="int">
select vehicle_apply_seq.NEXTVAL as group_id from DUAL
</selectKey>
insert into
DHOP_DBA17_PERFORATION_GROUP
(
group_id,event_id,type
)values(
#{group_id},#{event_id,jdbcType=INTEGER},#{type,jdbcType=INTEGER}
)
</insert>