博客

首先给表tb_baby插入100个数据，打桩测试

Babymapper接口：int insertBaby(@Param(“list”) List babies);

配置文件xml:

<insert id="insertBaby">
        insert into
            tb_baby(name,nickName,gender)
        value
            <foreach collection="list" open="(" separator="),(" close=")" item="item">
                #{item.name},#{item.nickName},#{item.gender}
            </foreach>
    </insert>

service代码：

 public int insertList(List<Baby> list){
    ss = MybatisUtil.openSession();
    BabyMapper mapper =ss.getMapper(BabyMapper.class);
    return mapper.insertBaby(list);
  }

main里面运行：

public class Main {
    public static void main(String[] args) {
    BabyService service = new BabyService();
        List<Baby> list = new ArrayList<Baby>();
        for (int i = 0;i<100;i++){
            Baby b = new Baby();
            b.setName("baby"+i);
            b.setNickName("laoBaby"+i);
            b.setGender("男");
            list.add(b);