java读取blob字段 java解析blob字段

Java读取Oracle BLOB字段

/** 

 * JDBC连接数据库并写入BLOB字段 

 * @author DaHai 

 * 

 */ 

public class OracleBlob { 

 public static void main(String[] args) { 

 OracleBlob ob= new OracleBlob (); 

 ob.insert("c:\\Test.txt"); 

 } 


 public Connection getConnection() { 

 Connection conn = null; 

 try { 

 Class.forName("oracle.jdbc.driver.OracleDriver"); 

 conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test", "scott", "tigger"); 

 } catch (ClassNotFoundException e) { 

 e.printStackTrace(); 

 } catch (SQLException e) { 

 e.printStackTrace(); 

 } 

 return conn; 

 } 


 public void insert(String str) { 

 Connection conn = getConnection(); 

 PreparedStatement pstmt = null; 

 ResultSet rs = null; 

 try { 

 conn.setAutoCommit(false); 

 pstmt = conn.prepareStatement("insert into test (wygjz,wdmc,wd) values (?,?,empty_blob())"); 

 pstmt.setString(1, "163"); 

 pstmt.setString(2, "dahai"); 

 pstmt.executeUpdate(); 

 pstmt = conn.prepareStatement("select wd from test where wygjz=163 for update"); 

 rs = pstmt.executeQuery(); 

 while (rs.next()) { 

 oracle.sql.BLOB blob = (oracle.sql.BLOB)rs.getBlob(1); 

 OutputStream os = blob.getBinaryOutputStream(); 

 BufferedInputStream bis = new BufferedInputStream(new FileInputStream(str)); 

 byte[] buf = new byte[2048]; 

 int len = 0; 

 if ((len = bis.read(buf)) != -1) { 

 os.write(buf, 0, len); 

 os.flush(); 

 } 

 os.close(); 

 bis.close(); 

 } 

 conn.commit(); 

 } catch (FileNotFoundException e) { 

 e.printStackTrace(); 

 } catch (SQLException e) { 

 try { 

 if(conn!=null){ 

 conn.rollback(); 

 } 

 } catch (SQLException e1) { 

 e1.printStackTrace(); 

 } 

 e.printStackTrace(); 

 } catch (IOException e) { 

 e.printStackTrace(); 

 }finally{ 

 try { 

 if(rs!=null){ 

 rs.close(); 

 rs = null; 

 } 

 } catch (SQLException e) { 

 e.printStackTrace(); 

 } 

 try { 

 if(pstmt!=null){ 

 pstmt.close(); 

 pstmt = null; 

 } 

 } catch (SQLException e) { 

 e.printStackTrace(); 

 } 

 try { 

 if(conn!=null){ 

 conn.close(); 

 conn = null; 

 } 

 } catch (SQLException e) { 

 e.printStackTrace(); 

 } 

 } 

 } 


}

如果用Spring配置的话,可以将上面的getConnection()方法替换成

public Connection getConnection(){ 

 Connection conn = null; 

 ApplicationContext ctx = new ClassPathXmlApplicationContext("dbconfigs.xml"); 

 DataSource ds = (DataSource) ctx.getBean("dataSource"); 

 try{ 

 conn = ds.getConnection(); 

 if(conn != null){ 

 System.out.println("数据库连接成功！"); 

 } 


 }catch(SQLException e){ 

 e.printStackTrace(); 

 } 

 return conn; 

 }