How to display more image from database using JSP

Hi

Please help me i want display all images from my database.
but here my code that will display only one image from database.
But i want all images, any one help me.

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title></title>

</head>

<body bgcolor ='#F5F5F5'>

<font face='Bitstream Vera Sans' color='#CD5C5C'>

<form name="Form1"  >

</font>

<%@ page import ="java.sql.*,java.util.*,java.awt.*,java.io.*" %>
 
<%!
 
%>
 
<%!

      String DomainName ="jdbc:oracle:thin:@192.168.251.28:1521:ss";

      String UserName="sss";

      String PassWord="ssss";
 
      private byte[] getReturnInvoiceDetails(String SId)

      {
 
           byte[] image = new byte[300000];

           try

           {
 
                  int n=0;

                  n =System.in.available();

                  image = new byte[n];

                 Image pic =null;

                  Blob blob =null;
 
                  String QS =" Select shadeimg  from ShadeCardSample Where id =26";
 
                   Class.forName("oracle.jdbc.OracleDriver");

                   Connection cn=DriverManager.getConnection(DomainName,UserName,PassWord);  

                   Statement  st=cn.createStatement();

                   ResultSet  rs= st.executeQuery(QS);
 
                   while(rs.next())

                   {

                     image  =rs.getBytes(1);
 
                   }
 
             }

           catch(Exception e)

           {

               System.out.println(e);

           }
 
        return image;

      }

%>
 
<%
 
    String ID =(String)request.getParameter("IMGID");
 
    byte[] Pic = getReturnInvoiceDetails(ID);

    response.setContentType("image/gif");

    OutputStream o =response.getOutputStream();

    o.write(Pic);

    o.flush();

    o.close();

    out.close();    

%>

</form>

<body>

</html>

Mar 26 '10 #1

Subscribe Post Reply

8264

jkmyoung

2,057

Expert 2GB

You probably need an Vector of arrays of bytes, eg something like:

Expand|Select|Wrap|Line Numbers

 Vector<byte[]> images = new Vector<byte>()
 
...

while(rs.next()) 

{ 

   image = new byte[300000]

   image = rs.getBytes(1); 

   images.add(image);

}

and have your display code iterate through the vector similarly.

Mar 26 '10 #2

selvasoft

Hi jkmyoung

Thanks for your idea. I will try that.

-selvasoft

Mar 27 '10 #3

selvasoft

hi jkmyoung

Am try that. But i cant able to find correct solution please give me any one example.

-selvasoft

Mar 31 '10 #4

Neduncheran

String QS =" Select shadeimg from ShadeCardSample Where id =26";
above query display only one image and change the query

Aug 23 '13 #5

by: Wally | last post by:

I am trying to display images from an Access 2000 database and I get an error "Invalid Parameter Used" when I execute the code line "picBLOB.Image = Image.FromStream(stmBLOBData)" in my Visual...

.NET Framework

Resize image from SQL server and display in asp:image

by: John Scott | last post by:

I am storing an image in an SQL database and have one field as an image datatype. I am also using a webservice to transport data. I want to be able to resize the image and pass back a thumbnail...

.NET Framework

Can you display thumbnails on form?

by: RAllsopp | last post by:

I have a client who would like to have several pictures associated with one system. I have read about storing only the pathname to save OLE overhead and have set-up a form for my client to...

Microsoft Access / VBA

Display an image from access database

by: Eric Keung | last post by:

Hi all, my case is I want to get an image from access database and I just know it's "OLE object" field type at access I also don't know how to insert it into access here is my code and it just...

ASP.NET

Display Images vertically via web service

by: Peter Lapic | last post by:

I have to create a image web service that when it receives an imageid parameter it will return a gif image from a file that has been stored on the server. The client will be an asp.net web page...

ASP.NET

Unable to Display Image from database at runtime

by: den 2005 | last post by:

Hi everyone, Here is code working on..Trying to insert record with a column with Image or VarBinary datatype in sql database from a existing jpeg image file, then retrieve this image from...

ASP.NET

Linking Recordsets In Two Pages To Display Master And Detail Record

by: Objectifnet | last post by:

What I really want to do is to be able to link two pages together using an ID, The table involved displays an image stored on the File Server that has the image details stored in the Database called....

PHP

Using response.write to display system.drawing.image

by: Dave Keen | last post by:

Hi all. Hope you can help me. This should be easy but I can't make this work. In brief I am building a page of thumbnails using images held in a SQLServer 2000 database. I do this by creating...

ASP.NET

trying to display image from mysql database

by: eholz1 | last post by:

Hello Group, Perhaps you can help me. I have a mysql db, that holds images. Images are encoded using base64_decode/encode, etc. Image data seems fine. I have a view.php page that is supposed...

PHP

How to retrive image file from MS access database and display this in another JSPpage

by: amritranjan | last post by:

How to retrive image file from MS access database and display this in another JSPpage -------------------------------------------------------------------------------- This is my Jsp code for...

Java

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

How to display more image from database using JSP

Similar topics