从数据库读出的JPG文件的字符流,转换成图片显示在页面上的相关代码
点击次数:23 次 发布日期:2008-11-26 15:55:50 作者:源代码网
|
源代码网推荐
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { ServletOutputStream out = res.getOutputStream(); Statement dispStmt = null, setStmt = null; try { dispStmt = Con.createStatement(); setStmt = Con.createStatement(); setStmt.executeUpdate("set textsize 2048000"); } catch (Exception e) { out.println("Create Statement error:" + e.toString() + "<br>"); }
String ls_sql = null; ls_sql = req.getParameter("ImageSQL"); if (ls_sql == null) ls_sql = ""; ls_sql = ls_sql.trim(); if (!ls_sql.equals("")) { ResultSet rs = null; try { rs = dispStmt.executeQuery(ls_sql); } catch (Exception e) { System.out.println( "Unable to Exec Statment" + e.toString() + "<br>"); } try { while (rs.next()) { try { res.setContentType("image/jpeg"); InputStream is = rs.getBinaryStream(1); int size = is.available(); byte[] bzp = new byte[size]; is.read(bzp); out.write(bzp); } catch (Exception e) { System.out.println("Wirte image error: " + e.toString()); } } rs.close(); } catch (Exception e) { System.out.println("Unable to Close Statment" + e.toString()); } } try { dispStmt.close(); } catch (Exception e) { System.out.println("Close Statement Error: " + e.toString()); } out.close(); }
--------------------------------------------------------------------------------
再附一个:
从库中读图片显示到页面上的主要源码 <%@ page contentType="text/html;charset=iso8859_1"%> <%@ page import="java.sql.ResultSet"%> <jsp:useBean id="query" class="pub.MakeDB"/> <% String sql = "select * from images"; ResultSet rs = query.executeQuery(sql); rs.next(); InputStream in = rs.getBinaryStream("image"); ServletOutputStream sos = response.getOutputStream(); int len = 0; byte[] b = new byte[1024]; response.reset(); response.setContentType("image/gif"); while((len = in.read(b)) > 0) sos.write(b,0,len); in.close(); sos.close(); query.cls(); %> 如果是写到文件只要把sos 定义为DataOutputStream sos = new DataOutputStream(new BufferedOutputStream(new FileOutputStream("/a.gif")));
源代码网供稿. |