使用ADF组件实现附件上传下载功能

来源：互联网发布：mac显示桌面的快捷键编辑：程序博客网时间：2024/05/17 23:16

创建数据表的sql语句

CREATE TABLE BLOB_TABLE( ID NUMBER(4) NOT NULL, FILE_NAME VARCHAR2(4000) NOT NULL, UPLOAD_DATE DATE, STORED_FILE BLOB NOT NULL);ALTER TABLE BLOB_TABLEADD CONSTRAINT BLOB_TABLE_PK PRIMARY KEY( ID) ENABLE;CREATE SEQUENCE SEQ_BLOB_TABLE INCREMENT BY 1 START WITH 1 MINVALUE 1 ;CREATE OR REPLACE TRIGGER trg_blob_tableBEFORE INSERT ON blob_tableFOR EACH ROWBEGIN SELECT seq_blob_table.NEXTVAL INTO :NEW.id FROM dual;END;/

创建上传附件页面，代码如下

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><%@ page contentType="text/html;charset=windows-1250"%><%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%><%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%><%@ taglib uri="http://myfaces.apache.org/trinidad/html" prefix="trh"%><%@ taglib uri="http://myfaces.apache.org/trinidad" prefix="tr"%><f:view> <trh:html binding="#{UploadingBean.html1}" id="html1"> <trh:head title="uploading" binding="#{UploadingBean.head1}" id="head1"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1250"/> </trh:head> <trh:body binding="#{UploadingBean.body1}" id="body1"> <tr:messages binding="#{UploadingBean.messages1}" id="messages1"/> <tr:form binding="#{UploadingBean.form1}" id="form1" usesUpload="true"> <tr:panelBox binding="#{UploadingBean.panelBox1}" id="panelBox1" text="Upload new file"> <trh:rowLayout binding="#{UploadingBean.rowLayout1}" id="rowLayout1" halign="center"> <tr:inputFile binding="#{UploadingBean.inputFilePath}" id="inputFilePath" required="true" valueChangeListener="#{UploadingBean.onUploading}"/> </trh:rowLayout> <trh:rowLayout binding="#{UploadingBean.rowLayout2}" id="rowLayout2" halign="center"> <tr:panelButtonBar binding="#{UploadingBean.panelButtonBar1}" id="panelButtonBar1"> <tr:commandButton text="Upload" binding="#{UploadingBean.uploadButton}" id="uploadButton" action="#{UploadingBean.uploadAction}"/> <tr:commandButton text="Upload new" binding="#{UploadingBean.newButton}" id="newButton" action="#{UploadingBean.newUpload}" rendered="false"/> <tr:commandButton text="Close window" binding="#{UploadingBean.commandButton3}" id="commandButton3" immediate="true"> <tr:returnActionListener/> </tr:commandButton> </tr:panelButtonBar> </trh:rowLayout> </tr:panelBox> </tr:form> </trh:body> </trh:html></f:view><%-- oracle-jdev-comment:auto-binding-backing-bean-name:UploadingBean--%>

