文件上传

最新推荐文章于 2024-02-02 11:19:58 发布

iteye_8614

最新推荐文章于 2024-02-02 11:19:58 发布

阅读量80

点赞数

分类专栏： J2EE 文章标签： Java Servlet Apache Oracle XML

J2EE 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

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();
	}
}

iteye_8614

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
文件上传

common-fileupload是jakarta项目组开发的一个功能很强大的上传文件组件下面先介绍上传文件到服务器（多文件上传）： [code="java"]package photo;import java.io.File;import java.io.IOException;import java.io.PrintWriter;import ja...
复制链接

扫一扫

专栏目录