Win a copy of Murach's Python Programming this week in the Jython/Python forum!
    Bookmark Topic Watch Topic
  • New Topic

How to display an image that is stored in a table in Mysql , on a JSP page  RSS feed

 
pavan manthan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Report post to moderator
Sorry for reposting this question. I put it in the wrong section at first. I am sure this belongs to the JSP section :)

Hi,
As the sub says .. I have been out of luck today trying to display an image that is inserted into a mysql table on a JSP page. The JSp code to do this is given below. the output of this page when i run it : displays the URL of the page i.e
http://localhost:8080/abc/jsp/helloworld.jsp as an image instead of the actual image from the table. Please help me before I get crazy trying to get this thing working :)

<%@ page language="java"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@page import="com.pav.DAO.*" %>
<%@page import="com.pav.forms.*" %>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%
Connection dbconn = null;
PreparedStatement psmt = null;
ResultSet res=null;
InputStream sImage = null;
UserRequirementsForm frm = new UserRequirementsForm();
try
{
dbconn= dBInteraction.getConn();
psmt=dbconn.prepareStatement("SELECT images from photos WHERE userFirstName = ?");
psmt.setString(1,"rrr");
res=psmt.executeQuery();
response.setContentType("image/gif");
OutputStream o = response.getOutputStream();
res.next();
Blob b = res.getBlob(1);
byte[] bytearray = new byte[(int)b.length()];
int size=0;
sImage = res.getBinaryStream(1);
while((size=sImage.read(bytearray))!= -1)
{
o.write(bytearray);
}
response.flushBuffer();
sImage.close();

}
catch(SQLException sqle)
{
sqle.printStackTrace();

}
catch(Exception exe)
{
exe.printStackTrace();
}
%>

</body>
</html>


Thank You,
Pavan
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65833
134
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please do not post the same question more than once. If you incorrectly post a question in the wrong section, please ask a moderator to move the post for you.
 
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!