pic.jsp

本系统是一个在线考试系统

<%@  page import="java.io.*" import="java.sql.*" %>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%
response.setContentType("image/jpeg");
Connection Conn = DBCon.getConnection();

PreparedStatement  pstmt = null;
ResultSet rs = null;
String id=request.getParameter("ID");
//从数据库里读取图片
String sql="SELECT * FROM PHOTOS WHERE ID="+id;
pstmt = Conn.prepareStatement(sql);
rs = pstmt.executeQuery();
rs.next();
byte[] buffer = rs.getBytes("photo");

//显示图片
BufferedOutputStream bos = new BufferedOutputStream(response.getOutputStream());
bos.write(buffer);
bos.flush();
bos.close();

rs.close();
pstmt.close();
Conn.close();
%>