创建下载页面，代码如下

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><%@ page contentType="text/html;charset=windows-1250"%><%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%><%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%><%@ taglib uri="http://myfaces.apache.org/trinidad/html" prefix="trh"%><%@ taglib uri="http://myfaces.apache.org/trinidad" prefix="tr"%><f:view> <trh:html binding="#{DownloadingBean.html1}" id="html1"> <trh:head title="downloading" binding="#{DownloadingBean.head1}" id="head1"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1250"/> </trh:head> <trh:body binding="#{DownloadingBean.body1}" id="body1"> <tr:messages binding="#{DownloadingBean.messages1}" id="messages1"/> <h:form binding="#{DownloadingBean.form1}" id="form1"> <tr:panelButtonBar binding="#{DownloadingBean.panelButtonBar2}" id="panelButtonBar2"> <tr:commandButton text="Upload new file" binding="#{DownloadingBean.uploadButton}" id="uploadButton" action="dialog:upload" windowHeight="300" windowWidth="300" useWindow="true" returnListener="#{DownloadingBean.afterUploading}" partialTriggers="uploadButton" partialSubmit="true"/> </tr:panelButtonBar> <tr:separator binding="#{DownloadingBean.objectSeparator1}" id="objectSeparator1"/> <tr:table value="#{bindings.BlobTable.collectionModel}" var="row" rows="#{bindings.BlobTable.rangeSize}" first="#{bindings.BlobTable.rangeStart}" emptyText="#{bindings.BlobTable.viewable ? 'No rows yet.' : 'Access Denied.'}" selectionListener="#{bindings.BlobTable.collectionModel.makeCurrent}" binding="#{DownloadingBean.table1}" id="table1" selectedRowKeys="#{bindings.BlobTable.collectionModel.selectedRow}" rowSelection="single"> <tr:column sortProperty="FileName" sortable="false" headerText="#{bindings.BlobTable.labels.FileName}" binding="#{DownloadingBean.column1}" id="column1"> <tr:outputText value="#{row.FileName}" binding="#{DownloadingBean.outputText1}" id="outputText1"/> </tr:column> <tr:column sortProperty="UploadDate" sortable="false" headerText="#{bindings.BlobTable.labels.UploadDate}" binding="#{DownloadingBean.column2}" id="column2"> <tr:outputText value="#{row.UploadDate}" binding="#{DownloadingBean.outputText2}" id="outputText2"> <f:convertDateTime pattern="#{bindings.BlobTable.formats.UploadDate}"/> </tr:outputText> </tr:column><f:facet name="actions"> <tr:panelButtonBar binding="#{DownloadingBean.panelButtonBar1}" id="panelButtonBar1"> <tr:commandButton text="Download" binding="#{DownloadingBean.commandButton1}" id="commandButton1" action="#{DownloadingBean.downloadAction}"/> </tr:panelButtonBar> </f:facet> </tr:table> </h:form> </trh:body> </trh:html></f:view><%-- oracle-jdev-comment:auto-binding-backing-bean-name:DownloadingBean--%>

上传页面的backbean代码如下

public void onUploading(ValueChangeEvent evt) { uploadedFile = (UploadedFile)evt.getNewValue(); fileName = uploadedFile.getFilename(); } public String uploadAction() { try { file = FileOperations.writeToBlobDomain(uploadedFile); BlobAM bam = (BlobAM)ADFUtils.getApplicationModule("BlobAM"); bam.insertNewFile(fileName, file); uploadedFile.dispose(); afterUpload(); } catch (Exception e) { System.out.println(e.getMessage()); e.printStackTrace(); } return null; } private void afterUpload() { inputFilePath.setRendered(false); uploadButton.setRendered(false); newButton.setRendered(true); } public String newUpload() { inputFilePath.setRendered(true); uploadButton.setRendered(true); newButton.setRendered(false); return null; }

下载页面的backbean代码如下

public String downloadAction() { DCIteratorBinding blobIter = ADFUtils.getIterator("BlobTable"); Row r = blobIter.getCurrentRow(); BlobDomain file = (BlobDomain)r.getAttribute("StoredFile"); String fileName = (String)r.getAttribute("FileName"); FileOperations.downloadFile(fileName, file); ADFUtils.executeOperation("downloadingPageDef", "Execute"); return null; } public void afterUploading(ReturnEvent evt) { ADFUtils.executeOperation("downloadingPageDef", "Execute"); refreshCurrentPage(); } protected void refreshCurrentPage() { FacesContext context = FacesContext.getCurrentInstance(); String currentView = context.getViewRoot().getViewId(); ViewHandler vh = context.getApplication().getViewHandler(); UIViewRoot x = vh.createView(context, currentView); x.setViewId(currentView); context.setViewRoot(x); }

FileOperations辅助类代码

package zilp.testcase.view.filehelpers;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.sql.SQLException;import javax.faces.context.ExternalContext;import javax.faces.context.FacesContext;import javax.servlet.http.HttpServletResponse;import org.apache.myfaces.trinidad.model.UploadedFile;import oracle.jbo.domain.BlobDomain;public class FileOperations { public static synchronized BlobDomain writeToBlobDomain(UploadedFile file) throws SQLException, IOException { InputStream in = file.getInputStream(); BlobDomain blobDomain = new BlobDomain(); OutputStream out = blobDomain.getBinaryOutputStream(); byte[] buffer = new byte[8192]; int bytesRead = 0; while ((bytesRead = in.read(buffer, 0, 8192)) != -1) { out.write(buffer, 0, bytesRead); } in.close(); return blobDomain; } public static synchronized void downloadFile(String fileName, BlobDomain blobDomain) { FacesContext facesContext = FacesContext.getCurrentInstance(); ExternalContext extContext = facesContext.getExternalContext(); Long length = blobDomain.getLength(); String fileType = MimeTypes.getMimeType(fileName); HttpServletResponse response = (HttpServletResponse)extContext.getResponse(); response.setHeader("Content-Disposition", "attachment;filename=/"" + fileName + "/""); response.setContentLength((int)length.intValue()); response.setContentType(fileType); try { InputStream in = blobDomain.getBinaryStream(); OutputStream out = response.getOutputStream(); byte[] buf = new byte[1024]; int count; while ((count = in.read(buf)) >= 0) { out.write(buf, 0, count); } in.close(); out.flush(); out.close(); facesContext.responseComplete(); } catch (IOException ex) { System.out.println(ex.getMessage()); ex.printStackTrace(); } }}

