Displaying image and text together from database

Hi,

I am trying to display image and its respective name from the database. The code is:

The above code is showing name but image is not getting displayed. If I use output stream (as commented), then name is not displayed. WHat should I do to make both of them appear?

The URL for the <img> tag needs to be to a servlet that sends the image data. Having the image blob in the JSP is not useful. Remember, JSP just creates HTML. When you write the page in HTML do you give the image tag a blob of data? No. You give it the URL of the image.

Bear Bibeault wrote:The URL for the <img> tag needs to be to a servlet that sends the image data. Having the image blob in the JSP is not useful. Remember, JSP just creates HTML. When you write the page in HTML do you give the image tag a blob of data? No. You give it the URL of the image.

Hi,

I am trying to do the same as suggested by you...:

This is my servlet:

protected void handleRequest(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		
		System.out.println("Servlet called");
		ResultSet rows = null;
		ServletOutputStream out = response.getOutputStream();
		try {
			Connection conn = null;
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			conn = (Connection) DriverManager
					.getConnection("jdbc:mysql://10.76.162.35:3306/pichall",
							"root", "root123");
			PreparedStatement preparedStatement = null;

String select = "Select * from picture where categoryId = ? order by time desc limit ?, 1";
			preparedStatement = (PreparedStatement) conn
					.prepareStatement(select); // create a statement
			preparedStatement.setInt(1,
					Integer.parseInt(request.getParameter("cat"))); // set input
																	// parameter
																	// 1
			preparedStatement.setInt(2,
					Integer.parseInt(request.getParameter("pos")));
			rows = preparedStatement.executeQuery();
			if (rows.next()) {
				Blob blob = rows.getBlob(2);
				byte[] image = blob.getBytes(1, (int) blob.length());
				OutputStream outputStream = response.getOutputStream();
				outputStream.write(image);
			} else {
				response.setContentType("TEXT/HTML");
				out.println("<html><head><title>Display out the blob image</title></head>");
				out.println("<body><h4><font color = 'red'>Image not founde for the given id</font></h4></body></html>");
				return;
			}

} catch (Exception e) {
			response.setContentType("TEXT/HTML");
			out.println("<html><head><title>Unable To Display image</title></head>");
			out.println("<body><h4><font color='red'>Image Display Error="
					+ e.getMessage() + "</font></h4></body></html>");
			return;

}

And i am calling it from jsp like this

with mapping in web.xml as

But even servlet is not being called...what i am doing wrong?

ksh agarwal wrote:And i am calling it from jsp like this

<img />

Be sure to disable HTML when you post HTML code or your image tags will be empty.

Please repost with the real code.

Bear Bibeault wrote:

ksh agarwal wrote:And i am calling it from jsp like this

<img />

Be sure to disable HTML when you post HTML code or your image tags will be empty.

Please repost with the real code.

Sorry...my mistake...the code is

PLease consider them under tags <> as I am not able to display those with tags...

ksh agarwal wrote: as I am not able to display those with tags...

Click the disable HTML checkbox when posting.

You need to prefix the url to the image with the context path. Use: ${pageContext.request.contextPath}

Bear Bibeault wrote:

ksh agarwal wrote:And i am calling it from jsp like this

<img />

Be sure to disable HTML when you post HTML code or your image tags will be empty.

Please repost with the real code.

Hi,

The image tag is

Bear Bibeault wrote:You need to prefix the url to the image with the context path. Use: ${pageContext.request.contextPath}

Hi,

You mean to say this...

But even then servlet is not being called. Its first line which is sysout is not getting executed. I have seen examples and people are actually using this approach only.

That URL does not match the pattern you specified in the deployment descriptor.

Bear Bibeault wrote:That URL does not match the pattern you specified in the deployment descriptor.

Hi,

I have changed the mapping to

Servlet was not being called unitl I changed from handleRequest to doGet in servlet.

Are you setting the content headers on the response correctly? Is the image data correct?

Likely easier to debug if you just type the URL for the image into the browser's address bar.

Use the browser tools to inspect the response for correctness.

Bear Bibeault wrote:Are you setting the content headers on the response correctly? Is the image data correct?

Likely easier to debug if you just type the URL for the image into the browser's address bar.

Use the browser tools to inspect the response for correctness.

Hi,

I am able to show image now. Actually parameters were not getting passed properly in the request. Now its all done....thank you very much for your help and time :)

:thumbup:

Now work on stopping using scriptlets in your JSPs!