- 631 名前：629 [2009/09/13(日) 22:02:18 ]
- ソース：
Connection con = DriverManager.getConnection(url, user, pass);
String query = "select * from test";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
Blob blob = rs.getBlob(3);
InputStream is = blob.getBinaryStream();
FileOutputStream fos = new FileOutputStream("Copy"+rs.getString(2));
BufferedOutputStream bos = new BufferedOutputStream(fos);
int bytes;
byte b[] = new byte[512];
while((bytes = is.read(b)) != -1){
bos.write(b, 0, bytes);
}
}
|
 |