MimeTypes辅助类代码

package zilp.testcase.view.filehelpers;public class MimeTypes { public static String getMimeType(String fileName) { String mime = null; String ext = fileName.toLowerCase(); if (ext.endsWith(".pdf")) { mime = "application/pdf"; } else if (ext.endsWith(".doc")) { mime = "application/msword"; } else if (ext.endsWith(".ppt")) { mime = "application/vnd.ms-powerpoint"; } else if (ext.endsWith(".rar")) { mime = "application/octet-stream"; } else if (ext.endsWith(".zip")) { mime = "application/zip"; } return mime; }}

工具类ADFUtils代码

package zilp.testcase.view.util;import oracle.adf.model.BindingContext;import oracle.adf.model.binding.DCBindingContainer;import oracle.adf.model.binding.DCIteratorBinding;import org.apache.myfaces.trinidad.component.core.data.CoreTable;import oracle.binding.BindingContainer;import oracle.binding.OperationBinding;import oracle.jbo.ApplicationModule;import oracle.jbo.Row;import oracle.jbo.uicli.binding.JUCtrlValueBindingRef;public class ADFUtils { /** * Get application module for an application module data control by name. * @param name application module data control name * @return ApplicationModule */ public static ApplicationModule getApplicationModule(String name) { return (ApplicationModule)JSFUtils.resolveExpression("#{data." + name + "DataControl.dataProvider}"); } public static ApplicationModule getNestedApplicationModule(String rootModule, String childModule) { String dataControl = "#{data." + rootModule + "DataControl.dataProvider}"; ApplicationModule root = (ApplicationModule)JSFUtils.resolveExpression(dataControl); return root.findApplicationModule(childModule); } /** * Find an iterator binding in the current binding container by name. * @param iteratorName iterator binding name * @return iterator binding */ public static DCIteratorBinding getIterator(String iteratorName) { DCIteratorBinding iter = getDCBindingContainer().findIteratorBinding(iteratorName + "Iterator"); return iter; } public static Row getCurrentRow(String iteratorName) { return getIterator(iteratorName).getCurrentRow(); } public static Object executeOperation(String pageDefName, String operationName) { BindingContext bctx = getDCBindingContainer().getBindingContext(); BindingContainer bc = bctx.findBindingContainer(pageDefName); OperationBinding operation = bc.getOperationBinding(operationName); return operation.execute(); } public static Row getSelectedRowFromTable(CoreTable tableId) { JUCtrlValueBindingRef valueBinding = (JUCtrlValueBindingRef)tableId.getSelectedRowData(); return valueBinding.getRow(); } /** * Return the current page's binding container. * @return the current page's binding container */ public static BindingContainer getBindingContainer() { return (BindingContainer)JSFUtils.resolveExpression("#{bindings}"); } /** * Return the Binding Container as a DCBindingContainer. * @return current binding container as a DCBindingContainer */ public static DCBindingContainer getDCBindingContainer() { return (DCBindingContainer)getBindingContainer(); }}

工具类JSFUtils代码

