JDBC- Retrieve IMAGE from database by using PreparedStatement's executeQuery, ResultSet's getBlob method - using BLOB data type - in java



In this tutorial we will learn how to Retrieve IMAGE from database by using PreparedStatement's executeQuery, ResultSet's getBlob method - using BLOB data type in java jdbc.



--Before executing java program >
Execute previous program to Insert image in database.


Example/ Full Programs JDBC- Retrieve image from database by using PreparedStatement's executeQuery method, using BLOB data type in java
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/** Copyright (c), AnkitMittal JavaMadeSoEasy.com */
public class RetrieveImageExample {
   public static void main(String... arg) {
          Connection con =null;
          PreparedStatement prepStmt = null;
          ResultSet rs =null;
          FileOutputStream fout =null;
          String retrievedImagePath="c:/myImgRetrieved.png";
          try {
                 // registering Oracle driver class
                 Class.forName("oracle.jdbc.driver.OracleDriver");
                 // getting connection
                 con = DriverManager.getConnection(
                              "jdbc:oracle:thin:@localhost:1521:orcl",
                              "ankit", "Oracle123");
                 System.out.println("Connection established successfully!");
                
                 //java.sql.Blob will be used to store file retrieved from database.
                 Blob blob = null;
         
                 prepStmt=con.prepareStatement("select ID, IMAGE_COL from TEST_IMG "
                                                                    +"where ID=1");

                 //execute select query
                 rs=prepStmt.executeQuery();
                 while(rs.next()){
                   blob=rs.getBlob("IMAGE_COL");//Now, blob contains the file retrieved from database.
                 }
                
                 fout=new FileOutputStream(retrievedImagePath);
                 //get bytes from blob object and write those bytes in output file
                 fout.write(blob.getBytes(1,(int)blob.length() ));
                 System.out.println("Image retrieved from database at > " +retrievedImagePath);                                     
                
          } catch (Exception e) {
                 e.printStackTrace();
          }
          finally{
                 try {
                       if(fout!=null) fout.close(); //close file
                       if(rs!=null) rs.close(); //close resultSet
                       if(prepStmt!=null) prepStmt.close(); //close PreparedStatement
                       if(con!=null) con.close(); // close connection
                 } catch (SQLException e) {
                       e.printStackTrace();
                 } catch (IOException e) {
                       e.printStackTrace();
                 }
          }
   }
}
/*OUTPUT
Connection established successfully!
Image retrieved from database at > c:/myImgRetrieved.png
*/


Must read : FILE - Storing in and retrieving out from database

So in this tutorial we learned how to Retrieve IMAGE from database by using PreparedStatement's executeQuery, ResultSet's getBlob method - using BLOB data type in java jdbc.


RELATED LINKS>

java.sql.PreparedStatement - using executeUpdate  and executeQuery methods - CREATE, SELECT, INSERT, UPDATE and DELETE

JDBC tutorial program- Insert/Store/save FILE in database

JDBC tutorial program- Batch PreparedStatement example- Execute INSERT query(DML command) using PreparedStatement's addBatch() and executeBatch() methods in java


Execute database STORED PROCEDURE - IN parameter, OUT parameter and IN OUT parameter || call FUNCTION from java jdbc

Difference between CLOB and CLOB data type in Oracle


No comments:

Post a Comment