本文展示了一个使用JSP从数据库检索并显示图片的示例。通过连接数据库、执行SQL查询来获取图片数据，并将其输出到客户端。示例中包含了异常处理及资源释放的完整流程。
<%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="cn.java.*"%><%@page import="java.sql.*"%><%@page import="java.text.*"%><%@page import="java.io.*"%><%@page import="java.util.*"%><!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>JSP Page</title> </head> <body> <% Connection conn = null; Statement stmt=null; ResultSet rs=null;
try ...{
String sql = "select ps from ss where id=15"; conn = DBUtil.getConnection(); stmt=conn.createStatement(); rs=stmt.executeQuery(sql);
while(rs.next())...{ response.setContentType("image/jpeg"); ServletOutputStream sout=response.getOutputStream(); InputStream in=rs.getBinaryStream(1); byte b[] = new byte[0x7a120];//获得二进制输入流 for(int i=in.read(b);i!=-1;)...{ sout.write(b); in.read(b);
} //普通数据采用此语句 // while(in.read(b)!=-1){ // sout.write(b);//输出字符流 /// } sout.flush(); sout.close();//关闭sout输出流 } } catch (SQLException ex) ...{ out.println(ex.getMessage());
} finally ...{ try ...{ DBUtil.close(rs, stmt, conn); } catch (Exception ex) ...{ out.println(ex.getMessage()); } }%> </body></html>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
