<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    jfy3d(劍事)BLOG

      BlogJava :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理 ::
      37 隨筆 :: 0 文章 :: 363 評論 :: 0 Trackbacks

    WebWork中除了默認支持的幾中視圖外還可以自己來定義需要的視圖,如JFreeChart,Excel等

    這里生成Excel用的是POI的API
    WebWork中定義ResultType視圖類型只需要繼承Result接口
    代碼如下

    package com.customer.resulttype;

    import com.opensymphony.xwork.Result;
    import com.opensymphony.xwork.ActionInvocation;
    import com.opensymphony.webwork.ServletActionContext;
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;

    import javax.servlet.http.HttpServletResponse;
    import java.io.OutputStream;

    public class ExcelResult implements Result{
    ??? private HSSFWorkbook workbook;
    ??? private String filename;
    ??? private String contenttype;
    ??? public void execute(ActionInvocation invocation) throws Exception {
    ??????? if(contenttype==null)
    ??????????? contenttype = "application/ms-excel";
    ??????? if (workbook==null)
    ??????????? workbook = (HSSFWorkbook) invocation.getStack().findValue("workbook");
    ??????

    ??????? HttpServletResponse response = ServletActionContext.getResponse();
    ??????? response.setContentType(contenttype);
    ??????? response.setHeader("Content-Disposition","attachment;Filename="+filename+".xls");
    ??????? OutputStream os = response.getOutputStream();
    ??????? workbook.write(os);
    ??????? os.flush();
    ??????? os.close();
    ??? }

    ??? public void setWorkbook(HSSFWorkbook workbook) {
    ??????? this.workbook = workbook;
    ??? }

    ??? public void setFilename(String filename) {
    ??????? this.filename = filename;
    ??? }

    ??? public void setContenttype(String contenttype) {
    ??????? this.contenttype = contenttype;
    ??? }
    }

    視圖做完之后做如下配置運行測試

    package com.customer.action;

    import com.opensymphony.xwork.ActionContext;
    import com.opensymphony.xwork.ActionSupport;
    import com.opensymphony.webwork.ServletActionContext;
    import com.dboperate.ResultGather;
    import org.apache.poi.hssf.usermodel.*;
    import org.apache.poi.hssf.util.HSSFColor;

    import java.io.FileOutputStream;
    import java.io.InputStream;
    import java.io.InputStreamReader;
    import java.io.ByteArrayInputStream;
    import java.util.List;
    import java.util.Map;

    public class ExportExcelAction extends ActionSupport {
    ??? private HSSFWorkbook workbook;

    ??? public String execute() throws Exception {
    ??????? return SUCCESS;
    ??? }

    ??? public String product() throws Exception {
    ??????? try {
    ??????????? workbook = new HSSFWorkbook();
    ??????????? HSSFSheet sheet = workbook.createSheet();

    ??????????? workbook.setSheetName(0, "廠商產品", (short) 1);
    ??????????? HSSFRow row = sheet.createRow((short) 0);

    ??????????? HSSFCell cell0 = row.createCell((short) 0);
    ??????????? HSSFCell cell1 = row.createCell((short) 1);
    ??????????? HSSFCell cell2 = row.createCell((short) 2);
    ??????????? HSSFCell cell3 = row.createCell((short) 3);
    ??????????? HSSFCell cell4 = row.createCell((short) 4);
    ??????????? HSSFCell cell5 = row.createCell((short) 5);
    ??????????? HSSFCell cell6 = row.createCell((short) 6);
    ??????????? HSSFCell cell7 = row.createCell((short) 7);
    ??????????? HSSFCell cell8 = row.createCell((short) 8);
    ??????????? HSSFCell cell9 = row.createCell((short) 9);

    ??????????? cell0.setEncoding(HSSFCell.ENCODING_UTF_16);//這里是設置編碼保證中文正常顯示
    ??????????? cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell2.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell3.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell4.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell5.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell6.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell7.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell8.setEncoding(HSSFCell.ENCODING_UTF_16);
    ??????????? cell9.setEncoding(HSSFCell.ENCODING_UTF_16);

    ??????????? cell0.setCellValue("廠商名");
    ??????????? cell1.setCellValue("產品名");
    ??????????? cell2.setCellValue("重量");
    ??????????? cell3.setCellValue("星級");
    ??????????? cell4.setCellValue("parama");
    ??????????? cell5.setCellValue("paramb");
    ??????????? cell6.setCellValue("paramc");
    ??????????? cell7.setCellValue("paramd");
    ??????????? cell8.setCellValue("狀態");
    ??????????? cell9.setCellValue("備注");

    ??????? } catch (Exception e) {
    ??????? }
    ??????? return SUCCESS;
    ??? }

    ??? public HSSFWorkbook getWorkbook() {
    ??????? return workbook;
    ??? }


    }

    Xwork.xml中配置加入

    ??????? <result-type default="true" name="freemarker"
    ??????????? <result-type name="excel" class="com.customer.resulttype.ExcelResult"/>
    ??????? </result-types>

    ?<action name="exportExcel" class="com.customer.action.ExportExcelAction">

    ??????????? <result name="success" type="excel">
    ??????????????? <param name="filename">productparam>
    ???????????????
    ??????????? </result>

    ??????? </action>

    posted on 2006-04-11 12:16 劍事 閱讀(5704) 評論(5)  編輯  收藏 所屬分類: webwork

    評論

    # re: WebWork中自定義result視圖使用POI生成Excel 2006-04-18 14:55 lynx
    System.out.println(invocation.getStack().findValue("workbook"));

    這個打印出來是null

    前臺頁面報錯:
    java.lang.IllegalStateException: getOutputStream() has already been called for this response
    org.apache.coyote.tomcat5.CoyoteResponse.getWriter(CoyoteResponse.java:599)
    org.apache.coyote.tomcat5.CoyoteResponseFacade.getWriter(CoyoteResponseFacade.java:163)
    com.opensymphony.webwork.views.freemarker.FreemarkerServlet.process(FreemarkerServlet.java:229)


    后臺tomcat報錯:
    04-18 14:51:38.828 ERROR [ExceptionInterceptor.java:38] Caught exception while invoking action: compare.ExportToExcelToolAction@1f1c748
    java.lang.NullPointerException
    at compare.ExcelResult.execute(ExcelResult.java:38)
    at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:258)
    at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:182)
    at gxlu.webapps.umv.core.webwork.interceptor.AuditInterceptor.intercept(AuditInterceptor.java:46)  回復  更多評論
      

    # 怎么動態設置下載后的文件名??? 2006-04-18 15:14 hello
    文件名在action 中動態生成傳到excelresult里面怎么寫??
    我不想在<result name="success" type="excel">
    <param name="filename">productparam>
    </result>
    中寫死.  回復  更多評論
      

    # re: WebWork中自定義result視圖使用POI生成Excel 2006-04-18 21:22 劍事
    tomcat 5 webwork 2.17版本運行正常

    動態指定文件名可以再ACTION中
    private String filename;
    public String getFilename() {
    return filename;
    }
    然后result中

    if(filename==null)
    filename = (String)invocation.getStack().findValue("filename");  回復  更多評論
      

    # re: WebWork中自定義result視圖使用POI生成Excel 2006-04-19 10:16 asdfd
    配置好了.謝謝!  回復  更多評論
      

    # re: WebWork中自定義result視圖使用POI生成Excel 2009-03-09 11:18 Robert Su
    <result-type default="true" name="freemarker"
    <result-type name="excel" class="com.customer.resulttype.ExcelResult"/>
    </result-types>

    控制臺輸出
    嚴重: Could not find action or result
    No result defined for action……  回復  更多評論
      

    主站蜘蛛池模板: 中文字幕亚洲精品资源网| 每天更新的免费av片在线观看 | 57pao一国产成永久免费| 亚洲成a人片在线观看日本| 精品一区二区三区免费观看| 一级毛片直播亚洲| 亚州**色毛片免费观看| 亚洲真人日本在线| 男女猛烈激情xx00免费视频| 亚洲精品人成无码中文毛片| 免费的黄色的网站| 国产精品亚洲高清一区二区| 成人A毛片免费观看网站| 亚洲精品无码专区久久久| 日韩免费观看一区| 亚洲一区二区三区首页| 日韩免费一区二区三区在线播放| 亚洲娇小性色xxxx| 国产免费观看青青草原网站| 一个人免费播放在线视频看片| 国产亚洲精久久久久久无码77777| 精品免费tv久久久久久久| 亚洲精品日韩专区silk| 成人免费毛片内射美女APP| MM1313亚洲国产精品| 亚洲国产主播精品极品网红| 99在线免费观看| 亚洲最大中文字幕| 国产无遮挡裸体免费视频| 巨胸狂喷奶水视频www网站免费| 久久精品国产亚洲AV网站| 日韩亚洲国产高清免费视频| 美女被免费网站在线视频免费| 亚洲欧洲成人精品香蕉网| 亚欧免费视频一区二区三区| 综合一区自拍亚洲综合图区| 久久被窝电影亚洲爽爽爽| 无人影院手机版在线观看免费| 成人精品视频99在线观看免费| 亚洲精品亚洲人成在线播放| 亚洲综合最新无码专区|