[size=large]import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class TestBlobRead {
public static void main(String[]args){
String filename=null;
if(args.length!=1){
System.out.println("use project filename");
return;
}else{
filename=args[0];
}
PreparedStatement ps=null;
ResultSet rs=null;
Connection con=null;
Blob b=null;
int id=1;
try{
con=jdbcUtil.getConnection();
con.setAutoCommit(false);
//读指定id的Blob
String sql="select fileContant from t_blob where id =?";
ps=con.prepareStatement(sql);
ps.setInt(1,id);
rs=ps.executeQuery();
if(rs.next()){
b=rs.getBlob(1);
}
//将blob对象中的数据导入文件中。
InputStream in =b.getBinaryStream();
OutputStream out =new FileOutputStream(filename);
int a=0;
int c=0;
while((a=in.read())!=-1){
out.write(a);
if(++c%1024==0){
System.out.println("已经读了"+c/1024 +"kb");
}
}
in.close();
out.close();
}catch(Exception e){
e.printStackTrace();
try{
con.rollback();
}catch(Exception el){
el.printStackTrace();
}
}finally{
jdbcUtil.release(rs, ps, con);
}
}
}
[/size]
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class TestBlobRead {
public static void main(String[]args){
String filename=null;
if(args.length!=1){
System.out.println("use project filename");
return;
}else{
filename=args[0];
}
PreparedStatement ps=null;
ResultSet rs=null;
Connection con=null;
Blob b=null;
int id=1;
try{
con=jdbcUtil.getConnection();
con.setAutoCommit(false);
//读指定id的Blob
String sql="select fileContant from t_blob where id =?";
ps=con.prepareStatement(sql);
ps.setInt(1,id);
rs=ps.executeQuery();
if(rs.next()){
b=rs.getBlob(1);
}
//将blob对象中的数据导入文件中。
InputStream in =b.getBinaryStream();
OutputStream out =new FileOutputStream(filename);
int a=0;
int c=0;
while((a=in.read())!=-1){
out.write(a);
if(++c%1024==0){
System.out.println("已经读了"+c/1024 +"kb");
}
}
in.close();
out.close();
}catch(Exception e){
e.printStackTrace();
try{
con.rollback();
}catch(Exception el){
el.printStackTrace();
}
}finally{
jdbcUtil.release(rs, ps, con);
}
}
}
[/size]