3
How to retrive image file from MS access database and display this in another JSPpage
--------------------------------------------------------------------------------
This is my Jsp code for image upload in database:
-----------Upload.jsp----------------
<html>
<head>
<title>Accoun t Details </title>
</head>
<body bgproperties="f ixed" bgcolor="#CCFFF F">
<form method="POST" action="UploadP icture.jsp" enctype="multif orm/form-data">
<%! int update=0; %>
<%@ page import="java.ut il.*" %>
<%@ page import="java.sq l.*" %>
<%@ page import="java.te xt.*" %>
<%@ page import="java.sq l.Date" %>
<%@ page import="java.io .*"%>
<%@ page language = "java" %>
<%
try
{
String ct="3";
String path;
File image=new File(request.ge tParameter("upl oad"));
path=request.ge tParameter("upl oad");
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con = DriverManager.g etConnection("j dbc:odbc:itPlus Electronics","" ,"");
PreparedStateme nt pstmt=con.prepa reStatement("in sert into graphics values(?,?,?)") ;
pstmt.setString (2,path);
pstmt.setString (3,ct);
InputStream is=new FileInputStream (path);
pstmt.setBinary Stream(1, is, (int)(image.len gth()));
int s=pstmt.execute Update();
if(s>0)
{
out.println("Up loaded");
}
else
{
%>
unsucessfull
<%}
is.close();
pstmt.close();
}
catch(Exception e)
{
}%>
</p>
<p><br>
<img src="UploadedPi cture.jsp">imag e</img>
<p></p>
</form>
</body>
</html>
-------------------------------------------------------------
My database name is itPlusElectroni cs and the table name is "graphics".
I have seen as a result of the above code that the image is stored in database as "Long binary data". and database table is look like as follows-------
picture path id
Long binary data D:\AMRIT\1-1-Picture.jpg 3
------------------------------------------------------------------------------
To retrive and display i use this JSP code as--
------------------------UploadedPicture .jsp------------------------------
<html>
<head>
<title>Accoun t Details </title>
</head>
<body bgproperties="f ixed" bgcolor="#CCFFF F">
<%! int update=0; %>
<%@ page import="java.ut il.*" %>
<%@ page import="java.sq l.*" %>
<%@ page import="java.te xt.*" %>
<%@ page import="java.io .*"%>
<%@ page language = "java" %>
<%@page import="javax.s ervlet.ServletO utputStream"%>
<%
try
{
String path;
path=request.ge tParameter("upl oad1");
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con = DriverManager.g etConnection("j dbc:odbc:itPlus Electronics","" ,"");
PreparedStateme nt pst = con.prepareStat ement("SELECT * FROM graphics WHERE id ='3'");
// pst.setString(3 , id);
ResultSet rs = pst.executeQuer y();
path=rs.getStri ng("path");
if(rs.next()) {
byte[] bytearray = new byte[4096];
int size=0;
InputStream sImage;
sImage = rs.getBinaryStr eam(1);
response.reset( );
response.setCon tentType("image/jpeg");
response.addHea der("Content-Disposition","f ilename=path");
while((size=sIm age.read(bytear ray))!= -1 )
{
response.getOut putStream().wri te(bytearray,0, size) ;
}
response.flushB uffer();
sImage.close();
rs.close();
}
}
catch(Exception e)
{
}
%>
</body>
</html>
------------------------------------------------------------------------------
Now after browsing a jpg image file from client side and pressing submit button ;
I am unable display the image in the Upload.jsp file.Though I use
<img src="UploadedPi cture.jsp">imag e</img> HTML code in Upload.jsp
file .
Now I am unable to find out the mistakes which is needed for displaying the picture in the Upload.jsp page..
If any one can help with the proper jsp code to retrive and display the image ,please please help me !!!!!!!!!!!!!!! !!!!!!!!!!!
