//原因是:while循环重复给一个 inputimage 赋值导致,在循环到下一条记录会把上一条记录覆盖的原因
//解决方法:用集合保存
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);
ArrayList imagestList=new ArrayList();
ArrayList imageList=new ArrayList();
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());
//原因是:while循环重复给一个 inputimage 赋值导致,在循环到下一条记录会把上一条记录覆盖的原因
//解决方法:用集合保存
imagestList.add(inputimage);
}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
{
for(int i=0;i
{
image = ImageIO.read(inputimage);
imageList.add(image);//存放所有图片
}
}
catch(IOException e)
{
System.out.println(e);
}
ServletOutputStream sos = response.getOutputStream();
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(sos);
encoder.encode(image);
inputimage.close();
%>
2012年8月31日 11:37
2207
1
3
134