[code="java"]<%@ page language="java" pageEncoding="UTF-8" contentType="image/jpeg" import="java.awt.image.*,java.sql.*,com.sun.image.codec.jpeg.*,java.util.*,javax.imageio.*,java.io.*"%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
conn=sql.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
BufferedInputStream inputimage=null;
boolean defaultCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
try
{
int i=0;
rs = stmt.executeQuery(" SELECT Pic from V_USER WHERE USER='MAX'");
while (rs.next())
{
i++;
oracle.sql.BLOB blob = (oracle.sql.BLOB)rs.getBlob("Pic");
inputimage = new BufferedInputStream(blob.getBinaryStream());
}rs.close();
}
catch (Exception ex)
{
System.out.println("blobRead()'s exception"+ex);
conn.rollback();
throw ex;
}
conn.setAutoCommit(defaultCommit);
// Send back image
BufferedImage image = null;
try
{
image = ImageIO.read(inputimage);
}
catch(IOException e)
{
System.out.println(e);
}
ServletOutputStream sos = response.getOutputStream();
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(sos);
encoder.encode(image);
inputimage.close();
%> [/code]
SELECT Pic from V_USER WHERE USER='MAX' 的值有多笔资料,
在页面上显示时,只显示最后一张图,请问是何原因啊!!