<%--
Document : saveim2
Created on : Dec 9, 2011, 12:04:19 AM
Author : Administrator
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language="java" session="true"
import= "java.awt.image.BufferedImage,java.io.ByteArrayOutputStream,java.io.InputStream,java.sql.Blob,java.sql.Connection,
java.sql.ResultSet,javax.swing.ImageIcon,java.sql.*" %>
JSP Page
retrive image from database.
<%
try
{
String str = request.getParameter("index");
String imageNumber = request.getParameter("imageno");
String query = null;
Connection con = connect.getConnection();
Statement stmt = con.createStatement();
if(str != null)
{
query = "SELECT image from t_newsimage where news ='"+str+"' order by sno desc"; // getting image by news number
}
else if(imageNumber != null)
{
query = "SELECT image from t_newsimage where sno ='"+imageNumber+"'"; // getting image by serial number
}
out.println(query);
ResultSet rs = con.createStatement().executeQuery(query);
if(rs.next()) {
byte[] bytearray = new byte[4096];
int size=0;
InputStream image;
image = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/jpg");
while((size=image.read(bytearray))!= -1 ){
response.getOutputStream().write(bytearray,0,size);
}
out.println("
");
while((size=image.read(bytearray))!= -1 ){
response.getOutputStream().write(bytearray,0,size);
}
response.flushBuffer();
rs.close();
}
}
catch (Exception exc)
{ out.println(exc);
}
%>