工作中经常用到批量保存,保存此处当做笔记查看
/**
* 新增角色 - 菜单 关联
* @param roleRMenus
*/
@Insert("<script> " +
"INSERT INTO h_r_role_menu " +
"(role_id,menu_id) " +
"VALUES " +
"<foreach collection='roleRMenus' index='index' item='roleRMenu' separator=','>" +
"(#{roleRMenu.roleId},#{roleRMenu.menuId})" +
"</foreach>"+
"</script>")
void addRoleMenus(@Param("roleRMenus") List<RoleRMenu> roleRMenus);
最终到mysql执行效果的sql:
INSERT INTO h_r_role_menu (role_id,menu_id) VALUES (1,1),(2,2),(3,3)...