在JDBC4.0推出后，它的从多的特性正在受到广泛地关注。下面通过本文给大家介绍JDBC4.0操作Oracle中BLOB类型的数据的方法。
需要的jar包
使用ojdbc6.jar
在/Meta-INF/MANIFEST.MF里可以看到Specification-Version: 4.0
建表
sql;">
create sequence seq_blobmodel_id start with 1 increment by 1 nocache;
create table blobmodel
(
blobid number(10) primary key not null,image blob
);
/**
- 将图片文件存入数据库
- @throws sqlException
- @throws IOException
*/
public int writeBlob(String path) throws sqlException,IOException{
int result = 0;
String sql = "insert into blobmodel(blobid,image) values(seq_blobmodel_id.nextval,?)";
//1.创建Blob
Blob image = DBHelper.getConnection().createBlob();
//2.将流放入blob
OutputStream out = image.setBinaryStream(1);
//3.读取图片,并写入输出流
FileInputStream fis = new FileInputStream(path);
byte []buf = new byte[1024];
int len = 0;
while((len=fis.read(buf))!=-1){
out.write(buf,len);
}
result = DBHelper.executeUpdate2(sql,new Object[]{image});//自己简单封装了jdbc操作
fis.close();
out.close();
return result;
}
将文件从数据库中读出
sql;">
/**
将数据库中的图片文件读出来
@throws sqlException
@throws IOException
*/
public void readBlob() throws sqlException,IOException{
String sql = "select image from blobmodel where blobid=?";
DBHelper.getConnection();//
ResultSet rs = DBHelper.executeQuery(sql,new Object[]{1});
while(rs.next()){
Blob image = rs.getBlob(1);
InputStream is = image.getBinaryStream();
BufferedInputStream bis = new BufferedInputStream(is);
String path = "img/"+new Date().getTime()+".jpg";//指定输出的目录为项目下的img文件夹
BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(path));
byte []buf = new byte[1024];
int len = 0;
while((len=bis.read(buf))!=-1){
bos.write(buf,len);
}
bos.close();
bis.close();
}
}
*/
public void readBlob() throws sqlException,IOException{
String sql = "select image from blobmodel where blobid=?";
DBHelper.getConnection();//
ResultSet rs = DBHelper.executeQuery(sql,new Object[]{1});
while(rs.next()){
Blob image = rs.getBlob(1);
InputStream is = image.getBinaryStream();
BufferedInputStream bis = new BufferedInputStream(is);
String path = "img/"+new Date().getTime()+".jpg";//指定输出的目录为项目下的img文件夹
BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(path));
byte []buf = new byte[1024];
int len = 0;
while((len=bis.read(buf))!=-1){
bos.write(buf,len);
}
bos.close();
bis.close();
}
}
以上所述是小编给大家介绍的使用JDBC4.0操作Oracle中BLOB类型的数据的方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对编程之家网站的支持！
原文链接：https://www.f2er.com/oracle/65044.html