java 操作blob_如何在Java中操作BLOB？

这取决于哪种blob包含(图像，视频)和它的扩展。我编写了一个简单的程序来从DB中检索图像并在JSP页面中显示它。希望能帮助到你。

JSP页面

JSP Page

Servlet页面

byte[] imgData = blobDao.getInstance().getPhoto();

response.setContentType("image/gif");

OutputStream o = response.getOutputStream();

o.write(imgData);

o.flush();

o.close();呼叫程序

public byte[] getPhoto() {

byte[] imgData = null;

Blob img = null;

ResultSet rs = null;

Statement stmt = null;

try {

conn = getConnection();

String sqlQ = "SELECT CONTENT_FILE FROM CONTENT where id = 'something';

stmt = conn.createStatement();

rs = stmt.executeQuery(sqlQ);

while (rs.next()) {

img = rs.getBlob("CONTENT_FILE");

imgData = img.getBytes(1, (int) img.length());

}

rs.close();

stmt.close();

conn.close();

} catch (Exception ex) {

ex.printStackTrace();

} finally {

return imgData;

}

}