public void readFile () { try {
Class.forName
("oracle.jdbc.driver.OracleDriver");
String url
= "jdbc:oracle:thin:@SERVER:1521:DB1";
con = DriverManager.getConnection
(url, "tbpls", "tbpls");
String strSQL = "Select * from
FILE_TEST";
Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery (
strSQL );
while ( rs.next () ){
String fileName = rs.getString
(1);
msg (fileName);
InputStream is =
rs.getBinaryStream (2);
FileOutputStream fos = new
FileOutputStream (new File ( "D:\\Java\\"+fileName ));
byte[] bt = new byte [1024];
int n = 0;
while ( ( n = is.read ( bt) ) !
= -1 ){ fos.write (bt, 0, n); }
is.close ();
fos.close (); }
rs.close();
stmt.close();
con.close();
}
catch (Exception e )
{
msg ("Error :: " + e.toString() );
e.printStackTrace();
}
}
public void msg ( String msg ) {
System.out.println (" " + msg );
}
Class.forName
("oracle.jdbc.driver.OracleDriver");
String url
= "jdbc:oracle:thin:@SERVER:1521:DB1";
con = DriverManager.getConnection
(url, "tbpls", "tbpls");
String strSQL = "Select * from
FILE_TEST";
Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery (
strSQL );
while ( rs.next () ){
String fileName = rs.getString
(1);
msg (fileName);
InputStream is =
rs.getBinaryStream (2);
FileOutputStream fos = new
FileOutputStream (new File ( "D:\\Java\\"+fileName ));
byte[] bt = new byte [1024];
int n = 0;
while ( ( n = is.read ( bt) ) !
= -1 ){ fos.write (bt, 0, n); }
is.close ();
fos.close (); }
rs.close();
stmt.close();
con.close();
}
catch (Exception e )
{
msg ("Error :: " + e.toString() );
e.printStackTrace();
}
}
public void msg ( String msg ) {
System.out.println (" " + msg );
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货