½â¾öÓйØ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
Ïà¹ØÎĵµ£º
1£º³¬Á¬½ÓÌø×ª
ÎÒÃÇÔÚ³¬Á¬½ÓµÄʱºò£¬³£³£Á¬½Óµ½Ò»¸öjsp»òÕßAction,±ÈÈç:
XXX
ÕâÑù×ö»áÓÐÒ»¸öÎÊÌ⣺ÔÚtest.jspÖУ¬³ýÄã´«µÝµÄparam1ºÍparam2²ÎÊýÍâ,ÄãÓÃrequest.getParamter()È¡ÈκÎÔÀ´Ò³ÃæµÄ±íµ¥ÔªËض¼»áΪ¿Õ£¬ÕâÊÇÒòΪÕâÖÖ·½Ê½»á²úÉúеÄrequestÉúÃüÖÜÆÚ£¬ÔÚÕâ¸örequestÖÐÖ»»á°üº¬³¬Á¬½Óºó¸úËæµÄ?param1ÕâÖÖ²ÎÊý£¬ Òò´ ......
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%
//Çý¶¯³ÌÐòÃû
String driverName="org.gjt.mm.mysql.Driver";
//Êý¾Ý¿âÓû§Ãû
String userName="root";
//ÃÜÂë
S ......
<project name="jspToServletToClass" default="jsp2servlet2class" basedir=".">
<!-- set global properties for this build -->
<property environment="env" />
<property name="src" location="F:\JspC\src\" />
< ......
ÔÚʹÓÃÊý¾Ý¿âµÄ¹ý³ÌÖУ¬²»¿É±ÜÃâµÄÐèҪʹÓõ½·ÖÒ³µÄ¹¦ÄÜ£¬¿ÉÊÇJDBCµÄ¹æ·¶¶Ô´ËȴûÓкܺõĽâ¾ö¡£¶ÔÓÚÕâ¸öÐèÇóºÜ¶àÅóÓѶ¼ÓÐ×Ô¼ºµÄ½â¾ö·½°¸£¬±ÈÈçʹÓÃVectorµÈ¼¯ºÏÀàÏȱ£´æÈ¡³öµÄÊý¾ÝÔÙ·ÖÒ³¡£µ«ÕâÖÖ·½·¨µÄ¿ÉÓÃÐԺܲÓëJDBC±¾ÉíµÄ½Ó¿ÚÍêÈ«²»Í¬£¬¶Ô²»Í¬ÀàÐ͵Ä×ֶεÄÖ§³ÖÒ²²»ºÃ¡£ÕâÀïÌṩÁËÒ»Ö ......
»·¾³ÅäÖúú󣬿ª·¢JSP³ÌÐò¾Í·Ç³£¼òµ¥ÁË¡£
File-->New-->Web Project
Ôڸô°¿ÚÖÐÊäÈëһЩ¹¤³Ì»ù±¾ÐÅÏ¢£¬±ÈÈ繤³ÌÃû£¬ÕâÀïÊäÈëΪ test1-01
ÕâÑùÒ»¸ö»ùÓÚJSPµÄÏîÄ¿¾Í½¨Á¢ÆðÀ´ÁË¡£
Package Explorer µÄÏÔʾ·½·¨£º
Windows-->Show View-->Package Explorer ÕâÑù¾ÍÄÜÏÔʾ³öÀ´À²£¡
Ï ......