Easytolearn: Display Image from Mysql database to JSP page in table

main jsp file where to display image
<th width="207" scope="col"><table width="200" height="208" border="1">
<tr>
<th scope="col">
<img src="LoadImage.jsp" width=200 height=200></th>
</tr>

LoadImage.jsp:
<%--
Document : LoadImage.jsp
Created on : Sep 11, 2014, 6:35:41 PM
Author : JK
--%>

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page import="javax.servlet.http.HttpSession"%>
<%@ page language="java"%>
<%@ page session="true"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%

String ATMV=(String)session.getAttribute("ATMV");

try
{

Class.forName("com.mysql.jdbc.Driver");

java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/jk","root","JK786@$");

Statement st=con.createStatement();

PreparedStatement pre1 = con.prepareStatement("select ImageWithSignature from atm where ATMNO='"+ATMV+"'");
ResultSet rs1=pre1.executeQuery();
while(rs1.next())

{
byte[] bytearray1 = new byte[4096];

int size1=0;

InputStream sImage1;

sImage1 = rs1.getBinaryStream(1);

response.reset();

response.setContentType("image/jpeg");

response.addHeader("Content-Disposition","filename=logo.jpg");

while((size1=sImage1.read(bytearray1))!= -1 )
{

response.getOutputStream().write(bytearray1,0,size1);

}

response.flushBuffer();

sImage1.close();

rs1.close();
}

pre1.close();

con.close();

}
catch(Exception e)
{
out.print("Exception"+e);

}

%>

</body>
</html>

Easytolearn

Thursday, September 11, 2014

Display Image from Mysql database to JSP page in table

No comments:

Post a Comment