Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB. : Blob Binary Data JDBC « Database SQL JDBC « Java






Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB.

  

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

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";
    Class.forName(driverName);

    String serverName = "127.0.0.1";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    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();
    }
  }
}

   
    
  








Related examples in the same category

1.Read BLOBs data from database
2.Store BLOBs data into database
3.Insert picture to MySQL
4.Demo Display Binary Data From Database
5.Materialize binary data onto client
6.Blob: JDBC deals with Binary Data
7.Inserting Image in Database Table
8.Blob and JDBC: Image
9.Blob: Image 2
10.Blob: image 3
11.Insert an Image
12.Retrieve an Image
13.Store and retrieve an object from a table
14.Read CLOBs data from database
15.Store CLOBs data into database?
16.Getting and Inserting Binary Data into an Database Table