今天学习做项目用到了Mybatis的批量添加功能,并且向传入多个参数,包括数组
dao层方法如下
void insertByArr(@Param("actorid") int actorid, @Param("garry") String[] group, @Param("narry") String[] node);
xml映射文件如下
<insert id="insertByArr" useGeneratedKeys="true">
insert into role_menu (roleid,menuid)values
<if test="garry != null">
<foreach collection="garry" item="item"
index="index" separator=",">
(#{actorid},#{item})
</foreach>
</if>
<if test="garry !=null and narry != null">
,
</if>
<if test="narry != null">
<foreach collection="narry" item="item"
index="index" separator=",">
(#{actorid},#{item})
</foreach>
</if>
</insert>
运行OK!