Read BLOBs data from database : Blob Clob « Database « Java Tutorial






import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Main {
  static String url = "jdbc:oracle:thin:@localhost:1521:javaDemo";
  static String username = "username";
  static String password = "welcome";
  public static void main(String[] args) throws Exception {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection(url, username, password);

    String sql = "SELECT name, description, image FROM pictures ";
    PreparedStatement stmt = conn.prepareStatement(sql);
    ResultSet resultSet = stmt.executeQuery();
    while (resultSet.next()) {
      String name = resultSet.getString(1);
      String description = resultSet.getString(2);
      File image = new File("D:\\java.gif");
      FileOutputStream fos = new FileOutputStream(image);

      byte[] buffer = new byte[1];
      InputStream is = resultSet.getBinaryStream(3);
      while (is.read(buffer) > 0) {
        fos.write(buffer);
      }
      fos.close();
    }
    conn.close();
  }
}








20.22.Blob Clob
20.22.1.Getting and Inserting Binary Data into an Database Table
20.22.2.Store BLOBs data into database
20.22.3.Read BLOBs data from database
20.22.4.Blob and Clob data type
20.22.5.Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB.
20.22.6.Store CLOBs data into database?
20.22.7.Read CLOBs data from database
20.22.8.Insert an Image
20.22.9.Retrieve an Image