how to display image with data in jsp page

Hello everyone,
How to display image and there related database value display in jsp page
I have error in tomcat is

Only show image from database but related database record value is not show on jsp page

SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.IllegalStateException: getOutputStream() has already been called for this response
	at org.apache.catalina.connector.Response.getWriter(Response.java:633)
	at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:214)
	at org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:125)
	at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:118)
	at org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:190)
	at org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:123)
	at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:80)
	at org.apache.jsp.ViewBill_jsp._jspService(ViewBill_jsp.java:228)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
	at com.ami.bill.GenerateBill.doPost(GenerateBill.java:88)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

My Jsp file is as follows
SelectCustomer.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@ page import="java.sql.*"%>
<html>
<head>
<title>Select Customer</title>
<link rel="stylesheet" href="styles.css" type="text/css" />

</script>
</head>
<style>
table.main {
	border: appworkspace solid 1px;
	font-size: 0.9em;
	text-align: center;
	border-collapse: collapse;
	style: 600px;
	background-color: #DCDCDC;
}

tr.header {
	font-weight: bold;
	background-color: #ffffef
}

td {
	border: 1px solid appworkspace;
	margin: 0;
	padding: 1px;
}
</style>
<body>
	<br>
	<br>
	<br>
	
	<form name="form" method="post" action="GenerateBill"
		onsubmit='return validator(cid)'>

<%
	String connectionURL = "jdbc:mysql://localhost:3306/meterreading";
	Connection connection = null;
	Statement st = null;
	ResultSet rs = null;
	Class.forName("com.mysql.jdbc.Driver").newInstance ();
	connection = DriverManager.getConnection(connectionURL,"root","root");

%>
		<br> <br>
		<center>
			<table cellpadding="5" cellspacing="5" width="400px" height="30px"
				align="center">
				<tr align="center"
					style="background-color: #B0B0B0; font-weight: bold; color: black;">
					<td align="center"
						style="border: 1px solid appworkspace; margin: 0; padding: 1px; font-size: 103%;">
						Select Customer</td>
				</tr>
				<tr>
					<td><br>
						<table class="main" width="350px" align="center"
							style="border: 0px solid #000000;">
							<tr>
								<td align="left" style="width: 195px;">Customer Id</td>
								<td align="right"><select name="cid" id="cid"
									style="width: 201px;">
										<option value="" selected="selected">Select Customer
											Id</option>
										<%
										String cid=null;
											try {
											
												session.setAttribute("con", connection);
												
												st = connection.createStatement();
											     rs = st.executeQuery("select distinct cid from readingdetails");
												while (rs.next()) {
													 cid = rs.getString("cid");
													
										%>
										<option value="<%=cid%>">
											<%=cid%></option>
										<%
											}
										%>
								</select></td>
							</tr>
							<%
								} catch (Exception e) {
									out.println(e);
								}
							%>

</table> <br> <input type="submit" name="submit"
						value="Generate Bill">
			</table>

</center>
	</form>
	<%
						
		
		rs.close();
		st.close();
		connection.close();
		
	%>
</body>
</html>

My servlet code is as follow:
GenerateBill.java

package com.ami.bill;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import java.sql.*;

public class GenerateBill extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
       
    
    public GenerateBill() {
        super();
        // TODO Auto-generated constructor stub
    }

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html");
		  PrintWriter out = response.getWriter();
		  System.out.println("MySQL Connect Example.");
		  HttpSession sess = request.getSession(true);
		  Connection conn = null;
		  String url = "jdbc:mysql://localhost:3306/";
		  String dbName = "meterreading";
		  String driver = "com.mysql.jdbc.Driver";
		  String userName = "root"; 
		  String password = "root";

String cid= request.getParameter("cid");

Statement st =null;
		  ResultSet rs =null;
		  try 
		  {
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(url+dbName,userName,password);
			System.out.println("Connected to the database");	
			
		    String query = "select * from meterreading.readingdetails where cid='"+cid+"' order by date desc limit 2";
			System.out.println(query);
			st = conn.createStatement();
			rs = st.executeQuery(query);
			Double Previousreading = null,Latestreading = null,Billamt;
		
		    cid="";
		  Blob image = null;
			if(rs.next())
			{
				 image =rs.getBlob("image");
				 System.out.println("get"+image);
			}
			if (rs.first())
			{ 
				cid= rs.getString("cid");
				Latestreading = rs.getDouble("reading");
    			System.out.println(cid+"::Latestreading::"+Latestreading);
				
			}
		if(rs.last())
		{
			cid= rs.getString("cid");
			Previousreading = rs.getDouble("reading");
			System.out.println(cid+"::Previousreading::"+Previousreading);
		}
	        	Billamt = (Latestreading - Previousreading)*2;
				System.out.println("FinalReading"+Billamt);
				
	            sess.setAttribute("cid", cid);
	            sess.setAttribute("Previousreading", Previousreading);
	            sess.setAttribute("Latestreading", Latestreading);
	            sess.setAttribute("Billamt", Billamt);
	            sess.setAttribute("image",image);
	            
	            
			 String nextJSP = "/ViewBill.jsp";
		     RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(nextJSP);
	         dispatcher.forward(request,response);
	         rs.close();
	         st.close();
		     conn.close();
		  }
		  catch (Exception e) {
			// TODO: handle exception
		}

}

