如何在Java中将BLOB转换为字节数组？
您可以使用getBytes()方法将Blob的内容放入字节数组。
示例
import java.awt.Image;
import java.awt.image.BufferedImage;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Arrays;
public class BlobToByteArray {
public static void main(String[] args) throws Exception {
Image image = new BufferedImage(300,400, BufferedImage.TYPE_INT_RGB);
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DB_URL = "jdbc:mysql://localhost/mydb";
String USER = "root";
String PASS = "password";
Connection conn = null;
Statement stmt = null;
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Connecting to a selected database...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("Connected database successfully...");
System.out.println("getting blob.......");
stmt = conn.createStatement();
String sql = "SELECT * FROM sample";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
Blob blob = rs.getBlob("image");
byte [] bytes = blob.getBytes(1l, (int)blob.length());
for(int i=0; i<bytes.length;i++) {
System.out.println(Arrays.toString(bytes));
}
}
}
}输出结果
Connecting to a selected database... Connected database successfully... getting blob....... [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103] [100, 58, 115, 97, 109, 112, 108, 101, 46, 106, 112, 103]
热门推荐
10 最美的留言祝福语简短
11 新年的生日祝福语简短
12 庆祝论坛周年祝福语简短
13 升职祝福语朋友简短精辟
14 母亲说生日祝福语 简短
15 团体年会祝福语简短霸气
16 送花祝福语简短十一朵
17 七一祝福语明信片文案简短
18 员工对同事祝福语简短