文件上传下载笔记 以及ex表格生成

文件上传

前端：

1、有文件上传的输入框

2、form 表单请求方式必须是post

3、form表单的enctype = “multipart/form-data”

后端

1、需要文件上传的jar包、

pom 导入commons Fileupload

2、接收文件的类型必须是MultipartFile

3、配置Mutipart解析器

<!--Multipart解析器-->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>

upload.transferTo(new File(filepath, filename));//保存到文件

FileUtils.copyFile(new File(filepath, filename), new File(filepath2, filename));//文件拷贝

Excel 表格生成，以及返回流文件下载

		//创建excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
        //创建sheet
        HSSFSheet sheet = wb.createSheet(sheetname);
        //创建首行
        HSSFRow row = sheet.createRow(0);
        //首行创建单元格
        HSSFCell cell = row.createCell(0);
        //合并单元格
        sheet.addMergedRegion(new CellRangeAddress(0,0,0,1));
        //给单元格赋值
        cell.setCellValue(titlename);
        HSSFRow rows = sheet.createRow(1);
        for (int i = 0; i < 2; i++) {
            System.out.println(coumnname[i]);
            rows.createCell(i).setCellValue(coumnname[i]);
        }
        for (int i = 0; i < productList.size() ; i++) {
            rows = sheet.createRow(i+2);
            rows.createCell(0).setCellValue(productList.get(i).getName());
            rows.createCell(1).setCellValue(productList.get(i).getSalnum());
        }
        response.setContentType("application/ms-excel;charset=UTF-8");
        response.setHeader("content-Disposition","attachment;filename="+filename);
        OutputStream outputStream = response.getOutputStream();
        wb.write(outputStream);