文件上传

最新推荐文章于 2024-09-11 19:30:00 发布

最新推荐文章于 2024-09-11 19:30:00 发布 · 129 阅读

文章标签：

#Java #Servlet #Apache #Oracle #XML

J2EE 专栏收录该内容

26 篇文章

订阅专栏

common-fileupload是jakarta项目组开发的一个功能很强大的上传文件组件
下面先介绍上传文件到服务器（多文件上传）：


package photo;

import java.io.File;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Iterator;

import java.util.List;

import java.util.regex.Matcher;

import java.util.regex.Pattern;



import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



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;

/**

 * 

 * @author zhupan

 *

 */

public class Upload extends HttpServlet {

     /**

      * 

      */

     private static final long serialVersionUID = 1L;



     public void doPost(HttpServletRequest request, HttpServletResponse response)

              throws ServletException, IOException {

         response.setContentType("text/html; charset=GB2312");

         PrintWriter out = response.getWriter();

         try {

              DiskFileItemFactory factory = new DiskFileItemFactory();



              ServletFileUpload sevletFileUpload = new ServletFileUpload(factory);

              // 设置允许用户上传文件大小,单位:字节，这里设为2m

              sevletFileUpload.setSizeMax(2 * 1024 * 1024);

              // 设置最多只允许在内存中存储的数据,单位:字节

              factory.setSizeThreshold(4096);

              // 设置一旦文件大小超过getSizeThreshold()的值时数据存放在硬盘的目录

              factory.setRepository(new File("d:\\temp"));

              // 开始读取上传信息 

              List fileItems = sevletFileUpload.parseRequest(request);

              // 依次处理每个上传的文件

              Iterator iter = fileItems.iterator();



              // 正则匹配，过滤路径取文件名

              String regExp = ".+\\\\(.+)$";



              // 过滤掉的文件类型

              String[] errorType = { ".exe", ".com", ".cgi", ".asp" };

              Pattern p = Pattern.compile(regExp);

              while (iter.hasNext()) {

                   FileItem item = (FileItem) iter.next();

                   // 忽略其他不是文件域的所有表单信息

                   if (!item.isFormField()) {

                       String name = item.getName();

                       long size = item.getSize();

                       if ((name == null || name.equals("")) && size == 0)

                            continue;

                       Matcher m = p.matcher(name);

                       boolean result = m.find();

                       if (result) {

                            for (int temp = 0; temp < errorType.length; temp++) {

                                 if (m.group(1).endsWith(errorType[temp])) {

                                     throw new IOException(name + ": 非法文件类型禁止上传");

                                 }

                            }

                            try {

                                 // 保存上传的文件到指定的目录

                                 // 在下文中上传文件至数据库时，将对这里改写开始

                                 item.write(new File("d:\\uploadfile\\"+ m.group(1)));



                                 out.print(name + "  " + size + "<br>");

                                 // 在下文中上传文件至数据库时，将对这里改写结束

                            } catch (Exception e) {

                                 out.println(e);

                            }



                       } else {

                            throw new IOException("fail to upload");

                       }

                   }

              }

         } catch (IOException e) {

              out.println(e);

         } catch (FileUploadException e) {

              out.println(e);

         }



     }

}

下面是上传页面upload.html：


<h1>

     文件上传演示

</h1>



<form name="uploadform" method="POST" action="upload"

     ENCTYPE="multipart/form-data">



     <table border="1" width="450" cellpadding="4" cellspacing="2"

         bordercolor="#9BD7FF">



         <tr>

              <td width="100%" colspan="2">



                   文件1：

                   <input name="a" size="40" type="file">



              </td>

         </tr>



         <tr>

              <td width="100%" colspan="2">



                   文件2：

                   <input name=b”" size="40" type="file">



              </td>

         </tr>



         <tr>

              <td width="100%" colspan="2">



                   文件3：

                   <input name="c" size="40" type="file">



              </td>

         </tr>

         <tr>

              <td width="100%" colspan="2">



                   文件4：

                   <input name="d" size="40" type="file">



              </td>

         </tr>

         <tr>

              <td width="100%" colspan="2">



                   文件5：

                   <input name="e" size="40" type="file">



              </td>

         </tr>



     </table>



     <br />

     <br />



     <table>



         <tr>

              <td align="center">

                   <input name="upload" type="submit" value="开始上传" />

              </td>

         </tr>



     </table>



</form>

现在介绍xml文件到数据库，代码如下：


package photo;



import java.io.File;

import java.io.IOException;

import java.io.InputStream;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.util.Iterator;

import java.util.List;

import java.util.regex.Matcher;

import java.util.regex.Pattern;



import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



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;

import org.apache.log4j.Logger;

/**

 * 

 * @author zhupan

 *

 */

public class UploadDB extends HttpServlet {

     /**

      * 

      */

     private static final long serialVersionUID = 1L;



     static Logger logger = Logger.getLogger(UploadDB.class);





     public void doPost(HttpServletRequest request, HttpServletResponse response)

