½â¾öÓйØ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
Ïà¹ØÎĵµ£º
¿ª·¢»·¾³£ºtomcat+sql server 2000+dreamweaver
Õâ¶Îʱ¼äÐèÒª ½¨Á¢¸ö»ùÓÚjspµÄÂÛ̳£¬ºÜ¼ò½àµÄ ÓÉÓÚÒÔǰ»ù´¡²»ºÃ ¹âÅäÖû·¾³¾Í¸ãÁËÁ½Ìì
ÏÖÇë¸÷λÅóÓѰïæ ¸ø¸ö jspÂÛ̳µÄ´úÂë+Êý¾Ý¿â±¸·Ý ÄãÃǵÄÁ·ÊÖ×÷Æ·Ò²ÐÐ ÔÚ¹ý¼¸Ìì¾ÍÒªÓÃÁË
µ½ÏÖÔÚ»¹Í£ÁôÔÚǰ̨ Ï£ÍûÄÄλÅóÓѰï°ïÎÒ ÏÈллÁË
zhenguo.gg@gmail.com ......
JSP ÄÚÖöÔÏó ÊÕ²Ø
ÄÚÖöÔÏóÊDz»ÐèÒªÉùÃ÷£¬Ö±½Ó¿ÉÒÔÔÚJSPÖÐʹÓõĶÔÏó£¬JSPÓÐÒÔϼ¸ÖÖÄÚÖöÔÏó£º
1.request¶ÔÏó
request±íʾHttpServletRequest¶ÔÏó¡£Ëü°üº¬ÁËÓйØä¯ÀÀÆ÷ÇëÇóµÄÐÅÏ¢£¬²¢ÇÒÌṩÁ˼¸¸öÓÃÓÚ»ñÈ¡cookie, header, ºÍsessionÊý¾ÝµÄÓÐÓõķ½·¨¡£¿Í»§¶ËµÄÇëÇóÐÅÏ¢±»·â×°ÔÚrequest¶ÔÏóÖУ¬Í¨¹ýËü²ÅÄÜÁ˽⵽¿Í»§ ......
<?xml version="1.0" encoding="gb2312" ?>
<?xml-stylesheet type="tet/css" href="mystyle.css" ?>
<%@ page errorPage="error.jap" %>
<%@ page contentType="text/xml" %>
<realmarid>
»ÊÂí»¨Ãû²á
<athlete>
<name>Æë´ïÄÚ</name>
<country> ......
Ò»Ö±¶ÔServletµÄ¼¸ÖÖÒ³ÃæÌø×ª·½Ê½£¬Àí½âµÄºýÀïºýÍ¿µÄ£¬½ñÌìÔÚÍøÉÏËÑÁËÒ»°Ñ£¬ÕÒµ½Ò»±é±È½ÏºÃµÄ£¬¼ÇÏÂÀ´£¬ÒÔºó¿´¿´¡£
Ìø×ª·ÖÁ½²¿·Ö£¬Ò»ÊÇ·¢ÉúÔÚservlet£¬Ò»ÊÇÔÚJSP£¬ÆäʵJSPÒ²¾ÍÊÇservlet£¬²»¹ý»¹ÊÇÓеã²îÒìµÎ¡£
Servlet£º
µ±È»£¬ÔÚservletÖУ¬Ò»°ãÌø×ª¶¼·¢ÉúÔÚdoGet, doPostµÈ·½·¨ÀïÃæ¡£
1) redirect · ......
Ò»¡¢page ¶ÔÏó
page¶ÔÏó´ú±íJSP±¾Éí£¬¸ü׼ȷµØËµËü´ú±íJSP±»×ªÒëºóµÄServlet£¬Ëü¿ÉÒÔµ÷ÓÃServletÀàËù¶¨ÒåµÄ·½·¨¡£
¶þ¡¢config ¶ÔÏó
config ¶ÔÏóÀï´æ·Å×ÅһЩServlet ³õʼµÄÊý¾Ý½á¹¹¡£
config& ......