package zilp.testcase.view.util;import java.util.Locale;import java.util.Map;import java.util.MissingResourceException;import java.util.ResourceBundle;import javax.faces.application.Application;import javax.faces.application.FacesMessage;import javax.faces.component.UIComponent;import javax.faces.context.ExternalContext;import javax.faces.context.FacesContext;import javax.faces.el.ValueBinding;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class JSFUtils { private static final String NO_RESOURCE_FOUND_PL = "Nie znaleziono zasobu: "; private static final String NO_RESOURCE_FOUND_EN = "Missing resource: "; /*********************************************************************** * Returns current instance of FaceContext class * @return javax.faces.context.FacesContext **********************************************************************/ public static FacesContext getCurrentFacesContext() { return FacesContext.getCurrentInstance(); } /*********************************************************************** * Returns ExternalContext * @return javax.faces.context.ExternalContext **********************************************************************/ public static ExternalContext getCurrentExternalContect() { return getCurrentFacesContext().getExternalContext(); } /*********************************************************************** * Returns current session * @return javax.servlet.http.HttpSession **********************************************************************/ public static HttpSession getCurrentSession() { return (HttpSession)getCurrentExternalContect().getSession(false); } /*********************************************************************** * Returns Map contains current session attributes * @return java.uti.Map **********************************************************************/ public static Map getCurrentSessionMap() { return getCurrentExternalContect().getSessionMap(); } /*********************************************************************** * Returns variable from HTTPSession * @param key * @return java.lang.Object **********************************************************************/ public static Object getFromSession(String key) { return getCurrentSessionMap().get(key); } /*********************************************************************** * Sets object to store in current HttpSession * @param key * @param object **********************************************************************/ public static void setToSession(String key, Object object) { getCurrentSessionMap().put(key, object); } /*********************************************************************** * Returns variable from HTTPRequest * @param attributeName * @return java.lang.Object **********************************************************************/ public static Object getRequestAttribute(String attributeName) { return getCurrentExternalContect().getRequestMap().get(attributeName); } /*********************************************************************** * Sets object to store HTTPRequest * @param key * @param object **********************************************************************/ public static void setRequestAttribute(String key, Object object) { getCurrentExternalContect().getRequestMap().put(key, object); } /*********************************************************************** * Gets response * @return javax.servlet.http.Response **********************************************************************/ public static HttpServletResponse getResponse() { return (HttpServletResponse)getCurrentExternalContect().getResponse(); } /*********************************************************************** * Gets application * @return javax.faces.application.Application **********************************************************************/ public static Application getCurrentApplication() { return getCurrentFacesContext().getApplication(); } /*********************************************************************** * Gets current locale variable * @return java.util.Locale **********************************************************************/ public static Locale getCurrentLocale() { return getCurrentFacesContext().getViewRoot().getLocale(); } /*********************************************************************** * Gets appropriate variable to current locale * @param language e.g. "pl" or "en" * @param country e.g. "PL" or "EN" **********************************************************************/ public static void setCurrentLocale(String language, String country) { Locale locale = new Locale(language, country); getCurrentFacesContext().getViewRoot().setLocale(locale); } /*********************************************************************** * Returns object that can be used to access the property represented * by an action or value binding expression * @param expression in Expresion Language **********************************************************************/ public static ValueBinding getValueBinding(String expression) { return getCurrentApplication().createValueBinding(expression); } /*********************************************************************** * Returns object represented by an action or value binding expression * @param expression in Expresion Language * @return java.lang.Object **********************************************************************/ public static Object resolveExpression(String expression) { FacesContext ctx = getCurrentFacesContext(); Application app = getCurrentApplication(); ValueBinding vb = app.createValueBinding(expression); return vb.getValue(ctx); } /*********************************************************************** * Returns object represented by an action or value binding expression * if expected object is String * @param expression in Expresion Language * @return java.lang.String **********************************************************************/ public static String resolveExpressionAsString(String expression) { return (String)resolveExpression(expression); } /*********************************************************************** * Returns object represented by an action or value binding expression * if expected object is booean * @param expression in Expresion Language * @return TRUE or FALSE ***********************************************************************/ public static Boolean resolveExpressionAsBoolean(String expression) { return (Boolean)resolveExpression(expression); } /*********************************************************************** * Sets new value to appropriate property * @param expression in EL e.g. #{ManagedBean.property} * @param newValue **********************************************************************/ public static void setExpressionValue(String expression, Object newValue) { ValueBinding bind = getValueBinding(expression); Class bindClass = bind.getType(getCurrentFacesContext()); if (bindClass.isPrimitive() || bindClass.isInstance(newValue)) { bind.setValue(getCurrentFacesContext(), newValue); } } /*********************************************************************** * Returns property value of managed bean * @param managedBeanName * @param property * @return java.lang.Object **********************************************************************/ public static Object getManagedBeanValue(String managedBeanName, String property) { StringBuffer buff = new StringBuffer("#{"); buff.append(managedBeanName); buff.append("."); buff.append(property); buff.append("}"); return resolveExpression(buff.toString()); } /*********************************************************************** * Sets new value to appropriate property * @param managedBeanName bean name * @param property name * @param newValue **********************************************************************/ public static void setManagedBeanValue(String managedBeanName, String property, Object newValue) { StringBuffer buff = new StringBuffer("#{"); buff.append(managedBeanName); buff.append("."); buff.append(property); buff.append("}"); setExpressionValue(buff.toString(), newValue); } /*********************************************************************** * Returns string defined in UIResources.properies file * @param key * @return java.lang.String **********************************************************************/ public static String getStringFromBundle(String key) { String resource = null; Application app = getCurrentApplication(); String msgBundle = app.getMessageBundle(); Locale loc = getCurrentLocale(); ClassLoader clsLdr = Thread.currentThread().getContextClassLoader(); ResourceBundle resBundle = ResourceBundle.getBundle(msgBundle, loc, clsLdr); try { resource = resBundle.getString(key); } catch (MissingResourceException mrex) { if (getCurrentLocale().equals(Locale.getDefault())) resource = NO_RESOURCE_FOUND_PL + key; else resource = NO_RESOURCE_FOUND_EN + key; } return resource; } /*********************************************************************** * Raise new JSF message * @param componentId (if NULL summary and detail will appear in messages) * @param severity (allow "INFO", "ERROR","WARN") - default INFO * @param summary text * @param detail text **********************************************************************/ public static FacesMessage raiseMessage(UIComponent componentId, String severity, String summary, String detail) { FacesContext ctx = getCurrentFacesContext(); FacesMessage message = new FacesMessage(); if (severity.equalsIgnoreCase("INFO")) message.setSeverity(FacesMessage.SEVERITY_INFO); if (severity.equalsIgnoreCase("ERROR")) message.setSeverity(FacesMessage.SEVERITY_ERROR); if (severity.equalsIgnoreCase("WARN")) message.setSeverity(FacesMessage.SEVERITY_WARN); message.setSummary(summary); message.setDetail(detail); if (componentId != null) ctx.addMessage(componentId.getClientId(ctx), message); else ctx.addMessage(null, message); return message; } /*********************************************************************** * Raise new JSF message * @param componentId (if NULL summary and detail will appear in messages) * @param severity (allow "INFO", "ERROR","WARN") - default INFO * @param summaryKey key from UIResources * @param detailKey key from UIResources **********************************************************************/ public static FacesMessage raiseMessageFromBundle(UIComponent componentId, String severity, String summaryKey, String detailKey) { FacesContext ctx = getCurrentFacesContext(); FacesMessage message = new FacesMessage(); if (severity.equalsIgnoreCase("INFO")) message.setSeverity(FacesMessage.SEVERITY_INFO); if (severity.equalsIgnoreCase("ERROR")) message.setSeverity(FacesMessage.SEVERITY_ERROR); if (severity.equalsIgnoreCase("WARN")) message.setSeverity(FacesMessage.SEVERITY_WARN); message.setSummary(getStringFromBundle(summaryKey)); message.setDetail(getStringFromBundle(detailKey)); if (componentId != null) ctx.addMessage(componentId.getClientId(ctx), message); else ctx.addMessage(null, message); return message; }}

