wbr2005 2009-08-24 10:37
浏览 288
已采纳

ext分页,后台如何处理?

我是根据查询条件从数据库中取出满足条件的数据,保存到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]

  • 写回答

15条回答 默认 最新

  • iteye_10013 2009-08-24 10:42
    关注

    你后台就根据传递过来的参数start,limit来查询数据然后返回咯.
    如果需要前台分页,看官方的
    Paging with Local Data

    Paging can also be accomplished with local data using extensions:

    Ext.ux.data.PagingStore
    Paging Memory Proxy (examples/ux/PagingMemoryProxy.js)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(14条)

报告相同问题?

悬赏问题

  • ¥15 如何能达到用ping0.cc检测成这样?如图
  • ¥15 关于#DMA固件#的问题,请各位专家解答!
  • ¥15 matlab生成的x1图不趋于稳定,之后的图像是稳定的水平线
  • ¥15 请问华为OD岗位的内部职业发展通道都有哪些,以及各个级别晋升的要求
  • ¥20 微信小程序 canvas 问题
  • ¥15 系统 24h2 专业工作站版,浏览文件夹的图库,视频,图片之类的怎样删除?
  • ¥15 怎么把512还原为520格式
  • ¥15 MATLAB的动态模态分解出现错误,以CFX非定常模拟结果为快照
  • ¥15 求高通平台Softsim调试经验
  • ¥15 canal如何实现将mysql多张表(月表)采集入库到目标表中(一张表)?