And i have genrate a bill to next jsp page

ViewBill.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@ page language="java" import="java.util.*"%>
<%@page import="java.io.*"%>
<%@ page import="java.sql.*"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<TITLE>Bill</TITLE>
<link rel="stylesheet" href="styles.css" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>

tr.header {
	font-weight: bold;
	background-color: #ffffef
}

td {
	border: 1px solid appworkspace;
	margin: 0;
	padding: 1px;
}
</style>
<body>
	<br>
	<br>
	<br>
	<form action="">
		<center>
			<table cellpadding="5" cellspacing="5" width="1000px" height="30px"
				align="center">
				<tr align="center"
					style="background-color: #B0B0B0; font-weight: bold; color: black;">
					<td align="center"
						style="border: 1px solid appworkspace; margin: 0; padding: 1px; font-size: 103%;">
						Bill</td>
				</tr>
				<tr>
					<%
					try {
						ResultSet rs;
						InputStream sImage;
						String id = request.getParameter("cid");
						Connection con = null;
						Class.forName("com.mysql.jdbc.Driver").newInstance();
						con = DriverManager.getConnection(
								"jdbc:mysql://localhost:3306/meterreading", "root",
								"root");
						Statement stmt = con.createStatement();
						String strSql = "select image from readingdetails where cid='"
								+ id + "'";
						System.out.println("inside servlet Sql–>" + strSql);
						rs = stmt.executeQuery(strSql);
						if (rs.next()) {
							byte[] bytearray = new byte[1048576];
							int size = 0;
							sImage = rs.getBinaryStream(1);
							response.reset();
							response.setContentType("image/jpeg");
							while ((size = sImage.read(bytearray)) != -1) {
								response.getOutputStream().write(bytearray, 0, size);
							}
						}
						return;
				
					} catch (Exception e) {
						e.printStackTrace();
					}
				%>
				</tr>
				<tr align="center">
					<td><br>
						<table align="center" class="main" width="900px"
				style="border: 1px solid appworkspace; border-color: black; font-size: 1em; text-align: center;
 border-collapse: collapse; style: 600px; table-layout: auto">
							<tr bgcolor="#B0B0B0">
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;">Customer
									ID</td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;">Previous
									Reading</td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;">Latest
									Reading</td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;">Bill
									Amount</td>
								
		
							</tr>
							<%
								HttpSession sess = request.getSession();
								Object cid = sess.getAttribute("cid").toString();
								Double Previousreading = Double.parseDouble(sess.getAttribute(
										"Previousreading").toString());
								Double Latestreading = Double.parseDouble(sess.getAttribute(
										"Latestreading").toString());
								Double Billamt = Double.parseDouble(sess.getAttribute("Billamt")
										.toString());

//Blob image = (Blob) sess.getAttribute("image");
								/* 	String filename = "image" + cid + ".jpg";
									String imgLen = ""; */
							%>
							<tr align="center" style="">
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;"><%=cid%></td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;"><%=Previousreading%></td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;"><%=Latestreading%></td>
								<td align="center"
									style="border: 1px solid appworkspace; margin: 0; padding: 1px; border-color: black;"><%=Billamt%></td>
							</tr>
							<tr>
								<%-- <img src="ViewBill.jsp?cid=<%=image%>" width="700" height="500"
									align="middle"> --%>
								<br>
						</table> <input type="button" value="Print this page"
						onClick="window.print()"></td>
				</tr>

</table>
		</center>
	</form>
</body>
</html>

Hi sudarshan,
Please CarefullyChooseOneForum before you post. This forum is for questions about Swing and not JSP/Servlets.

I am moving this post to the JSP forum where you can get the right responses.

Note that, we also have a forum for Servlets

A JSP is just a template for an HTML page. And in HTML <img> tags are used to display images.

What does that tell you about the approach that you are using?

Thank you Bear for reply
I want to display image and database value on jsp page but only image is display on jsp page please give me one example which show image and value from database to jsp page

Once again, you don't show an image on a JSP; a JSP is just a template. You show the image in the HTML page that is generated from the JSP with an <img> tag. That means that the image tag had to be able to use a URL to get the image data. Passing the image data to the JSP itself is not useful. Write a servlet that sends the image data separately.

Hello,

This is not good way to store image in DB, store image into file system, and store image url into DB, get image url from DB and

String imageURL = rs.getString("ImageURL");

I JSP <img src="<%=imageURL%>" ......

try with this.