关于 jsp servlet 将Excel表格内容写进数据库，将数据库导出到Excel中。（一）

从 EXCEL到数据库，引入poi.jar
jsp如下

点击(此处)折叠或打开

1. <form enctype="multipart/form-data" name=testform method=post action=Testaction>
   
2.   <table>
   
3.     <tr>
   
4.        <td><font size=2>批量上传：</font><input type="file" name="test" size="10"><br></td>
   
5.       <td><input type="submit" name="批量上传" size="10"value="批量上传"><br></td></tr></table><br>
   
6.       </form>

Servlet如下

点击(此处)折叠或打开

1. package control;
   
2. 
   
3. import java.io.File;
   
4. import java.io.FileOutputStream;
   
5. import java.io.IOException;
   
6. import java.io.InputStream;
   
7. import java.io.PrintWriter;
   
8. import java.io.RandomAccessFile;
   
9. 
   
10. import javax.servlet.ServletException;
    
11. import javax.servlet.http.HttpServlet;
    
12. import javax.servlet.http.HttpServletRequest;
    
13. import javax.servlet.http.HttpServletResponse;
    
14. 
    
15. public class Testaction extends HttpServlet {
    
16. 
    
17.     /**
    
18.      *
    
19.      */
    
20.     private static final long serialVersionUID = 1L;
    
21. 
    
22.     public void doGet(HttpServletRequest request, HttpServletResponse response)
    
23.             throws ServletException, IOException {
    
24. 
    
25. 
    
26.     }
    
27. 
    
28.     /**
    
29.      * The doPost method of the servlet. <br>
    
30.      *
    
31.      * This method is called when a form has its tag value method equals to post.
    
32.      *
    
33.      * @param request the request send by the client to the server
    
34.      * @param response the response send by the server to the client
    
35.      * @throws ServletException if an error occurred
    
36.      * @throws IOException if an error occurred
    
37.      */
    
38.     public void doPost(HttpServletRequest request, HttpServletResponse response)
    
39.     throws ServletException, IOException {
    
40.         //接收上传文件内容中临时文件的文件名
    
41.         String tempFileName = new String("tempFileName");
    
42.         //tempfile 对象指向临时文件
    
43.         File tempFile = new File("D:/"+tempFileName);
    
44.         //outputfile 文件输出流指向这个临时文件
    
45.         FileOutputStream outputStream = new FileOutputStream(tempFile);
    
46.         //得到客服端提交的所有数据
    
47.         InputStream fileSourcel = request.getInputStream();
    
48.         //将得到的客服端数据写入临时文件
    
49.         byte b[] = new byte[1000];
    
50.         int n ;
    
51.         while ((n=fileSourcel.read(b))!=