在Oracle中存取BLOB对象实现文件的上传和下载[13]

        Blob blob = rs.getBlob(1);

        InputStream ins = blob.getBinaryStream();

        response.setContentType("application/unknown");

        response.addHeader("Content-Disposition", "attachment; filename="+"output.txt");

        OutputStream outStream = response.getOutputStream();

        byte[] bytes = new byte[1024];

        int len = 0;

        while ((len=ins.read(bytes))!=-1) {

            outStream.write(bytes,0,len);

        }

        ins.close();

        outStream.close();

        outStream = null;

        con.commit();

        con.close();

      }

%>