EAS匯出一個單據的所有的附件

@Overridepublic void exportfujian_actionPerformed(ActionEvent e) throws Exception {if(null==editData||null==editData.getId()){MsgBox.showInfo("請先儲存好單據");SysUtil.abort();}String path=getPath();if(null==path){MsgBox.showInfo("請選擇需要儲存檔案的路徑");SysUtil.abort();}exportAttachment(editData.getId().toString(), path);}/** * 擷取檔案需要儲存的檔案路徑 * @return * @throws Exception */private String getPath() throws Exception{String dir = ""; // 預設路徑Component parent = null; // Dialog上級組件JFileChooser chooser = new JFileChooser(dir);javax.swing.filechooser.FileFilter dirFilter = new javax.swing.filechooser.FileFilter() {public boolean accept(File f) {return f.isDirectory();}public String getDescription() {return "";}};chooser.setFileFilter(dirFilter);chooser.setFileSelectionMode(JFileChooser.SAVE_DIALOG);if (chooser.showOpenDialog(parent) == JFileChooser.APPROVE_OPTION) {dir = chooser.getSelectedFile().getAbsolutePath();return dir;}return null;}/** * 一鍵匯出該單據的相關附件 * @param id 單據對應的id * @param path 需要匯出儲存檔案的路徑 * @throws Exception */public static void exportAttachment(String id,String path)throws Exception{StringBuffer sb=new StringBuffer();sb.append("/*dialect*/ ");sb.append(" select attachment.fname_l2 name, ");sb.append("       attachment.fsimplename type, ");sb.append("       attachment.ffile  contens  ");sb.append("from T_BAS_Attachment attachment,");sb.append("     T_BAS_BoAttchAsso temp ");sb.append("where attachment.fid=temp.fattachmentid ");sb.append("      and attachment.ffile is not null ");sb.append("      and temp.fboid='").append(id).append("'");IRowSet rs=DataUtils.clientExecuteSQL(sb.toString());while(rs.next()){String fileName=rs.getString("name");String types=rs.getString("type");String fullName=path+"/"+fileName+"."+types;File f=new File(fullName);int i=0;while(f.exists()){fullName=path+"/"+fileName+"("+(++i)+")."+types;f=new File(fullName);}Blob contends=rs.getBlob("contens");InputStream in=contends.getBinaryStream();FileOutputStream fos=new FileOutputStream(fullName);storeAttch(fos,in);}}/** * 把從資料庫取出來的BlobObject Storage Service到應用目錄中來。通過Blog對象的.getBinaryStream()方法擷取二進位的輸入資料流 * @param ops 位元組輸出資料流 * @param ips 位元組輸入資料流 */public static void storeAttch(OutputStream ops,InputStream ips){BufferedInputStream bis=new BufferedInputStream(ips);BufferedOutputStream bos=new BufferedOutputStream(ops);byte[] buf=new byte[1024*600];int len=0;try {while((len=bis.read(buf))!=-1){bos.write(buf, 0, len);}} catch (IOException e) {System.out.println("流檔案寫入、輸出異常" +ips+ops);e.printStackTrace();}finally{if(bis!=null){try {bis.close();} catch (IOException e) {System.out.println("輸入資料流檔案關閉異常" +ips);e.printStackTrace();}}if(bos!=null){try {bos.close();} catch (IOException e) {System.out.println("輸出資料流檔案關閉異常"+ops);e.printStackTrace();}}}}