Main.java Source code

Introduction

Here is the source code for Main.java

Source

/*
    
Defining the Table: Oracle and MySql
    
create table MyPictures (
   id INT PRIMARY KEY,
   name VARCHAR(0),
   photo BLOB
);
*/

import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Main {
    public static void main(String args[]) throws Exception {
        Connection conn = null;
        byte[] data = getBLOB(01, conn);
    }

    public static byte[] getBLOB(int id, Connection conn) throws Exception {
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        String query = "SELECT photo FROM MyPictures WHERE id = ?";
        try {
            pstmt = conn.prepareStatement(query);
            pstmt.setInt(1, id);
            rs = pstmt.executeQuery();
            rs.next();
            Blob blob = rs.getBlob(3);
            // materialize BLOB onto client
            return blob.getBytes(1, (int) blob.length());
        } finally {
            rs.close();
            pstmt.close();
            conn.close();
        }
    }

}