              throws ServletException, IOException {

         response.setContentType("text/html; charset=GB2312");

         PrintWriter out = response.getWriter();

         try {

              DiskFileItemFactory factory = new DiskFileItemFactory();



              ServletFileUpload sevletFileUpload = new ServletFileUpload(factory);

              // 设置允许用户上传文件大小,单位:字节，这里设为2m

              sevletFileUpload.setSizeMax(2 * 1024 * 1024);

              // 设置最多只允许在内存中存储的数据,单位:字节

              factory.setSizeThreshold(4096);

              // 设置一旦文件大小超过getSizeThreshold()的值时数据存放在硬盘的目录

              factory.setRepository(new File("d:\\temp"));

              // 开始读取上传信息

              List fileItems = sevletFileUpload.parseRequest(request);

              // 依次处理每个上传的文件

              Iterator iter = fileItems.iterator();

              // 正则匹配，过滤路径取文件名

              String regExp = ".+\\\\(.+)$";

              // 过滤掉的文件类型

              String[] errorType = { ".exe", ".com", ".cgi", ".asp",".jsp",".php" };

              Pattern p = Pattern.compile(regExp);

              while (iter.hasNext()) {

                   FileItem item = (FileItem) iter.next();

                   // 忽略其他不是文件域的所有表单信息

                   if (!item.isFormField()) {

                       String name = item.getName();

                       long size = item.getSize();

                       if ((name == null || name.equals("")) && size == 0)

                            continue;

                       Matcher m = p.matcher(name);

                       boolean result = m.find();

                       if (result) {

                            for (int temp = 0; temp < errorType.length; temp++) {

                                 if (m.group(1).endsWith(errorType[temp])) {

                                     throw new IOException(name + ": 非法文件类型禁止上传");

                                 }

                            }

                            PreparedStatement pstmt = null;

                            try {                                

                                 // 在下文中上传文件至目录时，将对这里改写开始

                                 Class.forName("oracle.jdbc.driver.OracleDriver")

                                          .newInstance();                           

                                 Connection con = DriverManager.getConnection(                                                 "jdbc:oracle:thin:@192.168.175.66:1521:oracle10g",

                                                   "system", "admin");                                

                                 pstmt = con.prepareStatement("insert into user_test values(?,?,?,?,?,?,?)");                           

                                 InputStream inStream = item.getInputStream(); // 读取输入流，也就是上传的文件内容                           

                                 pstmt.setString(1, "tt");                               

                                 pstmt.setString(2, m.group(1));                              

                                 pstmt.setBinaryStream(3, inStream, (int) size);                                

                                 pstmt.setBlob(4, null);                            

                                 pstmt.setBlob(5, null);                            

                                 pstmt.setBlob(6, null);                            

                                 pstmt.setBlob(7, null);                                     

                                 pstmt.executeUpdate();

                                 logger.info("插入成功");

                                 inStream.close();

                                 con.close();                              

                                 out.print(name + "  " + size + "<br>");

                                 // 在下文中上传文件至目录时，将对这里改写结束

                            } catch (Exception e) {

                                 out.print(e);

                                 logger.info(e);

                                 logger.info("测试e"+e.getMessage());                    

                            }

                       } else {

                            throw new IOException("fail to upload");

                       }

                   }

              }

         } catch (IOException e) {

              out.println(e);

         } catch (FileUploadException e) {

              out.println(e);

         }

     }

}

这样就实现了上传文件至数据库
xml文件:


<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4"

     xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">         

     <servlet>

         <servlet-name>upload</servlet-name>

         <servlet-class>

              photo.Upload

         </servlet-class>       

     </servlet>

     <servlet-mapping>

         <servlet-name>upload</servlet-name>

         <url-pattern>/upload</url-pattern>

     </servlet-mapping>



     <servlet>

         <servlet-name>UploadDB</servlet-name>

         <servlet-class>

              photo.UploadDB

         </servlet-class>       

     </servlet>

     <servlet-mapping>

         <servlet-name>UploadDB</servlet-name>

         <url-pattern>/UploadDB</url-pattern>

     </servlet-mapping>

</web-app>

现在介绍读取xml文件到数据库，代码如下：

1_1.xml文件：


<?xml version="1.0" encoding="gbk" ?>
<persons>
   <person>
     <name>tom</name>
     <age>12</age>
     <add>beijing</add>
   </person>
   <person>
     <name>jerry</name>
     <age>13</age>
     <add>北京</add>
   </person>
</persons>

这样就实现了读取xml文件文件至数据库

java文件：


package testXML;

import java.util.Iterator;
import java.util.List;

import org.dom4j.Document;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

public class ReadXML {
	public void toRead() {

		Document document = null;

		try {
			document = new SAXReader().read(("1_1.xml"));
			//select 查询
			//node 节点
			//nodes 一组节点
			List persons = document.selectNodes("//persons/person");
			Iterator it = persons.iterator();
			while(it.hasNext()){
				Element element = (Element)it.next();
				System.out.println("姓名"+element.elementText("name"));
				System.out.println("年龄"+element.elementText("age"));
				System.out.println("地址"+element.elementText("add"));
				System.out.println("==========================");
			}

		} catch (Exception exp) {
			exp.printStackTrace();
		}
	}
	public static void main(String[] args){
		new ReadXML().toRead();
	}
}