接收图像之前，您已经关闭了连接。将代码更改为
<html><body> <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> <%@ page import="com.mysql.*"%> <%@ page import="java.util.*"%> <%@ page import="java.text.*"%> <%@ page import="javax.servlet.*"%> <%@ page import="javax.servlet.http.*"%> <%@ page import="javax.servlet.http.HttpSession"%> <%@ page language="java"%> <%@ page session="true"%> <%@ page import="java.sql.*"%><% Blob image = null;Connection con = null;Statement stmt = null;ResultSet rs = null;String iurl1=null;try {Class.forName("com.mysql.jdbc.Driver");con =DriverManager.getConnection("jdbc:mysql://localhost:portnumber/dbname","","");stmt = con.createStatement();rs = stmt.executeQuery("select * from tablename where id = 1");%><table border="2"><tr><th>DISPLAYING IMAGE</th></tr><tr><td>Image 2</td></tr><tr><td><%while(rs.next()){%> <img src="https://www.mshxw.com/skin/sinaskin/image/nopic.gif"image") %>" width="500" height="500"/> <%}%></td></tr></table><%}catch (Exception e) {out.println("DB problem"); return;}finally {try {rs.close();stmt.close();con.close();}catch (SQLException e) {e.printStackTrace();}}%></body></html>否则有更好的方法将其保存在变量中
<html><body> <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> <%@ page import="com.mysql.*"%> <%@ page import="java.util.*"%> <%@ page import="java.text.*"%> <%@ page import="javax.servlet.*"%> <%@ page import="javax.servlet.http.*"%> <%@ page import="javax.servlet.http.HttpSession"%> <%@ page language="java"%> <%@ page session="true"%> <%@ page import="java.sql.*"%><% Blob image = null;Connection con = null;Statement stmt = null;ResultSet rs = null;String iurl1=null;String image=null;try {Class.forName("com.mysql.jdbc.Driver");con =DriverManager.getConnection("jdbc:mysql://localhost:portnumber/dbname","","");stmt = con.createStatement();rs = stmt.executeQuery("select * from tablename where id = 1"); while(rs.next()){ image = rs.getString("image"); }}catch (Exception e) {out.println("DB problem"); return;}finally {try {rs.close();stmt.close();con.close();}catch (SQLException e) {e.printStackTrace();}}%> <table border="2"> <tr><th>DISPLAYING IMAGE</th></tr> <tr><td>Image 2</td></tr> <tr><td> <img src="<%=image %>" width="500" height="500"/> </td></tr> </table></body></html>
