图像文件上传数据库

最新推荐文章于 2024-09-22 11:17:00 发布

潇潇雨歇_

最新推荐文章于 2024-09-22 11:17:00 发布

阅读量469

点赞数

文章标签：数据库数据管理

本文链接：https://blog.csdn.net/linhaiyun_ytdx/article/details/53464410

版权

Servlet+Filter 学习笔记专栏收录该内容

15 篇文章 0 订阅

订阅专栏

代码：

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>文件上传</title>
</head>
<body>
   <form action="FileUploadServlet" method="post" enctype="multipart/form-data">
               选择上传文件：
     <input type="file" name="file" id="file" accept="image/*"/><br/><br/>
     <input type="submit" value="上传" name="upload" id="upload"/>
   </form>
</body>
</html>

FileUploadServlet.java

package com.servlet;

import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;

import com.connect.DButil;
@MultipartConfig//标识Servlet支持文件上传
public class FileUploadServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public FileUploadServlet() {
        super();
        // TODO Auto-generated constructor stub
    }
    protected void processRequest(HttpServletRequest request,HttpServletResponse response)
    		throws ServletException,IOException{
    	response.setContentType("text/html;charset=UTF-8");
    	request.setCharacterEncoding("UTF-8");
    	
        final Part filePart=request.getPart("file");
    	final String fileName=getFileName(filePart);
    	Connection conn=null;
    	
    	OutputStream out=null;
    	InputStream filecontent=null;
    	final PrintWriter writer=response.getWriter();
    	
    	try {
    		conn=DButil.open();
			conn.setAutoCommit(false);
			
			String sql="INSERT INTO images(name,image) VALUES(?,?)";
			PreparedStatement stmt=(PreparedStatement) conn.prepareStatement(sql);
			stmt.setString(1, fileName);
			filecontent=filePart.getInputStream();
			
			stmt.setBinaryStream(2, filecontent, (int)filePart.getSize());
			stmt.execute();
			
			conn.commit();
			response.sendRedirect("disping.jsp");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			writer.println("<br/>错误："+e.getMessage());
			e.printStackTrace();
		}
    	finally {
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(out!=null){
				out.close();
			}
			if(filecontent!=null){
				filecontent.close();
			}
			if(writer!=null){
				writer.close();
			}
		}
    	
    }
	private String getFileName(final Part part) {
		// TODO Auto-generated method stub
		for(String content : part.getHeader("content-disposition").split(";")){
			String filename=content.substring(content.lastIndexOf('\\')+1).trim().replace("\"", "");
			return filename;
		}
		return null;
	}
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		processRequest(request, response);
	}
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		processRequest(request, response);
	}

}

disping.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>显示最后一张图片</title>
</head>
<body>
     <h4>显示最后一张图片</h4>
     <img alt="图片" src="ImageServlet"/>
</body>
</html>

ImageServlet.java

package com.servlet;

import java.io.IOException;
import java.io.InputStream;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.connect.DButil;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
public class ImageServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public ImageServlet() {
        super();
        // TODO Auto-generated constructor stub
    }
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("image/jpeg");
		request.setCharacterEncoding("UTF-8");
		ServletOutputStream os=response.getOutputStream();
		
		Connection conn=null;
		
		try {
			conn=DButil.open();
			String sql="SELECT name,image FROM images ORDER BY id DESC";
			PreparedStatement stmt=(PreparedStatement) conn.prepareStatement(sql);
			ResultSet rs=stmt.executeQuery();
			if(rs.next()){
				//没有用到
				@SuppressWarnings("unused")
			  String name=rs.getString(1);
			  
			  byte[] buffer=new byte[1];
			  InputStream is=rs.getBinaryStream(2);
			  while(is.read(buffer)>0){
				  os.write(buffer);
			  }
			  os.flush();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(os!=null){
				os.close();
			}
		}
		
	}

}

截图：