为什么ext分页只显示10条数据?没有下一页.
<SCRIPT>
Ext.onReady(function(){
var store = new Ext.data.Store({
proxy : new Ext.data.HttpProxy({url:'test.do?action=doPage'}),
reader: new Ext.data.JsonReader({
root: 'items',
totalProperty: 'results',
id: 'sc_h'
},[
'sc_h','sc_mc','sc_mc'
])
});
store.load({params:{start:0,limit:10}});
var colM=new Ext.grid.ColumnModel([
new Ext.grid.RowNumberer(),
{header:'列1',dataIndex:'sc_h',width:170,sortable:true},
{header:'列2',dataIndex:'sc_mc',width:170,sortable:true},
{header:'列3',dataIndex:'sc_mc',width:170}
]);
//生成表格
var grid = new Ext.grid.GridPanel({
renderTo:'show',
title:"表格",
height:400,
width:600,
cm:colM,
sm:sm,
store:store,
viewConfig: {
forceFit:true
},
bbar: new Ext.PagingToolbar({
pageSize:10,
store: store,
displayInfo: true,
displayMsg: '第{0} 到 {1} 条数据 共{2}条',
emptyMsg: "没有数据"
})
});
});
</SCRIPT>
<DIV id=show></DIV>
</body>
</html>
struts:
int start=Changes.ChangeToInt(request.getParameter("start"));
int pageSize=Changes.ChangeToInt(request.getParameter("limit"));
String sql = "select top "+pageSize+ " a.* from sc a "
+ "where a.sc_h not in (select top "+start*pageSize+" a.sc_h from sc a ) order by a.sc_h ";