try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@10.192.21.3:1529:PROD", "apps", "apps"); Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("select file_data from Fnd_Lobs where file_id = 27533272"); rs.next(); oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob(1); InputStream b_in=blob.getBinaryStream(); InputStream in = new FileInputStream("E:/Documents and Settings/Administrator/桌面/crp工作计划v1.3未完成的.xls"); POIFSFileSystem fs = new POIFSFileSystem(in); System.out.println(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }