mybatis使用注解的方式实现批量增加

文章目录

注：在学习的过程中记录

• @Insert实现
• @InsetProvider实现
• 通用mapper实现（注：主键为自增）

实体类pojo

@Data
@Table(name = "easy_excel")
public class DemoData {
    @Id
    private String name;
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date time;
    private Integer number;
}

一、@Insert实现的方式

mapper类

public interface DemoMapper {
    @Insert({"<script>insert into easy_excel values " +
            "<foreach collection='list' item='record' separator=','>" +
           "(#{record.name},#{record.time},#{record.number})"+
            "</foreach>" +
            "</script>"})
    void insertDemo(@Param("list") List<DemoData> list);
}

二、@InsertProvider

自定义sql语句的方式实现批量增加

mapper类

说明：type指明SQL工厂类，method是工厂类里对应的方法

public interface DemoMapper {
    @InsertProvider(type = UserDaoProvider.class,method = "insertMysqlObject")
    void insertDemo(@Param("list") List<DemoData> list);
}

 UserDaoProvider类

public class UserDaoProvider {
    List<DemoData> demoDataList = (List<DemoData>) map.get("list");
        StringBuilder sb = new StringBuilder();
        sb.append("INSERT INTO easy_excel ");
        sb.append("(name, time, number) ");
        sb.append("VALUES ");
        MessageFormat mf = new MessageFormat("(#'{'list[{0}].name},#'{'list[{0}].time},#'{'list[{0}].number})");
        for (int i = 0; i < demoDataList.size(); i++) {
            sb.append(mf.format(new Object[]{i}));
            if (i < demoDataList.size() - 1) {
                sb.append(",");
            }
        }
        return sb.toString();
    }
}

 三、通用Mapper批量增加

注意：使用这个方法必须主键是自增的，主键不支持加入

mapper类

注：mapper接口要继承MySqlMapper接口

public interface DemoMapper extends Mapper<DemoData>, MySqlMapper<DemoData> {

}

pojo类

@Data
@AllArgsConstructor
@Table(name = "easy_excel")
public class DemoData {
    @Id
    private Integer id;

    private String name;
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")

    private Date time;

    private Integer number;
}

测试类

@Test
public void testTime() {
    List<DemoData> demoData = new ArrayList<>();
    DemoData pojo1= new DemoData(null,"user1", new Date(), 1);
    DemoData pojo2= new DemoData(null,"user2", new Date(), 1);
    demoData.add(pojo1);
    demoData.add(pojo2);
    demoMapper.insertList(demoData);
}