POI使用

            <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);
        }
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值