DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Retrieving blob image from database in jsp

  1. #1
    Join Date
    Jan 2010

    Cool Retrieving blob image from database in jsp

    Good day all, ADO, i need your help. i develope a jsp page connected to retrieve all data but it can't retrieve the image along with only retrieve the image link.I tried manipulating datatype blob by setting (Blob bl =resultset(n)
    byte [] picture = bl.getBytes(0)),but it prompt an error and i dont know what to do,Please you can help me by also fixing it for me in the code.secondly i want that image size to be width=200,height=200 on display from database.Please sir how do i achieve it.Thanks for your kindness and time spent in trying to help the poor boy like me. Below is my code
            <TITLE>Database Lookup</TITLE>
            <H1>Database Lookup</H1>
            <FORM ACTION="basic.jsp" METHOD="POST">
                Please enter the ID of the publisher you want to find:
                <INPUT TYPE="TEXT" NAME="id">
                <INPUT TYPE="SUBMIT" value="Submit">
    <%@ page import="java.sql.*" %>
    <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
            <TITLE>Fetching Data From a Database</TITLE>
            <H1>Fetching Data From a Database</H1>
                Connection connection = DriverManager.getConnection(
                    "jdbc:odbc:data", "YourName", "password");
                Statement statement = connection.createStatement();
                String id = request.getParameter("id");  
                ResultSet resultset = 
                    statement.executeQuery("select * from Publishers where pub_id = '" + id + "'") ; 
                if(! {
                    out.println("Sorry, could not find that publisher. ");
                } else {
            <TABLE BORDER="1">
                   <TD> <%= resultset.getString(1) %> </TD>
                   <TD> <%= resultset.getString(2) %> </TD>
                   <TD> <%= resultset.getString(3) %> </TD>
                   <TD> <%= resultset.getString(4) %> </TD>
                   <TD> <%= resultset.getBlob(5) %> </TD>

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Does this help.

Similar Threads

  1. Replies: 0
    Last Post: 01-21-2009, 05:36 PM
  2. Replies: 1
    Last Post: 12-17-2008, 03:24 PM
  3. Replies: 0
    Last Post: 01-02-2001, 08:45 AM
  4. saving an Image to Database
    By Oteniya O.G in forum VB Classic
    Replies: 0
    Last Post: 11-14-2000, 08:41 PM
  5. How can I store an image file to Database?
    By Ma Jindong in forum VB Classic
    Replies: 1
    Last Post: 07-18-2000, 09:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center