Extract BLOB from MySQL & save them anywhere in our pc

[Vinciz]

hi guys... im new in java and i would love to learn some of these...

basically i got a sample code to retrieve the blob from the mysql.
however, i dont really know what to do with these retrieved byte/binary data as i got no idea on how to save them in our pc. For this situation, what i need to do is give the byte/binary data an extension (retrieved from another field in the table) in order to revert back to the original data i had in the blob rite? Any idea/code/links on how to do it? kinda confuse.. thanks in advance

 try { 
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("SELECT blob_data FROM mysql_data_table");
 
if (rs.next()) {
// Get the BLOB from the result set
Blob blob = rs.getBlob("blob_data");
 
// Get the number bytes in the BLOB
long blobLength = blob.length();
 
// Get bytes from the BLOB in a byte array
int pos = 1; // position is 1-based
int len = 10;
byte[] bytes = blob.getBytes(pos, len);
 
// Get bytes from the BLOB using a stream
InputStream is = blob.getBinaryStream();
int b = is.read();
}
} catch (IOException e) {
} catch (SQLException e) {
}
 

[Vinciz]

any1 there able to help? needed it badly..thanks ^^

[tanyali]

hi,

Can you tell me how to retrieve BLOBs from mysql ?
I worked on this for weeks, but found little information about this....
it is very important for me now.

Thank you very much
Looking forward to your reply

my email is :[Removed by moderator (against site rules)]


Xiaohui Li ( Tanya )