| |
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();}
|
|
