oracle 读取blob大字段

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.junit.Test;
public class GetBlobAttachment {
private static String username = "BJWEBWF";
private static String password = "BJWEBWF";
private static Connection conn = null;
private static Statement stmt = null;
private static ResultSet rs = null;
public static Connection getConn() throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager
.getConnection("jdbc:oracle:thin:@192.168.0.172:1521:orcl",
username, password);
return conn;
}
public static void closeConn(){
try {
if (stmt != null) {
stmt.close();
}
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 从数据库中读取blob
* @param dataID
*/
public void getBlob(String dataID){
try {
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery("select file_name,file_cnt from data_attachment where data_id='"+dataID+"'");
if(rs.next()){
Blob blob = rs.getBlob("file_cnt");
String filename = rs.getString("file_name");
File file = new File("d://"+filename);
FileOutputStream output = new FileOutputStream (file);
InputStream input = blob.getBinaryStream();
byte[] buffer = new byte[1024];
int i = 0;
while ((i = input.read(buffer)) != -1) {
output.write(buffer, 0, i);
}
output.close();
input.close();
}
closeConn();
} catch (Exception e) {
e.printStackTrace();
}
}
@Test
public void getTest(){
getBlob("ff808081286b7e7b01288bf034b10056");
}
}