?
1、编写如下jsp页面（注意正确引入相关基础ExtJs的库）：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ext JS PivotGrid Sample</title>
<!-- GC -->
<link rel="stylesheet" type="text/css" href="../../resources/css/ext-all.css" />
<link rel="stylesheet" type="text/css" href="../shared/examples.css" />
<!-- ExtJS library: base/adapter -->
<script type="text/javascript" src="../../adapter/ext/ext-base.js"></script>
<!-- ExtJS library: all widgets -->
<script type="text/javascript" src="../../ext-all.js"></script>
<script type="text/javascript" src="simple.js"></script>
</head>
<body id="docbody">
<h1>Pivot Grid example</h1>
<p>This example shows how to create a Pivot Grid backed by an Ext.data.Store.</p>
<p>
In this example we are reading a set of 300 records from the server and then pivoting them around Person and Product (on the left axis)<br />
and City and Year (on the top axis). The data are combined automatically, in this case breaking down sales by product and person <br />over time.
</p>
<p><a href="simple.js">The example code</a> is not minified, so it's readable. </p>
</body>
</html>
? 2、以下为核心功能代码
/*
This file is part of Ext JS 3.4
Copyright (c) 2011-2013 Sencha Inc
Contact: http://www.sencha.com/contact
GNU General Public License Usage
This file may be used under the terms of the GNU General Public License version 3.0 as
published by the Free Software Foundation and appearing in the file LICENSE included in the
packaging of this file.
Please review the following information to ensure the GNU General Public License version 3.0
requirements will be met: http://www.gnu.org/copyleft/gpl.html.
If you are unsure which license is appropriate for your use, please contact the sales department
at http://www.sencha.com/contact.
Build date: 2013-04-03 15:07:25
*/
Ext.onReady(function() {
var SaleRecord = Ext.data.Record.create([
{name: 'person', type: 'string'},
{name: 'product', type: 'string'},
{name: 'city', type: 'string'},
{name: 'state', type: 'string'},
{name: 'month', type: 'int'},
{name: 'quarter', type: 'int'},
{name: 'year', type: 'int'},
{name: 'quantity', type: 'int'},
{name: 'value', type: 'int'}
]);
var myStore = new Ext.data.Store({
url: 'simple.json',
autoLoad: true,
reader: new Ext.data.JsonReader({
root: 'rows',
idProperty: 'id'
}, SaleRecord)
});
var pivotGrid = new Ext.grid.PivotGrid({
title : 'PivotGrid example',
width : 800,
height : 259,
renderTo : 'docbody',
store : myStore,
aggregator: 'sum',
measure : 'value',
viewConfig: {
title: 'Sales Performance'
},
leftAxis: [
{
width: 80,
dataIndex: 'person'
},
{
width: 90,
dataIndex: 'product'
}
],
topAxis: [
{
dataIndex: 'year'
},
{
dataIndex: 'city'
}
]
});
});
?
?3、返回的数据格式要求：
{
"rows": [{
"id": 1,
"pr