mybatis批量操作数据

比眉伴天荒 2023-07-03 14:30 44阅读 0赞

pom引入依赖

<dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.1.1</version>
    </dependency>
    
    <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.4</version>
    </dependency>

<build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
    
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                </plugin>
            </plugins>
        </build>

启动类添加mapper扫描

@MapperScan("com.example.demo.mapper")

mapper

@Repository
    public interface vodMapper {
    
        int inserlist(List<vod>lists);
    
        int deleteList(int[] arrs);
    
        int updateList(List<vod> lists);
    }

数据库连接配置要加上allowMultiQueries=true，不然不能批量修改

spring.datasource.url=jdbc:mysql://localhost:3306/itv_basic_v022?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true

mappers.xml

<insert id="inserlist" parameterType="java.util.List" useGeneratedKeys="false" >
        insert into con_vod ( cp_id, con_name,
        first_letter, nike_name, clazz_flag,
        update_time, opt_staff_id, statuz,
        rtsp_bd, rtsp_hd, size,
        busi_type, time_long)
        values
        <foreach collection="list" item="item" index="index" separator=",">
          (
          #{item.cpId},
          #{item.conName},
          #{item.firstLetter},
          #{item.nikeName},
          #{item.clazzFlag},
          #{item.updateTime},
          #{item.optStaffId},
          #{item.statuz},
          #{item.rtspBd},
          #{item.rtspHd},
          #{item.size},
          #{item.busiType},
          #{item.timeLong}
          )
        </foreach>
      </insert>
     
      <delete id="deleteList" parameterType="int[]">
        delete from con_vod where con_id in
        <foreach collection="array" item="arr" index="no" open="("
                 separator="," close=")">
          #{arr}
        </foreach>
      </delete>
      
      <update id="updateList" parameterType="java.util.List">
        <foreach collection="list" item="item" index="index" open="" close="" separator=";">
          update con_vod
          <set>
            con_name=#{item.conName}
          </set>
          where con_id = #{item.conId}
        </foreach>
      </update>

service

@Service
    public interface vodService {
        public int addlist(List<vod> list);
    
      int deleteList(int[] arrs);
    
        int updateList(List<vod> lists);
    
    }

serviceImpl

@Component
    public class vodServiceImpl implements vodService{
    @Autowired
        vodMapper vodMapper;
    
        public int addlist(List<vod> list) {
      return   vodMapper.inserlist(list);
        }
    
      public  int deleteList(int[] arrs){
            return vodMapper.deleteList(arrs);
        }
    
        public int updateList(List<vod> lists){
    
            return  vodMapper.updateList(lists);
        }
    }

controller

@Controller
    public class vodController {
        @Autowired
      vodService vodService;
    
        @GetMapping("/addvod")
        @ResponseBody
        public void addvod(){
            List<vod> list=new ArrayList<>();
            vod vod=new vod(22l,"woshi","saf","23","22","199723-2",22l,"1","http12382034","httwaaskds",1232,"13823748");
            vod vod1=new vod(22l,"woshi","saf","23","22","199723-2",22l,"1","http12382034","httwaaskds",1232,"13823748");
            list.add(vod);
            list.add(vod1);
            System.out.println(vodService.addlist(list));
        }
    
    
    //批量删除
        @GetMapping("/deletevod")
        @ResponseBody
        public void deleteList()
        {int[] arrs={11124,11125};
        System.out.println( vodService.deleteList(arrs));
        }
    
        //批量更新
        @GetMapping("/updatevod")
        @ResponseBody
        public void updateList()
        {  List<vod> list=new ArrayList<>();
            vod vod=new vod(11126l,22l,"abcd","saf","23","22","199723-2",22l,"1","http12382034","httwaaskds",1232,"13823748","232");
            vod vod1=new vod(11127l,22l,"abcdes","saf","23","22","199723-2",22l,"1","http12382034","httwaaskds",1232,"13823748","232");
            list.add(vod);
            list.add(vod1);
            System.out.println( vodService.updateList(list));
        }
    }