Hi
Please help me any one. I want solution for display multiple images from oracle database.Using JSP.
here is my code for display one image from database.
Please Any one give me some ideas.
Please help me any one. I want solution for display multiple images from oracle database.Using JSP.
here is my code for display one image from database.
Please Any one give me some ideas.
Code:
<%@ page import ="java.sql.*,java.util.*,java.awt.*,java.io.*" %>
<%
String DomainName ="jdbc:oracle:thin: ";
String UserName=" ";
String PassWord=" ";
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 simage from image Where IMGID=1";
Class.forName("oracle.jdbc.OracleDriver");
Connection cn=DriverManager.getConnection(DomainName,UserName,PassWord);
Statement st=cn.createStatement();
ResultSet rs= st.executeQuery(QS);
OutputStream o=null;
while(rs.next())
{
image =rs.getBytes(1);
response.setContentType("image/gif");
o =response.getOutputStream();
o.write(image);
o.flush();
}
o.close();
out.close();
}
catch(Exception e)
{
System.out.println(e);
}
%>