oracle blob 流 下载,读取oracle blob字段内容并以文件形式下载

这个也是从网找的代码攒的，做个记录，以后可能会用得着。表里即存了文件的内容，也存了文件的类型。

String xh = request.getParameter("xh")==null?"":request.getParameter("xh").toString();

Connection con = JdbcUtilsHelper.getConnection();

PreparedStatement pstm = con.prepareStatement("select wjnr,wjlx from table where xh=?");

pstm.setString(1, xh);

ResultSet rs = pstm.executeQuery();

if(rs.next()){

Blob blob = rs.getBlob(1);

String wjlx = rs.getString(2);

if(blob != null){

InputStream ins = blob.getBinaryStream();

response.setContentType("application/x-msdownload");

response.addHeader("Content-Disposition", "attachment; filename=data."+wjlx);

OutputStream outStream = response.getOutputStream();

byte[] bytes = new byte[1024];

int len = 0;

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

outStream.write(bytes,0,len);

}

out.clear();

out = pageContext.pushBody();

ins.close();  outStream.close();  outStream = null;  con.commit();  con.close();  }else{  out.print("下载文件失败！文件内容为空!"); } }else{ out.print("下载文件失败！没有找到相关记录！");}