上传excel文件 并获取其信息（使用file上传组件） .

web.xml

[plain] view plain copy print ?

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <web-appversion="3.0"xmlns="http://java.sun.com/xml/ns/javaee"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4. xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
5. http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
7. <display-name>upload</display-name>
9. <context-param>
10. <param-name>uploadRootKey</param-name>
11. <param-value>unicomEOMS.root</param-value>
12. </context-param>
14. <servlet>
15. <servlet-name>upload</servlet-name>
16. <servlet-class>com.test.Upload</servlet-class>
17. </servlet>
19. <servlet-mapping>
20. <servlet-name>upload</servlet-name>
21. <url-pattern>/upload/upload</url-pattern>
22. </servlet-mapping>
24. <servlet>
25. <servlet-name>ReadExcelDemo</servlet-name>
26. <servlet-class>com.test.ReadExcelDemo</servlet-class>
27. </servlet>
29. <servlet-mapping>
30. <servlet-name>ReadExcelDemo</servlet-name>
31. <url-pattern>/ReadExcelDemo/ReadExcelDemo</url-pattern>
32. </servlet-mapping>
34. <welcome-file-list>
35. <welcome-file>index.jsp</welcome-file>
36. </welcome-file-list>
37. </web-app>

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
	
	<display-name>upload</display-name>
	
	<context-param>
    	<param-name>uploadRootKey</param-name>
		<param-value>unicomEOMS.root</param-value>  
	</context-param>
	
	<servlet>
		<servlet-name>upload</servlet-name>
		<servlet-class>com.test.Upload</servlet-class>
	</servlet>
	
	<servlet-mapping>
		<servlet-name>upload</servlet-name>
		<url-pattern>/upload/upload</url-pattern>
	</servlet-mapping>
	
	<servlet>
		<servlet-name>ReadExcelDemo</servlet-name>
		<servlet-class>com.test.ReadExcelDemo</servlet-class>
	</servlet>
	
	<servlet-mapping>
		<servlet-name>ReadExcelDemo</servlet-name>
		<url-pattern>/ReadExcelDemo/ReadExcelDemo</url-pattern>
	</servlet-mapping>
	
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

java代码

[plain] view plain copy print ?

1. packagecom.test;
3. importjava.io.IOException;
4. importjava.io.InputStream;
5. importjava.util.List;
7. importjavax.servlet.ServletException;
8. importjavax.servlet.http.HttpServlet;
9. importjavax.servlet.http.HttpServletRequest;
10. importjavax.servlet.http.HttpServletResponse;
12. importjxl.Cell;
13. importjxl.Sheet;
14. importjxl.Workbook;
15. importjxl.read.biff.BiffException;
17. importorg.apache.commons.fileupload.FileItem;
18. importorg.apache.commons.fileupload.FileUploadException;
19. importorg.apache.commons.fileupload.disk.DiskFileItemFactory;
20. importorg.apache.commons.fileupload.servlet.ServletFileUpload;
22. publicclassUploadextendsHttpServlet{
24. privatestaticfinallongserialVersionUID=6777945010008132796L;
26. //@Override
27. //protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{
28. //super.doGet(req,resp);
29. //System.out.println("doGet");
30. //resp.sendRedirect("/upload/index.jsp");
31. //}
32. //
33. @Override
34. protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{
36. System.out.println("-----------upload-----------");
38. InputStreamis=null;
39. Workbookworkbook=null;
41. try{
42. List<FileItem>items=newServletFileUpload(newDiskFileItemFactory()).parseRequest(req);
43. System.out.println("itemssizeis:"+items.size());
44. for(FileItemitem:items){
45. if(item.isFormField()){
46. System.out.println(item.getFieldName());
47. System.out.println(item.getString());
48. }else{
49. System.out.println(item.getFieldName());
50. is=item.getInputStream();
51. workbook=Workbook.getWorkbook(is);
52. }
53. }
54. }catch(FileUploadExceptione){
55. e.printStackTrace();
56. }catch(BiffExceptione){
57. e.printStackTrace();
58. }
61. Sheet[]sheetNum=workbook.getSheets();
62. System.out.println("打印sheet的個數："+sheetNum.length);
63. Sheetsheet=workbook.getSheet(0);
64. Cellcell=null;
66. intcolumnCount=sheet.getColumns();
67. introwCount=sheet.getRows();
68. for(inti=0;i<rowCount;i++){
69. for(intj=0;j<columnCount;j++){
70. cell=sheet.getCell(j,i);
71. System.out.print(cell.getContents());
72. }
73. System.out.println("\n");
74. }
75. resp.sendRedirect("/importexcel/index.jsp");
76. workbook.close();
77. }
78. }

package com.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

public class Upload extends HttpServlet {

	private static final long serialVersionUID = 6777945010008132796L;

//	@Override
//	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//		super.doGet(req, resp);
//		System.out.println("doGet");
//		resp.sendRedirect("/upload/index.jsp");
//	}
//	
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		
		System.out.println("----------- upload -----------");
		
		InputStream is = null;
		Workbook workbook = null;
		
		try {
			List<FileItem> items = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(req);
			System.out.println("items size is :"+items.size());
			for (FileItem item : items) {
				if (item.isFormField()) {
					System.out.println(item.getFieldName());
					System.out.println(item.getString());
				} else {
					System.out.println(item.getFieldName());
					is = item.getInputStream();
					workbook = Workbook.getWorkbook(is);
				}
			}
		} catch (FileUploadException e) {
			e.printStackTrace();
		} catch (BiffException e) {
			e.printStackTrace();
		}
		
		
		Sheet[] sheetNum = workbook.getSheets();
	       System.out.println("打印sheet的個數："+sheetNum.length);
	       Sheet sheet = workbook.getSheet(0);
	       Cell cell = null;

	       int columnCount = sheet.getColumns();
	       int rowCount = sheet.getRows();
	       for (int i = 0; i < rowCount; i++) {
	           for (int j = 0; j < columnCount; j++) {
	              cell = sheet.getCell(j, i);
	              System.out.print(cell.getContents());
	           }
	           System.out.println(" \n");
	       }
	       resp.sendRedirect("/importexcel/index.jsp");   
	       workbook.close();
	}
}

jsp代码

[javascript] view plain copy print ?

1. <%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
2. <%
3. Stringpath=request.getContextPath();
4. StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()
5. +path+"/";
6. %>
8. <!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
9. <html>
10. <head>
11. <basehref="<%=basePath%>">
13. <title>MyJSP'index.jsp'startingpage</title>
14. <metahttp-equiv="pragma"content="no-cache">
15. <metahttp-equiv="cache-control"content="no-cache">
16. <metahttp-equiv="expires"content="0">
17. <metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">
18. <metahttp-equiv="description"content="Thisismypage">
19. </head>
21. <body>
23. <formaction="upload/upload"enctype="multipart/form-data"method="post">
24. <inputtype="file"name="myfile"/>
25. <inputtype="submit"/>
26. </form>
28. </body>
29. </html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>

<body>

<form action="upload/upload" enctype="multipart/form-data" method="post">
	<input type="file" name="myfile" />
	<input type="submit" />
</form>
	
</body>
</html>