Retrieve Image from database with Java

In this article, I am going to describe how to retrieve images from database (Oracle database) using an java.
Let’s see how to retrieve image from database.
Here is explanation.

Java Program

import java.sql.*;
import java.io.*;

public class RetrieveImage{

 static Connection connection = null;
 static CallableStatement pstat = null;
 static String connectionURL = null;

 public static void main(String[] args) {

  try{
  Class.forName("Oracle Connection Class");
  connection = DriverManager.getConnection("connection url","username", "password");

  PreparedStatement pstat = connection.prepareStatement("Select name,photo from image");

  ResultSet rs = pstat.executeQuery();
  rs.next(); // go to first row
  Blob b = rs.getBlob(2);
  byte[] bt = new byte[(int) b.length()];
  bt = b.getBytes(1, (int)b.length());

  FileOutputStream fout = new FileOutputStream("D:\\test.jpg");
  fout.write(bt);
  fout.close();

  System.out.println("Done");

  connection.close();

  }catch(Exception e){
   e.printStackTrace();
  }

 }

}

Resule: Done