Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("org.postgresql.Driver");
- Connection con = DriverManager.getConnection("jdbc:postgresql://172.10.10.3:5432/stepup380qty","stepup380qty","stepup380qty");
- String query = "select binarydata from ad_image where ad_image_id =" + id;
- Statement stm = con.createStatement();
- ResultSet rs = stm.executeQuery(query);
- rs.next();
- String img = rs.getString("binarydata");
- byte[] img2 = new byte[img.length()];
- InputStream imgstream = rs.getBinaryStream("binarydata");
- int index = imgstream.read(img2, 0, img.length());
- stm.close();
- response.reset();
- response.setContentType("image/jpg");
- response.getOutputStream().write(img2,0,img2.length);
- response.getOutputStream().flush();
- imgstream.close();
- }
- catch (SQLException e) {
- e.printStackTrace();
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement