BlobSelect.java Source code

Introduction

Here is the source code for BlobSelect.java

Source

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

import javax.swing.JPanel;

public class BlobSelect extends JPanel {
    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("photo");
            // materialize BLOB onto client
            return blob.getBytes(1, (int) blob.length());
        } finally {
            rs.close();
            pstmt.close();
            conn.close();
        }
    }

}