Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. try {
  2. Class.forName("org.postgresql.Driver");
  3. Connection con = DriverManager.getConnection("jdbc:postgresql://172.10.10.3:5432/stepup380qty","stepup380qty","stepup380qty");
  4. String query = "select binarydata from ad_image where ad_image_id =" + id;
  5. Statement stm = con.createStatement();
  6. ResultSet rs = stm.executeQuery(query);
  7. rs.next();
  8. String img = rs.getString("binarydata");
  9. byte[] img2 = new byte[img.length()];
  10. InputStream imgstream = rs.getBinaryStream("binarydata");
  11. int index = imgstream.read(img2, 0, img.length());
  12. stm.close();
  13. response.reset();
  14. response.setContentType("image/jpg");
  15. response.getOutputStream().write(img2,0,img2.length);
  16. response.getOutputStream().flush();
  17. imgstream.close();
  18. }
  19. catch (SQLException e) {
  20. e.printStackTrace();
  21. }
  22. catch (Exception e) {
  23. e.printStackTrace();
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement