Materialize binary data onto client : Blob Binary Data JDBC « Database SQL JDBC « Java






  1. Java
  2. Database SQL JDBC
  3. Blob Binary Data JDBC

Materialize binary data onto client

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.JPanel; publicclass DemoDisplayBlobFromDatabase extends JPanel { publicstatic Connection getConnection() throws Exception { String driver = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@localhost:1521:databaseName"; String username = "name"; String password = "password"; Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); return conn; } publicstaticvoid main(String args[]) throws Exception { Connection conn = null; ResultSet rs = null; PreparedStatement pstmt = null; String query = "SELECT blob_column FROM blob_table WHERE id = ?"; try { conn = getConnection(); pstmt = conn.prepareStatement(query); pstmt.setString(1, "0001"); rs = pstmt.executeQuery(); rs.next(); // materialize binary data onto client  java.sql.Blob blob = rs.getBlob(1); } finally { rs.close(); pstmt.close(); conn.close(); } } }








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.Blob: JDBC deals with Binary Data
6.Inserting Image in Database Table
7.Blob and JDBC: Image
8.Blob: Image 2
9.Blob: image 3
10.Insert an Image
11.Retrieve an Image
12.Store and retrieve an object from a table
13.Read CLOBs data from database
14.Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB.
15.Store CLOBs data into database?
16.Getting and Inserting Binary Data into an Database Table
close