This page discusses - Retrieving the Image from a database Table

Retrieving the Image from a database Table

Consider a case where we want that along with the name of the person and its information, his image should also come. For this it is necessary that there must be his/her image in the database so that whenever needed we can retrieve it.  In this program we are going to retrieve the image from the database table. You can do it very easily after going through this program. 

To get the program working we need to use a doGet() method to write our business logic as it is server side programming so all the processing will be done by the container.  First of all make a class named JdbcSelectingImage, the name of the class should be such that the person can understand what the program is going to do. This class must extend the HttpServlet class which is an abstract method.  Now inside the doGet() method call the method getWriter() of the class PrintWriter. To retrieve an image from the database table our java program need to make a connection with the MySql database. The database can be any, it all depends on the person's choice.  After the connection establishment we will pass a query for retrieving the image from the database table in prepareStatement() method of the Connection object which returns the PreparedStatement object.

As we have to retrieve the image from the database table so there is need of a ResultSet object which will help us to retrieve the image from the database. The ResultSet obiect will be retrieved from calling the executeQuery() method of the PreparedStatement object.. To get the image from the database use getBinaryStream() method of the ResultSet interface.  

The code of the program is given below:

The output of the program is given below:

Download this example.

Related Tags for Retrieving the Image from a database Table:

More Tutorials from this section

• Accept Language and Accept Char set in Servlets
• Accessing Date In Servlet
• Advantages of Servlets over CGI
• The Advantages of Servlets
• To Determine whether the Session is New or Old
• Client Auto Refresh in Servlets
• Context attributes in Servlet
• Context Log Example Using Servlet
• Hit Counter Servlet Example
• Counter in Init() Method
• How to connect to MySql Database from Servlet?
• Dice Roller
• Difference between Servlet 2.5 and Servlet 2.4
• Web Application Directory Structure:
• Displaying Date in Servlet
• Features of Servlets 2.4
• Features of Servlet 2.5
• Form Post
• How to get client's address in a servlet
• How to Get Referer URL Servlet