POI使用

最新推荐文章于 2024-07-15 11:41:32 发布

ETLshow

最新推荐文章于 2024-07-15 11:41:32 发布

阅读量391

点赞数

分类专栏：实践杂记

本文链接：https://blog.csdn.net/idea_boy/article/details/58687351

版权

实践杂记专栏收录该内容

12 篇文章 0 订阅

订阅专栏

            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi</artifactId>
                <version>3.14</version>
            </dependency>

/**
     * 工作单批量导入
     * @return
     */
    private File upload;
    public void setUpload(File upload) {
        this.upload = upload;
    }
    public String batchImport() throws IOException{
        //使用POI读取xml文件
        String flag="success";
        try {
            HSSFWorkbook wb=new HSSFWorkbook(new FileInputStream(upload));
            //读取sheet
            HSSFSheet sheet = wb.getSheetAt(0);
            List<Workordermanage>list=new ArrayList<Workordermanage>();//keep
            //读取行，有多行，需要循环
            int i=0;
            for(Row row:sheet){
                if(i==0){
                    i++;
                    continue;
                }
                for(i=0;i<18;i++){
                    if(row.getCell(i)!=null){
                        row.getCell(i).setCellType(Cell.CELL_TYPE_STRING);
                    }
                }
                //读取每列数据
                String id = row.getCell(0).getStringCellValue();
                String arrivecity = row.getCell(1).getStringCellValue();
                String product = row.getCell(2).getStringCellValue();
                Integer num = Integer.parseInt(row.getCell(3).getStringCellValue());
                Double weight = Double.parseDouble(row.getCell(4).getStringCellValue());
                String floadreqr = row.getCell(5).getStringCellValue();
                String prodtimelimit = row.getCell(6).getStringCellValue();
                String prodtype = row.getCell(7).getStringCellValue();
                String sendername = row.getCell(8).getStringCellValue();
                String senderphone = row.getCell(9).getStringCellValue();
                String senderaddr = row.getCell(10).getStringCellValue();
                String receivername = row.getCell(11).getStringCellValue();
                String receiverphone = row.getCell(12).getStringCellValue();
                String receiveraddr = row.getCell(13).getStringCellValue();
                Integer feeitemnum = Integer.parseInt(row.getCell(14).getStringCellValue());
                Double actlweit = Double.parseDouble(row.getCell(15).getStringCellValue());
                String vol = row.getCell(16).getStringCellValue();
                String managerCheck = row.getCell(17).getStringCellValue();
                Date updatetime = row.getCell(18).getDateCellValue();
                Workordermanage workordermanage=new Workordermanage(id, arrivecity, product, num, weight, 
                        floadreqr, prodtimelimit, prodtype, sendername, senderphone, senderaddr, receivername, 
                        receiverphone, receiveraddr, feeitemnum, actlweit, vol, managerCheck, updatetime);
                list.add(workordermanage);
                workordermanageService.save(list);
            }
        }catch(Exception e){
            flag="导入失败";
            e.printStackTrace();
        }
        ServletActionContext.getResponse().setContentType("text/html;charset=utf-8");
        ServletActionContext.getResponse().getWriter().print(flag);
        return NONE;
    }

    /**
     * 导入工作单
     */
    @Override
    public void save(List<Workordermanage> list) {
        for(Workordermanage workordermanage:list){
            workordermanageDao.saveOrUpdate(workordermanage);
        }
    }