1.Blob和Clob
Blob:二进制大对象存储单位,最大可以达到4G,通常用来存储图像、音频等二进制信息。
Clob:字符大对象存储单位,最大也是4G,通常用来存储大文本文件。
2.Blob数据的读写
a.Java
读取blob:
String sql_blob = "select blobname from table";
ResultSet rs_blob=null;
rs_blob = dao.queryForResultSet(sql_blob);
byte[] data = null;
if (rs_blob.next()) {
java.sql.Blob blob = rs_blob.getBlob(blobname);
InputStream inStream = blob.getBinaryStream();
try {
long nLen = blob.length();
int nSize = (int) nLen;
data = new byte[nSize];
inStream.read(data);
inStream.close();
} catch (IOException e) {
System.out.println("获取图片数据失败,原因:" + e.getMessage(