我是根据查询条件从数据库中取出满足条件的数据，保存到list中，用了json-plugin插件，所以直接把从数据返回的List类型数据赋值给List类型的参数items直接传到前台gridpanel中的root接收。我现在想实现的是根据查询的结果进行分页显示，如图，我得到12条结果，我现在想每页显示5条，我现在不知道怎样根据start和limit参数来处理。在网上搜了很多，始终搞不清楚原理。
[color=red][size=medium]这里是grid定义[/size][/color]
[code="java"]
//定义数据集对象
var store = new Ext.data.Store({//配置分组数据集
baseParams : {
infoLinkman :''
},
reader: new Ext.data.JsonReader({
totalRecords : "results",
totalProperty: "results",
root : "items",
fields : [
{name: 'id'},
{name: 'infoType'},
{name: 'infoTitle'},
{name: 'infoContent'},
{name: 'infoLinkman'},
{name: 'infoPhone'},
{name: 'infoEmail'},
{name: 'infoDate'},
{name: 'infoState'},
{name: 'infoPayfor'}
]
}),
proxy : new Ext.data.HttpProxy({
url : 'ShowList.action'
})
});
store.load({
params : {
start : 0,
limit : 5
}
});
var sm = new Ext.grid.CheckboxSelectionModel();
var cm = new Ext.grid.ColumnModel([new Ext.grid.RowNumberer(), sm,
{header: "ID", width: 100, dataIndex: 'id', sortable: true},
{header: "信息类别", width: 100, dataIndex: 'infoType', sortable: true},
{header: "信息标题", width: 100, dataIndex: 'infoTitle', sortable: true},
{header: "信息内容", width: 100, dataIndex: 'infoContent', sortable: true},
{header: "联系人", width: 100, dataIndex: 'infoLinkman', sortable: true},
{header: "联系电话", width: 100, dataIndex: 'infoPhone', sortable: true},
{header: "E-mail地址", width: 100, dataIndex: 'infoEmail', sortable: true},
{header: "发布时间", width: 130, dataIndex: 'infoDate', sortable: true},
{header: "审核状态", width: 100, dataIndex: 'infoState', sortable: true},
{header: "付费状态", width: 100, dataIndex: 'infoPayfor', sortable: true}]);
//创建Grid表格组件
var grid = new Ext.grid.GridPanel({
title : '列表',
applyTo : 'grid-div',
width:1200,
height:400,
frame:true,
store : store,
cm : cm,
sm : sm,
tbar : [{
xtype : 'tbtext',
text : '联系人查询'
}, {
xtype : 'textfield',
id : 'infoLinkman',
emptyText : '联系人',
width : 100
}, {
xtype : 'button',
text : '查询',
handler:find
}, '-', {
xtype : 'button',
text : '添加',
handler:add
}, '-', {
xtype : 'button',
text : '编辑',
handler:update
}, '-', {
xtype : 'button',
text : '删除',
handler:remove
}],
bbar : new Ext.PagingToolbar({//分页工具栏
store : store,
pageSize : 5,
displayInfo : true,
displayMsg : '第 {0} 条到 {1} 条，一共 {2} 条',
emptyMsg : "没有记录"
})
});
[/code]
[color=red][size=medium]这里是查询函数[/size][/color]
[code="java"]
function find() {
var store = new Ext.data.Store({//配置分组数据集
baseParams : {
infoLinkman : Ext.getCmp('infoLinkman').getValue()
},
reader: new Ext.data.JsonReader({
totalRecords : "results",
root : "items",
fields : [
{name: 'id'},
{name: 'infoType'},
{name: 'infoTitle'},
{name: 'infoContent'},
{name: 'infoLinkman'},
{name: 'infoPhone'},
{name: 'infoEmail'},
{name: 'infoDate'},
{name: 'infoState'},
{name: 'infoPayfor'}
]
}),
proxy : new Ext.data.HttpProxy({
url : 'ShowList.action'
})
});
store.load({
params : {
start : 0,
limit : 5
}
});
grid.reconfigure(store, cm);
}
[/code]
[color=red][size=medium]这里是action[/size][/color]
[code="java"]
public class ShowListAction extends ActionSupport {
private String infoLinkman;
private long results;
private List items;
String start;
String limit;
public String execute() throws Exception{
this.results = 20;
// int top1=Integer.parseInt(start);
// int top2=Integer.parseInt(limit);
Object[] params={infoLinkman};
String sql="SELECT * FROM tb_info WHERE (info_linkman=?) ORDER BY info_date ASC";
OpDB myOp=new OpDB();
System.out.println(infoLinkman);
items=myOp.OpListShow(sql, params);
return SUCCESS;
}
}
[/code]
[b]问题补充：[/b]
若后台是sql server 2000 sql语句该怎么写呢？好像用mysql的话这个问题比较好解决。还有我那个查询条件 联系人的参数我通过查询按钮在find方法里传过去，但我要点击下一页按钮的话文本框里的这个参数好像就传不过去了，每次传递的参数只是limit和start，这个查询条件参数带不过去。这个参数该怎么传递呢，在更新页码的时候？
[b]问题补充：[/b]
现在就不处理吧，但是他也没有自动分页啊，12条数据他是全部显示出来了啊
[b]问题补充：[/b]
[quote]来进行分页,不过要用两条select语句联合起来用[/quote]
比如总共12条数据，去6-10条，sql怎么写呢？
[b]问题补充：[/b]
[color=red][size=medium]
现在的问题是，我想根据查询条件得到结果，并将符合条件的结果条数动态的传给results。我在第一次显示gridpanel时它就调用了action，因为没有参数联系人参数传入，执行sql语句后满足条件的是0条，这时results值就被赋值0，因此页数就只有一页。此时我再点击查询按钮查询，可以得到第一页的前五条数据，但下面的分页按钮只有一页，无法点击下一页。
第二个问题，即使现在可以点击下一页，那又怎样才能将我的查询条件这个参数带过去呢，不然返回的还是零条。
第三个问题，即使现在点击第二页按钮时，可以返回第6-10条数据，但根据下面的摄sql语句，由于是用id进行分页的，而id是没有重复的，查询操作会直接前5条记录去除，从数据库的第6条开始查询满足条件的记录，而这必然会使第二页得到的内容会与第一页的内容有可能重复（若前5页没有符合条件的内容的话，第1页和第2页内容就会完全一样。）
[color=brown][/color]
[/size][size=small]谢谢各位热心解答，问题讲得很啰嗦，不知道讲清楚没有，我基础不太好，这个问题搞了好久也没弄出个所以然来，实在不知道怎么办了。[/size][/color]
[code="java"]
public String execute() throws Exception{
int top1=Integer.parseInt(start);
int top2=Integer.parseInt(limit);
Object[] params={infoLinkman};
// String sql="SELECT * FROM tb_info WHERE (info_linkman=?) ORDER BY info_date ASC";
String sql = "select top "+top2+" * from tb_info where (info_linkman=?)and (id not in (select top "+top1+" id from tb_info order by id asc )) order by id asc";
// String sql = "select top 5 * from tb_info where (info_linkman=?)and (id not in (select top 10 id from tb_info order by id asc )) order by id asc";
OpDB myOp=new OpDB();
items=myOp.OpListShow(sql, params);
String sql2="select count(*) count from tb_info where (info_linkman=?)";
results = myOp.getUserCount(sql2, params);
// results=11;
System.out.println("符合条件记录条数："+results);
System.out.println(infoLinkman);
return SUCCESS;
}
[/code]
[b]问题补充：[/b]
加上那段代码后提示[color=red]Ext.getCmp("infoLinkman") is undefined
[/color]
其实就是想根据查询条件得到结果集合，但是如果数据量很大，就需要分页，现在这个分页很难实现吗，这个应该也是很常见的需求吧
[b]问题补充：[/b]
[size=medium][color=red]奇怪，上次补充的问题不见了。前段时间网络一直不好。我把load和beforeload函数放到gridpanel定义后结果就正常了，不报错。 现在我把results定死，赋值为11，这样初始分页栏会显示有3页，第一页显示根据查询条件得到的5个结果，点击第二页时，从后台看，action可以得到查询参数并返回5条结果，但是gridpanel里的数据并没有更新，现在的问题是如何让gridpanel根据每次返回的数据动态更新表格。[/color][/size]
[b]问题补充：[/b]
[color=red][size=small]第一次默认返回数据为：{"[/[/size]color]infoLinkman":"","infoType":null,"items":[],"limit":"5","results":11,"start":"0"}
[color=red][size=small]第二次根据查询数据得到数据为：{"[/[/size]color]infoLinkman":"鑺宠姵","infoType":null,"items":[{"[color=red]id[/color]":114,"infoContent":"姹傝喘淇℃伅鍐呭","infoDate":"2007-12-26
11:47:46","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"姹傝喘淇℃伅鏍囬","infoType":4},{"id":115,"infoContent":"鎷涘晢寮曡祫鍐呭","infoDate":"2007-12-26
11:51:54","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"鎷涘晢寮曡祫鏍囬","infoType":5},{"id":116,"infoContent":"鍏瘬淇℃伅鍐呭","infoDate":"2007-12-26
11:52:36","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"鍏瘬淇℃伅鏍囬","infoType":6},{"id":117,"infoContent":"姹傝亴淇℃伅鍐呭","infoDate":"2007-12-26
11:53:03","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"姹傝亴淇℃伅鏍囬","infoType":7},{"id":118,"infoContent":"瀹舵暀淇℃伅鍐呭","infoDate":"2007-12-26
11:53:40","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"瀹舵暀淇℃伅鏍囬","infoType":8}],"limit":"5","results":11,"start":"0"}
[size=small][color=red]点击第二页后得到数据为：[/color][/size]
{"infoLinkman":"鑺宠姵","infoType":null,"items":[{"[color=red]id[/color]":116,"infoContent":"鍏瘬淇℃伅鍐呭","infoDate":"2007-12-26
11:52:36","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"鍏瘬淇℃伅鏍囬","infoType":6},{"id":117,"infoContent":"姹傝亴淇℃伅鍐呭","infoDate":"2007-12-26
11:53:03","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"姹傝亴淇℃伅鏍囬","infoType":7},{"id":118,"infoContent":"瀹舵暀淇℃伅鍐呭","infoDate":"2007-12-26
11:53:40","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"瀹舵暀淇℃伅鏍囬","infoType":8},{"id":119,"infoContent":"杞﹁締淇℃伅鍐呭","infoDate":"2007-12-26
11:54:05","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"杞﹁締淇℃伅鏍囬","infoType":9},{"id":120,"infoContent":"鍑哄敭淇℃伅鍐呭","infoDate":"2007-12-26
11:54:41","infoEmail":"888@89*.com","infoLinkman":"鑺宠姵","infoPayfor":"1","infoPhone":"13255******","infoState"
:"1","infoTitle":"鍑哄敭淇℃伅鏍囬","infoType":10}],"limit":"5","results":11,"start":"5"}
[size=small][color=red]grid定义：[/color][/size]
[code="java"]var grid = new Ext.grid.GridPanel({
title : '列表',
applyTo : 'grid-div',
width:1200,
height:500,
frame:true,
store : store,
cm : cm,
sm : sm,
tbar : [{
xtype : 'tbtext',
text : '联系人查询'
}, {
xtype : 'textfield',
id : 'infoLinkman',
emptyText : '联系人',
width : 100
}, {
xtype : 'button',
text : '查询',
handler:find
}, '-', {
xtype : 'button',
text : '添加',
handler:add
}, '-', {
xtype : 'button',
text : '编辑',
handler:update
}, '-', {
xtype : 'button',
text : '删除',
handler:remove
}],
bbar : new Ext.PagingToolbar({//分页工具栏
store : store,
pageSize : 5,
displayInfo : true,
displayMsg : '第 {0} 条到 {1} 条，一共 {2} 条',
emptyMsg : "没有记录"
})
});
store.on('beforeload', function() { //Ext.data.JsonStore读入数据之前的事件,让store在读入数据之前设置参数。
this.baseParams = {
infoLinkman : Ext.getCmp('infoLinkman').getValue()
};
});
store.load({
params : {
start : 0,
limit : 5
}
});
grid.reconfigure(store, cm);[/code]
[b]问题补充：[/b]
这句代码加不加都一样没反应
[b]问题补充：[/b]
store内容怎么检查啊，不会啊
[b]问题补充：[/b]
[size=medium][color=blue]这个问题先放一放了，以后再接着研究。谢谢所有热心的朋友。[/color][/size]
