您好,登錄后才能下訂單哦!
最近工作遇到一個(gè)需求,需要下載excel模板,編輯后上傳解析存儲(chǔ)到數(shù)據(jù)庫(kù)。因此為了更好的理解公司框架,我就自己先用spring mvc實(shí)現(xiàn)了一個(gè)樣例。
基礎(chǔ)框架
之前曾經(jīng)介紹過(guò)一個(gè)最簡(jiǎn)單的spring mvc的項(xiàng)目如何搭建,傳送門在這里。
這次就基于這個(gè)工程,繼續(xù)實(shí)現(xiàn)上傳下載的小例子。需要做下面的事情:
1 增加index.html,添加form提交文件
2 引入commons-fileupload、commons-io、jxl等工具包
3 創(chuàng)建upload download接口
4 注入multipartResolver bean
5 在upload中使用HttpServletRequest獲取文件流,通過(guò)WorkBook進(jìn)行解析
6 在download中通過(guò)HttpServerResponse返回文件流,實(shí)現(xiàn)下載
頁(yè)面
頁(yè)面很簡(jiǎn)單,其實(shí)就是一個(gè)form標(biāo)簽,需要注意的是:
<form role="form" action="/upload" method="POST" enctype="multipart/form-data"> <div class="form-group"> <label for="file">上傳文件</label> <input type="file" id="file" name="file"> </div> <button type="submit" class="btn btn-default">提交</button> </form>
引入commons-fileupload、jxl等工具包
涉及的jar包有:
<!-- springframework begins --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.2.4.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.2.4.RELEASE</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>4.0.0-b01</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-io/commons-io --> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.5</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload --> <dependency> <groupId>commons-fileupload</groupId> <artifactId>commons-fileupload</artifactId> <version>1.3.2</version> </dependency> <!-- https://mvnrepository.com/artifact/jexcelapi/jxl --> <dependency> <groupId>jexcelapi</groupId> <artifactId>jxl</artifactId> <version>2.6</version> </dependency>
Xml的配置
在web.xml中需要配置默認(rèn)的訪問(wèn)頁(yè)面,因?yàn)橹耙呀?jīng)設(shè)置過(guò)攔截的請(qǐng)求是/,因此如果不設(shè)置所有的靜態(tài)頁(yè)面都會(huì)被攔截下來(lái)。
<welcome-file-list> <welcome-file>index.html</welcome-file> </welcome-file-list>
在spring的配置文件中,加入CommonsMultipartResolver的bean。
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <!-- set the max upload size100MB --> <property name="maxUploadSize"> <value>104857600</value> </property> <property name="maxInMemorySize"> <value>4096</value> </property> </bean>
上傳代碼
@RequestMapping("upload") public void upload(HttpServletRequest request, HttpServletResponse response) throws IOException, BiffException, WriteException { MultipartHttpServletRequest mRequest = (MultipartHttpServletRequest) request; MultipartFile file = mRequest.getFile("file"); Workbook workbook = Workbook.getWorkbook(file.getInputStream()); //遍歷Sheet頁(yè) Arrays.stream(workbook.getSheets()) .forEach(sheet -> { int size = sheet.getRows(); for(int i=0; i<size; i++){ //遍歷每一行,讀取每列信息 Arrays.stream(sheet.getRow(i)).forEach(cell -> System.out.println(cell.getContents().equals("")?'空':cell.getContents())); } }); response.setHeader("Content-Disposition", "attachment; filename=return.xls"); WritableWorkbook writableWorkbook = ExcelUtils.createTemplate(response.getOutputStream()); writableWorkbook.write(); writableWorkbook.close(); }
下載代碼
@RequestMapping("download") public void download(HttpServletRequest request, HttpServletResponse response) throws IOException, BiffException, WriteException { response.setHeader("Content-Disposition", "attachment; filename=template.xls"); WritableWorkbook writableWorkbook = ExcelUtils.createTemplate(response.getOutputStream()); writableWorkbook.write(); writableWorkbook.close(); }
模板類
static class ExcelUtils { public static WritableWorkbook createTemplate(OutputStream output) throws IOException, WriteException { WritableWorkbook writableWorkbook= Workbook.createWorkbook(output); WritableSheet wsheet = writableWorkbook.createSheet("測(cè)試title", 0); CellFormat cf = writableWorkbook.getSheet(0).getCell(1, 0).getCellFormat(); WritableCellFormat wc = new WritableCellFormat(); // 設(shè)置居中 wc.setAlignment(Alignment.CENTRE); // 設(shè)置邊框線 // wc.setBorder(Border.ALL, BorderLineStyle.THIN); wc.setBackground(jxl.format.Colour.GREEN); Label nc0 = new Label(0, 0, "標(biāo)題1",wc);//Label(x,y,z)其中x代表單元格的第x+1列,第y+1行, 單元格的內(nèi)容是z Label nc1 = new Label(1, 0, "標(biāo)題2",wc); Label nc2 = new Label(2, 0, "標(biāo)題3",wc); Label nc3 = new Label(0, 1, "dddd"); Label nc4 = new Label(1, 1, "ffff"); wsheet.addCell(nc0); wsheet.addCell(nc1); wsheet.addCell(nc2); wsheet.addCell(nc3); wsheet.addCell(nc4); return writableWorkbook; } }
最后貢獻(xiàn)下相關(guān)的代碼:SpringTest_jb51.rar
以上就是本文的全部?jī)?nèi)容,希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持億速云。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。