文件上传2.0

最新推荐文章于 2024-01-17 15:03:27 发布

「已注销」

最新推荐文章于 2024-01-17 15:03:27 发布

阅读量162

点赞数

分类专栏：一点一滴学java

本文链接：https://blog.csdn.net/qq_41588302/article/details/106302113

版权

一点一滴学java 专栏收录该内容

139 篇文章 1 订阅

订阅专栏

package com.student;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.List;

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.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

import com.login.GetJdbc;
@WebServlet("/fileUpload")
public class fileUpload extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		
	}
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=utf-8");
		request.setCharacterEncoding("utf-8");
		String pname= null;
		DiskFileItemFactory upload=new DiskFileItemFactory();
		ServletFileUpload sfu=new ServletFileUpload(upload);
		try {
			String realpath=this.getServletContext().getRealPath("/upload");
			//String realpath="D:\\软件\\eclipse\\code\\EducationCertification\\WebContent\\upload";
			List<FileItem> list=sfu.parseRequest(request);
			for(FileItem file:list) {
				if(file.isFormField()) {
					if(file.getFieldName().equals("pname")) {
						//有点东西,不用的话会有乱码
						pname=file.getString("utf-8");
						//System.out.println(pname);
					}
				}
			}
			for(FileItem file:list) {
				if(file.isFormField()==false) {
					String path=realpath+"/"+file.getName();
					//System.out.println(path);
					File f=new File(path);
					file.write(f);
					Connection cn=GetJdbc.getCon();
					//insert没有where条件，使用update
					String sql="update practice set p_resource=? where p_name=?";
					PreparedStatement ps = cn.prepareStatement(sql);
					ps.setString(1, path);
					ps.setString(2, pname);
					int exe = ps.executeUpdate();
					//System.out.println(exe);
					ps.close();
					cn.close();
				}
			}
			response.getWriter().write("");
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		
	}

}

注意的地方就是不能再用getparameter的方法了。
insert into table() values()
update table set name=? where id=?