在mybatis里面写plsql即可
<insert id="insertSpecialKeyword" parameterType="map">
begin
delete from STOCK_LIVE_SPECIAL_KEYWORD where special_id=#{map.specialId};
<foreach collection="map.list" item="emp" separator=";">
insert into STOCK_LIVE_SPECIAL_KEYWORD(special_id,keyword)VALUES(#{map.specialId},#{emp})
</foreach>
;end;
</insert>
注意:
数据库有时会限制执行多条sql:
在连接url后加上&allowMultiQueries=true
即可