Getting BLOB Data from a Database Table - Java JDBC

Java examples for JDBC:Binary Data

  1. HOME
  2. Java
  3. JDBC
  4. Binary Data

Description

Getting BLOB Data from a Database Table

Demo Code

import java.io.InputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
  public void main(String[] argv) {
    try {//from  www .  j  ava2 s. c  o  m
      Connection connection = null;
      Statement stmt = connection.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT col_blob FROM mysql_all_table");

      if (rs.next()) {
        Blob blob = rs.getBlob("col_blob");

        long blobLength = blob.length();

        int pos = 1; // position is 1-based
        int len = 10;
        byte[] bytes = blob.getBytes(pos, len);

        InputStream is = blob.getBinaryStream();
        int b = is.read();
      }
    } catch (Exception e) {
    }
  }
}

Related Tutorials