//Mapper層
    public int updateFlagByEmployeeID(@Param("ids") List<String> ids);
//XML文件中
    <update id="updateFlagByEmployeeID">
        update OA_JDY_Personnel_Info_Test set enableFlag = 1
        where employeeID in
        <foreach collection="ids" separator="," item="employeeID" open="(" close=")">
            #{employeeID}
        </foreach>
    </update>

?
    public String enableFlagUpdate(String filename) {
        //獲取 PersonSynData 類的 Class 對(duì)象。
        Class<PersonSynData> head = PersonSynData.class;
        List<PersonSynData> updateList = new ArrayList<>();
        ExcelReader excelReader = EasyExcel.read(filename, head, new AnalysisEventListener<PersonSynData>() {
            @Override
            public void invoke(PersonSynData personSynData, AnalysisContext analysisContext) {
                updateList.add(personSynData);
            }
            @Override
            public void doAfterAllAnalysed(AnalysisContext analysisContext) {
                System.out.println("Excel解析完成......");
            }
        }).build();
        //創(chuàng)建 sheet 對(duì)象,并且讀取Excel的第一個(gè)sheet(下表從0開始),也可以根據(jù) sheet 名稱獲取
        ReadSheet readSheet = EasyExcel.readSheet(0).build();
        //讀取 sheet 表格數(shù)據(jù),參數(shù)是可變參數(shù),也可以讀取多個(gè)sheet
        //這個(gè)操作會(huì)讀取 excel 表格的數(shù)據(jù)
        excelReader.read(readSheet);
        //需要自己關(guān)閉流操作,在讀取文件的時(shí)候會(huì)創(chuàng)建臨時(shí)文件,如果不關(guān)閉的話,會(huì)損耗磁盤
        excelReader.finish();
        String success = "";
        //創(chuàng)建更新集合
        List<String> employeeIDs = new ArrayList<>();
        for(int i = 0; i < updateList.size(); i++){
            //這里可以拿到表格內(nèi)的所有數(shù)據(jù),根據(jù)表格中的員工號(hào),批量修改Flag
            String employeeID = updateList.get(i).getEmployeeID();
            employeeIDs.add(employeeID);
        }
        int totalUpdatedCount = 0;
        for (int i = 0; i < employeeIDs.size(); i += BATCH_SIZE) {
            List<String> batchIds = employeeIDs.subList(i, Math.min(i + BATCH_SIZE, employeeIDs.size()));
            int updatedCount = jdcloudDao.updateFlagByEmployeeID(batchIds);
            totalUpdatedCount += updatedCount;
        }
        //進(jìn)行批量更新 每次只更新 2008條
        //int count = jdcloudDao.updateFlagByEmployeeID(employeeIDs);
        return "更新成功的條數(shù)：" + totalUpdatedCount + "<br>";
    }
?