文件上传
来源:互联网 发布:unity3d 游戏特效 编辑:程序博客网 时间:2024/06/04 19:21
文件上传是网站非常常用的功能,直接使用Servlet获取上传文件还得解析请求参数,比较麻烦,所以一般选择采用
apache的开源工具,common-fileupload.这个jar包可以再apache官网上面找到,也可以在struts的lib文件夹下面找到,
struts上传的功能就是基于这个实现的。
common-fileupload是依赖于common-io这个包的,所以还需要下载这个包。然后导入到你的项目路径下面。
使用代码如下
- package oop.hg.ytu.servlet;
-
- import java.io.File;
- 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 oop.hu.ytu.dao.UploadDomain;
-
- import org.apache.commons.fileupload.FileItem;
- import org.apache.commons.fileupload.disk.DiskFileItemFactory;
- import org.apache.commons.fileupload.servlet.ServletFileUpload;
-
- public class Upload extends HttpServlet {
-
-
-
-
- private static final long serialVersionUID = 1L;
-
- public void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
-
- DiskFileItemFactory factory = new DiskFileItemFactory();
- @SuppressWarnings("deprecation")
- String path = request.getRealPath("/upload");
-
- factory.setRepository(new File(path));
- factory.setSizeThreshold(1024*1024);
-
- ServletFileUpload upload = new ServletFileUpload(factory);
- upload.setSizeMax(-1);
- try {
- @SuppressWarnings("unchecked")
- List<FileItem> list = upload.parseRequest(request);
- String va = null;
- for(FileItem item : list){
-
- if(item.isFormField()){
-
- va = item.getString("UTF-8");
-
-
- }else{
- String value = item.getName();
- int start = value.lastIndexOf("\\");
- String fileName = value.substring(start+1);
-
- InputStream in = item.getInputStream();
- UploadDomain dao = new UploadDomain();
-
- int index = fileName.lastIndexOf(".");
- String realFileName = fileName.substring(0,index);
- String type = fileName.substring(index+1);
- dao.insert(in, realFileName,type,va);
-
- }
- }
- } catch (Exception e) {
-
- e.printStackTrace();
- }
- }
-
- public void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- doGet(request, response);
-
- }
-
- }
这里分别判断是否是上传的流或者表单里面的参数,比如文本框提交信息,然后将他们插入到数据库中。数据库插入代码如下
- package oop.hu.ytu.dao;
-
- import java.io.InputStream;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
-
- import oop.hg.ytu.utils.JdbcUtils;
-
-
-
-
-
-
- public class UploadDomain {
-
-
-
- public void insert(InputStream in, String fileName, String type,String describe) throws Exception{
- Connection conn = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- System.out.println(describe);
- try {
-
- conn = JdbcUtils.getConnection();
-
- String sql = "insert into fileupload(file,filename,type,des) values (?,?,?,?)";
- ps = conn.prepareStatement(sql);
- ps.setBlob(1, in);
- ps.setString(2, fileName);
- ps.setString(3, type);
- ps.setString(4, describe);
-
- ps.executeUpdate();
-
- in.close();
-
-
- } finally {
- JdbcUtils.free(rs, ps, conn);
- }
- }
- }
可能会遇到数据库默认问价大小限制,需要在mysql安装目录下面的my.ini下面更改如下配置,
- [mysqld]
- max_allowed_packet=64M
这样就可以了。当然,注意编码格式。上传文件搞定。还有就是我的一个列名设置为describe,结果和Mysql保留字冲突,出现无法插入信息现象,以后一定要注意.
0 0