Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page import="java.sql.*"%>
- <%@ page import="java.io.*"%>
- <% Blob image = null;
- java.sql.Connection con = null;
- byte[ ] imgData = null ;
- java.sql.Statement stmt = null;
- java.sql.ResultSet rs = null;
- try {
- System.out.println("DisplayBlob.jsp request Parameter "+request.getParameter("imgName"));
- con = java.sql.DriverManager.getConnection("jdbc:oracle:thin:@ip:1521:sid","userName", "password");
- stmt = con.createStatement();
- rs = stmt.executeQuery("SELECT blobObj FROM ImageBlobTable");
- if (rs.next()) {
- image = rs.getBlob(1);
- imgData = image.getBytes(1,(int)image.length());
- } else {
- out.println("Display Blob Example");
- out.println("image not found for given id>");
- return;
- }
- response.setContentType("image/gif");
- OutputStream o = response.getOutputStream();
- o.write(imgData);
- o.flush();
- o.close();
- } catch (Exception e) {
- out.println("Unable To Display image");
- out.println("Image Display Error=" + e.getMessage());
- return;
- } finally {
- try {
- rs.close();
- stmt.close();
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement