关于JSP上传文件和表单值同时上传到数据库的问题。

这个问题有些复杂,因为在上传文件需要在标签中加入enctype="multipart/form-data"这个属性,表单中enctype="multipart/form-data"的意思,是设置表单的MIME编码。默认情况,这个编码格式是application/x-www-form-urlencoded,不能用于文件上传;只有使用了multipart/form-data,才能完整的传递文件数据,进行下面的操作.
enctype="multipart/form-data"是上传二进制数据; form里面的input的值以2进制的方式传过去,所以request就得不到值了。
这里我们就需要用到第三方包了。
我这里用的是commons-fileupload-1.2.jar和commons-io-1.2.jar这两个类库。
然后直接进入代码吧。
还是老样子,先列出需要的类和方法。
一个JSP页面,一个model,一个servlet
jsp:upload.jsp,
model:GoodsBeanBO.java
servlet:UploadServlet.java

正式代码:
upload.jsp

<%@ page contentType="text/html;charset=gb2312" language="java"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>上传</title>
    <META http-equiv=Content-Type content="text/html;charset=gb2312">
  </head>
  
  <body>
  <form action="UploadSevlet" enctype="multipart/form-data" method="post">
  	图片:<input type="file" id="file1" name="file1"><br/>
  	名称:<input type="text" id="Name" name="Name"><br/>
  	简介:<input type="text" id="Intro" name="Intro"><br/>
  	价格:<input type="text" id="Price" name="Price"><br/>
  	数量:<input type="text" id="Num" name="Num"> 可以不填<br/>
  	产地:<input type="text" id="Publisher" name="Publisher"><br/>
  	标签:<input type="text" id="Type" name="Type"><br/>
  	<input type="submit" value="上传">
  </form>
  </body>
</html>

model.java

这个是实现方法的类,里面有各种各样的方法, 我这里只列出这个模块用到的方法。
public GoodsBean savaGoods(GoodsBean gb) {
		Connection ct  = ConnDB.getConn();
		String sql = "INSERT INTO goods(goodsName,goodsIntro,goodsPrice,goodsNum,publisher,photo,type) values(?,?,?,?,?,?,?)";
		try {
			PreparedStatement ps = ct.prepareStatement(sql);
			ps.setString(1, gb.getGoodsName());
			ps.setString(2, gb.getGoodsIntro());
			ps.setString(3, gb.getGoodsPrice());
			ps.setString(4, gb.getGoodsNum());
			ps.setString(5, gb.getPublisher());
			ps.setString(6, gb.getPhoto());
			ps.setString(7, gb.getType());
			ps.executeUpdate();
			
			ps.close();
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			this.close();
		}
		return gb;
	}

最后一个是servlet控制器最重要的步骤
UploadServlet.java

package com.sp.servlet;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.util.Iterator;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
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 com.sp.model.GoodsBean;
import com.sp.model.GoodsBeanBO;

/**
 * Servlet implementation class UploadSevlet
 */
@WebServlet("/UploadSevlet")
public class UploadSevlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    /**
     * @see HttpServlet#HttpServlet()
     */
    public UploadSevlet() {
        super();
        // TODO Auto-generated constructor stub
    }
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html");
		response.setCharacterEncoding("gb2312");
		PrintWriter out = response.getWriter();
		DiskFileItemFactory factory = new DiskFileItemFactory();
		factory.setSizeThreshold(1024 * 1024);//1M
		ServletFileUpload upload = new ServletFileUpload(factory);
		upload.setFileSizeMax(1024 * 1024 * 50);//50M
		String fieldName=  null;
		FileItem item=null;
		String values = null;
		try {
			GoodsBeanBO gbb = new GoodsBeanBO();
			GoodsBean gb = new GoodsBean();
			Iterator<FileItem> iterator = upload.parseRequest(request).iterator();
			while(iterator.hasNext()){
				item = iterator.next();
				if(item.isFormField()){
					out.println(item.getFieldName()+"="+item.getString("gb2312")+"<br>");
					
					fieldName = item.getFieldName();//得到表单中name的值
					values = item.getString("gb2312");//得到表单中value的值
					/**
					 * 根据表单控件名得到value的值并且插入到GoodsBean中
					 */
					if(fieldName.equals("Name")) {
					gb.setGoodsName(new String(values));}
					else if(fieldName.equals("Intro")) {
					gb.setGoodsIntro(new String(values));}
					else if(fieldName.equals("Price")) {
					gb.setGoodsPrice(new String(values));}
					else if(fieldName.equals("Num")) {
					gb.setGoodsNum(new String(values));}
					else if(fieldName.equals("Publisher")) {
					gb.setPublisher(new String(values));}
					else if(fieldName.equals("Type")) {
					gb.setType(new String(values));}
					
				} else {
					//上传路径
					String contextRealPath = "D:/Program Files/Android/workspace_Web/Catering/WebContent/images/menu/";
					String fileName = item.getName();//得到文件名
					int xieGangIndex = fileName.lastIndexOf("\\") + 1;
					fileName = fileName.substring(xieGangIndex);
					System.out.println(contextRealPath);
					System.out.println(fileName);
					gb.setPhoto(fileName);//把photo插入GoodsBean中
					FileOutputStream outputStream = new FileOutputStream(contextRealPath + "/"+fileName);//创建一个文件输出流对象
					InputStream inputStream = item.getInputStream();//创建一个输入流
					byte pool[] = new byte[1024];
					int len = -1;
					while((len = inputStream.read(pool, 0, pool.length)) != -1){
						outputStream.write(pool, 0, len);
					}
					outputStream.flush();
					outputStream.close();
					inputStream.close();
					//显示最新插入的图片
					out.println("<img src=\"D:/Program Files/Android/workspace_Web/Catering/WebContent/images/menu/"+fileName+"\" alt=\""+fileName+"\" width=\"200px\" height=\"100px\"/><br/>");
					
				}
			}
			out.println("上传成功!");
			gb = gbb.savaGoods(gb);
			
		} catch (FileUploadException e) {
			e.printStackTrace();
		}		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		this.doGet(request, response);
	}

}

就这三个代码,其实很简单,自己理解一下。

  • 3
    点赞
  • 21
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值