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
    Posts
    1

    Cool Retrieving blob image from database in jsp

    Good day all, ADO, i need your help. i develope a jsp page connected to database.it retrieve all data but it can't retrieve the image along with it.it 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
    Code:
    <HTML>
        <HEAD>
            <TITLE>Database Lookup</TITLE>
        </HEAD>
     
        <BODY>
            <H1>Database Lookup</H1>
            <FORM ACTION="basic.jsp" METHOD="POST">
                Please enter the ID of the publisher you want to find:
                <BR>
                <INPUT TYPE="TEXT" NAME="id">
                <BR>
                <INPUT TYPE="SUBMIT" value="Submit">
            </FORM>
        </BODY>
    <HTML> 
     
    basic.jsp
     
    <%@ page import="java.sql.*" %>
    <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
    
    <HTML>
        <HEAD>
            <TITLE>Fetching Data From a Database</TITLE>
        </HEAD>
    
        <BODY>
            <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(!resultset.next()) {
                    out.println("Sorry, could not find that publisher. ");
                } else {
            %>
    
            <TABLE BORDER="1">
                <TR>
                   <TH>ID</TH>
                   <TH>Name</TH>
                   <TH>City</TH>
                   <TH>State</TH>
                   <TH>picture</TH>
               </TR>
               <TR>
                   <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>
               </TR>
           </TABLE>
           <BR>
           <% 
               } 
           %>
        </BODY>
    </HTML>

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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