导出BLOB为文件

public class BlobTest {
	Connection conn= null;
	Statement st = null;
	ResultSet rs=null;
	
	public void test(){
		conn = Conn.getConnection();
		try {
			st = conn.createStatement();
			rs = st.executeQuery("select * from OFFICE_WORKFLOWATTACHMENT");
			while (rs.next()){
				String name = rs.getString("ATTACHMENT_NAME");
				Blob blob = rs.getBlob("ATTACHMENT_CONTENT");
				if(blob!=null && blob.length()>0){
					FileOutputStream fout;
					try {
						fout = new FileOutputStream("c:/"+name);
						try {
							fout.write(blob.getBytes(1, (int)blob.length()));
							fout.flush();
						    fout.close();
						} catch (IOException e) {
							// TODO Auto-generated catch block
							e.printStackTrace();
						}
				       
					} catch (FileNotFoundException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
				
		        
			}
			rs.close();
		    st.close();
            conn.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}