oracle blob 图片jsp显示

01.<%@page import="java.io.PrintWriter"%>     
02.<%@page import="java.io.OutputStream"%>     
03.<%@page import="java.io.InputStream"%>     
04.<%@page import="java.sql.ResultSet"%>     
05.<%@page import="net.sysmain.common.ConnectionManager"%>     
06.<%@page import="java.sql.PreparedStatement"%>     
07.<%@page import="java.sql.Connection"%>     
08.<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>     
09.<%     
10.    response.reset();     
11.    String guid = request.getParameter("guid");     
12.    Connection conn = null;     
13.    PreparedStatement ps = null;     
14.    ResultSet rs = null;     
15.    InputStream is = null;     
16.    OutputStream os = null;     
17.    try{     
18.        conn = ConnectionManager.getInstance().getConnection();     
19.        ps = conn.prepareStatement("select img from user where guid=?");     
20.        ps.setString(1, guid);     
21.        rs = ps.executeQuery();     
22.        if(rs.next()){     
23.            is = rs.getBinaryStream(1);     
24.        }     
25.        response.setContentType("image/jpeg");     
26.        os = response.getOutputStream();     
27.        int num;     
28.        byte buf[] = new byte[1024];     
29.        while(   (num=is.read(buf))!=-1   ){     
30.            os.write(buf, 0, num);     
31.        }     
32.        os.flush();     
33.        is.close();     
34.        os.close();     
35.    }catch(Exception e){     
36.        e.printStackTrace();     
37.    }finally{     
38.        ConnectionManager.close(conn,ps,rs);     
39.    }     
40.%>