Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½â¾öÓйØExt Gridµ¼³öExcelÔÚJSPµÈ»·¾³Öв»¿ÉÓõÄÎÊÌâ


http://www.ajaxbbs.net/post/extjs/10.html
ÓйØExtGridµ¼³öExcelµÄʵÏÖ·½Ê½£¬ÍøÉÏÒѾ­Óкܶ࣬¹Ù·½Ò²¸ø³öÁËÒ»¸ö·½°¸£¬´úÂë²»ÊǺÜÍêÉÆ£¬²»¹ýÒѾ­ÓиßÈ˶ÔÕâ¸ö½øÐÐÁËÐÞÕý¡£¾ßÌåʵÏÖ·½Ê½¼°´úÂëÎÒÕâÀï¾Í²»ÔÙ¶à˵ÁË£¬´ó¼Ò¿ÉÒԲο´£º
http://www.dojochina.com/index.php?q=node/1254
£¬¸½¼þ£º
gridToExcel.js.txt
Æä»ù±¾Ë¼ÏëÊÇ£º
¿Í»§¶Ë¸ù¾ÝGridÊý¾ÝÉú³ÉExcel¸ñʽµÄXMLÊý¾Ý£¬È»ºó·¢Ë͵½Ò»¸ö·þÎñ¶ËÎļþ£¬·þÎñ¶ËÎļþͨ¹ýÉ趨Content-TypeÀ´ÊµÏÖExcelµÄÏÂÔØ¡£
ÆäÖГµ¼³öExcel”°´Å¥µã»÷Ö´ÐеĴúÂëÈçÏ£º
var
 vExportContent = grid.getExcelXml(); 
if
 (Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2 || Ext.isSafari3) { 
    if
 (! Ext.fly('frmDummy'
)) { 
        var
 frm = document
.createElement('form'
); 
        frm.id = 'frmDummy'

        frm.name = id; 
        frm.className = 'x-hidden'

        document
.body.appendChild(frm); 
    } 
    Ext.Ajax.request({ 
        url: '/exportexcel.php'

        method: 'POST'

        form: Ext.fly('frmDummy'
), 
        callback: function
(o, s, r) { 
            //alert(r.responseText);
 
        }, 
        isUpload
: true

        params: {exportContent


Ïà¹ØÎĵµ£º

jspÂÒÂëÎÊÌâµÄ½â¾ö

1¡¢ ×î»ù±¾µÄÂÒÂëÎÊÌâ¡£
Õâ¸öÂÒÂëÎÊÌâÊÇ×î¼òµ¥µÄÂÒÂëÎÊÌâ¡£Ò»°ãлá³öÏÖ¡£¾ÍÊÇÒ³Ãæ±àÂë²»Ò»Öµ¼ÖµÄÂÒÂë¡£
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page contentType="text/html;charset=iso8859-1"%>
<html>
<head>
<title>ÖÐÎÄÎÊÌâ</title>
<meta http-equi ......

ÔÚJSPÖÐʹÓÃpager taglib½øÐзÖÒ³´¦Àí

     ÔÚÓ¦ÓóÌÐò¿ª·¢µÄʱºò·ÖÒ³ÓÐÁ½ÖÖ:Õæ·ÖÒ³ºÍ¼Ù·ÖÒ³£¬¼Ù·ÖÒ³Òª°ÑËùÓÐÊý¾ÝÏÈÌáÈ¡³öÀ´·Åµ½Ò»¸ölist¼¯ºÏÀï»òÕß¾²Ì¬±äÁ¿ÖС£Õæ·ÖÒ³ÔòÊÇÐèÒªÓõ½¼¸ÐÐÊý¾ÝÔÙ´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´·Å°ÑÐèÒªÏÔʾµÄÊý¾Ý·Åµ½list¼¯ºÏÀï¡£µ«ÎÞÂÛÕæ·ÖÒ³¼Ù·ÖÒ³pager-taglib¶¼¿ÉÒԺܺõÄΪÎÒÃǽøÐд¦Àí¡£
1.ÏÂÔØpager-taglib
ÏÂÔØµØ ......

SetCharacterEncodingFilter jsp×Ö·û¹ýÂËÆ÷

package com.demo.filter;
import javax.servlet.Filter;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.FilterChain;
import java.io.IOException;
public class SetCharacterEn ......

ServletÓëJSPÖÐÒ³ÃæÌø×ªµÄÇø±ð

Ò»Ö±¶ÔServletµÄ¼¸ÖÖÒ³ÃæÌø×ª·½Ê½£¬Àí½âµÄºýÀïºýÍ¿µÄ£¬½ñÌìÔÚÍøÉÏËÑÁËÒ»°Ñ£¬ÕÒµ½Ò»±é±È½ÏºÃµÄ£¬¼ÇÏÂÀ´£¬ÒÔºó¿´¿´¡£
  Ìø×ª·ÖÁ½²¿·Ö£¬Ò»ÊÇ·¢ÉúÔÚservlet£¬Ò»ÊÇÔÚJSP£¬ÆäʵJSPÒ²¾ÍÊÇservlet£¬²»¹ý»¹ÊÇÓеã²îÒìµÎ¡£
Servlet£º
µ±È»£¬ÔÚservletÖУ¬Ò»°ãÌø×ª¶¼·¢ÉúÔÚdoGet, doPostµÈ·½·¨ÀïÃæ¡£
1)  redirect · ......

JSPµÄ¾Å¸öÒþº¬¶ÔÏó

Ò»¡¢page ¶ÔÏó
    page¶ÔÏó´ú±íJSP±¾Éí£¬¸ü׼ȷµØËµËü´ú±íJSP±»×ªÒëºóµÄServlet£¬Ëü¿ÉÒÔµ÷ÓÃServletÀàËù¶¨ÒåµÄ·½·¨¡£
    
¶þ¡¢config ¶ÔÏó
    config ¶ÔÏóÀï´æ·Å×ÅһЩServlet ³õʼµÄÊý¾Ý½á¹¹¡£
    config& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