JSP—实现图片上传到数据库

女爷i 2022-07-14 08:44 229阅读 0赞

### 文件目录结构 ###

![Center][]

### 数据库 ###

CREATE  TABLE `user`.`images` (  
    `id` INT NOT NULL ,  
    `content` VARCHAR(100) NULL ,  
    `image` BLOB NULL ,  
    PRIMARY KEY (`id`) );
    INSERT INTO `user`.`images` (`id`, `content`) VALUES (0, '无');

![Center 1][]

### index.jsp ###

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%
    	String path = request.getContextPath();
    	String basePath = request.getScheme() + "://"
    			+ request.getServerName() + ":" + request.getServerPort()
    			+ path + "/";
    %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    </head>
    
    <body>
    	<form method="post" action="image.jsp">
    		<input type="file" name="image" /><br /> 相片描述<input type="text"
    			name="content" /><br /> <input type="submit" />
    	</form>
    </body>
    </html>

### 界面： ###

![Center 2][]

### image.jsp ###

<%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*"%>
    <%@ page import="java.util.*"%>
    <%@ page import="java.io.*"%>
    
    <!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=ISO-8859-1">
    <title>图片上传</title>
    </head>
    <body>
    	<jsp:useBean id="conn4" class="com.conDBMS.Conn" scope="session" />
    	<%
    		request.setCharacterEncoding("utf-8");
    		String content = request.getParameter("content");
    		String filename = request.getParameter("image");
    		System.out.println(filename);
    		//ServletInputStream str=request.getInputStream();  
    		InputStream str = new FileInputStream(filename);
    		//byte b[]=new byte[str.available()];
    		//str.read(b);x
    		//ByteArrayInputStream bi=new ByteArrayInputStream(b);
    		String sql1 = "select * from images";
    		Statement stmt = conn4.getConnection().createStatement();
    		System.out.println("连接成功");
    		ResultSet rs = stmt.executeQuery(sql1);
    		rs.last();
    		int id = rs.getInt("id") + 1;
    		String sql = "insert into images(id,content,image) values(" + id
    				+ ",?,?)";
    		PreparedStatement pstmt = conn4.getConnection().prepareStatement(
    				sql);
    		pstmt.setString(1, content);
    		long l = (long) str.available();
    		pstmt.setBinaryStream(2, str, l);
    		//out.print(bi.available());
    		try {
    			pstmt.executeUpdate();
    		} catch (Exception e) {
    			//out.print(sql);
    			out.print(e.getMessage());
    		}
    		out.println("Success,You Have Insert an Image Successfully");
    	%>
    </body>
    </html>

### Conn.java ###

package com.conDBMS;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    
    public class Conn {
    	final String MYSQLDBDRIVER = "com.mysql.jdbc.Driver";
    	final String MYSQLDBURL = "jdbc:mysql://localhost/user";
    	final String MYSQLDBUSER = "root";
    	final String MYSQLDBUSERPASS = "root";
    
    	public Connection getConnection() {
    		try {
    			Class.forName(MYSQLDBDRIVER);
    			Connection con = DriverManager.getConnection(MYSQLDBURL,
    					MYSQLDBUSER, MYSQLDBUSERPASS);
    			return con;
    		} catch (Exception e) {
    			e.printStackTrace();
    			return null;
    		}
    	}
    }

### 运行结果： ###

![Center 3][]

![Center 4][]

![Center 5][]

[Center]: /images/20220714/15c788b4686b4298b998b5e043730ab5.png
[Center 1]: /images/20220714/b6e38139710b4ec7b9438276ed9725b0.png
[Center 2]: /images/20220714/13b000089c134f8b901b4d458c91a499.png
[Center 3]: /images/20220714/be54d350e9ab4a519326ec48bbacdaf3.png
[Center 4]: /images/20220714/81c38132ca87481f9fd05074703385e8.png
[Center 5]: /images/20220714/a7ed29b148e845eca7344a2e0afc9d4f.png