BlobAM实现类的代码

package zilp.testcase.model.service;import oracle.jbo.Row;import oracle.jbo.domain.BlobDomain;import oracle.jbo.server.ApplicationModuleImpl;import oracle.jbo.server.ViewObjectImpl;import zilp.testcase.model.service.common.BlobAM;// ---------------------------------------------------------------------// --- File generated by Oracle ADF Business Components Design Time.// --- Custom code may be added to this class.// --- Warning: Do not modify method signatures of generated methods.// ---------------------------------------------------------------------public class BlobAMImpl extends ApplicationModuleImpl implements BlobAM { /**This is the default constructor (do not remove) */ public BlobAMImpl() { } public void insertNewFile(String fileName, BlobDomain file) { Row newRow = getBlobTable().createRow(); newRow.setAttribute("FileName", fileName); newRow.setAttribute("StoredFile", file); getBlobTable().insertRow(newRow); getDBTransaction().commit(); getBlobTable().executeQuery(); } /**Sample main for debugging Business Components code using the tester. */ public static void main(String[] args) { launchTester("zilp.testcase.model.service", /* package name */ "BlobAMLocal") /* Configuration Name */; } /**Container's getter for BlobTable */ public ViewObjectImpl getBlobTable() { return (ViewObjectImpl)findViewObject("BlobTable"); }}