ssm框架实现mybatis循环插入

1.创建数据库表

2.创建实体类

public class RolePermission implements Serializable {
    private Long id;

    private Long roleId;

    private Long permissionId;

    private String createTime;

    private String updateTime;

    private Long createBy;

    private Long updateBy;

    private Byte status;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Long getRoleId() {
        return roleId;
    }

    public void setRoleId(Long roleId) {
        this.roleId = roleId;
    }

    public Long getPermissionId() {
        return permissionId;
    }

    public void setPermissionId(Long permissionId) {
        this.permissionId = permissionId;
    }

    public String getCreateTime() {
        return createTime;
    }

    public void setCreateTime(String createTime) {
        this.createTime = createTime == null ? null : createTime.trim();
    }

    public String getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(String updateTime) {
        this.updateTime = updateTime == null ? null : updateTime.trim();
    }

    public Long getCreateBy() {
        return createBy;
    }

    public void setCreateBy(Long createBy) {
        this.createBy = createBy;
    }

    public Long getUpdateBy() {
        return updateBy;
    }

    public void setUpdateBy(Long updateBy) {
        this.updateBy = updateBy;
    }

    public Byte getStatus() {
        return status;
    }

    public void setStatus(Byte status) {
        this.status = status;
    }
}

3.创建mapper文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hisum.permission.dao.RolePermissionDao">
  <resultMap id="BaseResultMap" type="RolePermission">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="role_id" jdbcType="BIGINT" property="roleId" />
    <result column="permission_id" jdbcType="BIGINT" property="permissionId" />
    <result column="create_time" jdbcType="VARCHAR" property="createTime" />
    <result column="update_time" jdbcType="VARCHAR" property="updateTime" />
    <result column="create_by" jdbcType="BIGINT" property="createBy" />
    <result column="update_by" jdbcType="BIGINT" property="updateBy" />
    <result column="status" jdbcType="TINYINT" property="status" />
  </resultMap>
  <insert id="insertByBatch" parameterType="java.util.List">
    insert into pms_role_permission (role_id, permission_id,
    create_time, update_time, create_by,
    update_by, status)
    values
    <foreach collection="list" item="item" index="index" separator=",">
      (#{item.roleId,jdbcType=BIGINT}, #{item.permissionId,jdbcType=BIGINT},
      #{item.createTime,jdbcType=VARCHAR}, #{item.updateTime,jdbcType=VARCHAR}, #{item.createBy,jdbcType=BIGINT},
      #{item.updateBy,jdbcType=BIGINT}, #{item.status,jdbcType=TINYINT})
    </foreach>
  </insert>
</mapper>

4.创建DAO文件

public interface RolePermissionDao {
    void insertByBatch(List<RolePermission> record);
}

5.创建service接口

@Component
@Service
public class RolePermissionServiceImpl implements RolePermissionService {


    @Autowired
    private RolePermissionDao rolePermissionDao;


    @Override
    @Transactional
    public void insertByBatch(List<RolePermission> record) {
        this.rolePermissionDao.insertByBatch(record);
    }
}

6.创建service实现类

public interface RolePermissionService {


    /**
     * 批量插入
     * */
    void insertByBatch(List<RolePermission> record);
}

完成！