java ext pagesize_Ext-实现带查询以及分页的列表

前台：

Store:

var resource = new Ext.data.Store({

fields: ['imgpath','typeImage','title', 'type'],

url: 'teaching/resource/resourceAction.evi?method=getResourceList',

reader: new Ext.data.XmlReader(

{

record: "Item",

totalRecords: "TotalCount"

},

[{name:'title',mapping: 'title'}, {name:'type',mapping: 'type'},{name:'imgpath',mapping: 'imgpath'},{name:'typeImage',mapping: 'typeImage'} ]

)

});

resource.addListener('load', function(st, rds, opts) {

// st 是当前的store, rds是读到的Record[], opts是store的配置

for( var c=0; c

       rds[c].set('typeImage', "");

//待定类别，先定死类别图片

}

});

resource.load({params:{start:0,limit:10}});

var resourceType = new Ext.data.Store({

url:'teaching/resourceType/resourceTypeAction.evi?method=getResourceTypeList',

reader: new Ext.data.XmlReader({

record: "Item"

}, [

{name: 'resourceTypeId', mapping: 'resourceTypeId'},

{name: 'resourceType', mapping: 'resourceType'}

])

});

resourceType.load();

var languageType = new Ext.data.Store({

url:'teaching/languageType/languageTypeAction.evi?method=getLanguageTypeList',

reader: new Ext.data.XmlReader({

record: "Item"

}, [

{name: 'languageTypeId', mapping: 'languageTypeId'},

{name: 'languageType', mapping: 'languageType'}

])

});

languageType.load();

列表：

resourcePanel = new Ext.grid.GridPanel({

id: 'resources',

frame: true,

header: false,

width: 288,

autoWidth: true,

autoHeight: true,

loadMask:{msg:'正在加载数据，请稍侯……'},

iconCls:'icon-grid',

viewConfig: { forceFit: true },

columns:[

{header: " ",dataIndex: 'typeImage' , width:20},

{header: "资源标题", width: 190, sortable: true, dataIndex: 'title'},

{header: "类别", width: 80, sortable: true, dataIndex: 'type'}

],

store: resource,

selModel: new Ext.grid.RowSelectionModel({singleSelect:false}),

bbar: new Ext.PagingToolbar({

pageSize: 10,

store: resource,

displayInfo: false,

//displayMsg: '显示第 {0} 条到 {1} 条记录，一共 {2} 条',

emptyMsg: "没有记录"

}),

listeners: {

rowclick:function(e) {

try {

window.parent.parent.Ext.ux.MyTips.msg("提示", "双击该行可预览该资源");

} catch(e) {}

},

rowdblclick:function(g, rIdx, e) {

var rd = g.getStore().getAt(rIdx);

   var html = "";

window.parent.showWin({

layout: 'fit',

maximizable: true,

title: rd.get('title'),

width: 400,

height: 400,

//modal: true,

//closeAction: 'hide',

plain: true,

items: [ {html: html} ]

});

}

}

});

FormPanel:

var rform = new Ext.form.FormPanel({

id:'rform',

header: false,

frame: true,

hideBorders: false,

items: [

new Ext.form.TextField({

fieldLabel: '关键字',

name:'keyword'

}),

new Ext.form.ComboBox({

fieldLabel: '资源类别',

mode: 'local',

triggerAction: 'all',

store: resourceType,

typeAhead: true,

hiddenName:'resourceTypeId',

displayField: 'resourceType',

valueField: 'resourceTypeId',

readOnly: true,

selectOnFocus: true

}),

new Ext.form.ComboBox({

fieldLabel: '语言',

mode: 'local',

triggerAction: 'all',

typeAhead: true,

hiddenName:'languageTypeId',

displayField:'languageType',

valueField:'languageTypeId',

readOnly: true,

selectOnFocus: true,

store:languageType

}),

new Ext.Panel({

layout: 'table',

buttonAlign: 'center',

layoutConfig: { colspan: 3 },

buttons:[{text: '搜  寻',

handler: function() {

var keyword = Ext.get('keyword').dom.value;

var resourceTypeId = Ext.get('resourceTypeId').dom.value;

var languageTypeId = Ext.get('languageTypeId').dom.value;

resource.reload({params:{start:0,limit:3,keyword:keyword,resourceTypeId:resourceTypeId,languageTypeId:languageTypeId}});

//这里不用再写ajax，Ext已经封装了ajax，只要把参数传进去就行了

}},

{

text: '重  置',

handler: function() {

Ext.getCmp('rform').form.reset();

}

}

]

})

]

})

后台：

public ActionForward getResourceList(ActionMapping mapping,

ActionForm form, HttpServletRequest request,

HttpServletResponse response) throws IOException {

Document document = DocumentHelper.createDocument();

String start = request.getParameter("start");

String limit = request.getParameter("limit");

String keyword = request.getParameter("keyword");

String resourceTypeId = request.getParameter("resourceTypeId");

String languageTypeId = request.getParameter("languageTypeId");

List hqlFilter = new LinkedList();

if(keyword != null && keyword.length()>0){

hqlFilter.add( new HqlCondition("and", "rs.title", "like", "%" + keyword + "%", HqlCondition.String) );

hqlFilter.add( new HqlCondition("or", "rs.remarks", "like", "%" + keyword + "%", HqlCondition.String) );

}

if(resourceTypeId != null && resourceTypeId.length()>0){

hqlFilter.add( new HqlCondition("and", "rs.resourceType.resourceTypeId", "=", new Long(resourceTypeId), HqlCondition.Long) );

}

if(languageTypeId != null && languageTypeId.length()>0){

hqlFilter.add( new HqlCondition("and", "rs.languageType.languageTypeId", "=", new Integer(languageTypeId), HqlCondition.Integer) );

}

int pageno =1;

int pagesize = 10;

if(limit != null && limit.length()>0){

pagesize = Integer.parseInt(limit);

}

if(!start.equalsIgnoreCase("0") && start != null && start.length()>0){

int bpos = Integer.parseInt(start);

pageno = (bpos + pagesize)/pagesize;

}

int total = this.rse.getResourceTotalCount(hqlFilter);

Collection coll = this.rse.getResourceList(hqlFilter,pageno,pagesize);

Iterator it = coll.iterator();

while(it != null && it.hasNext()){

BaseVO bv = it.next();

ResourceType rt = this.rts.getResourceType(((ResourceType)bv.get("resourceType")).getResourceTypeId());

bv.set("type", rt.getResourceType());

}

document.addElement("type");

new OutputVOXml().writeXML(total,new LinkedList(coll), response);

return null;

}

posted on 2008-10-04 22:43 Loy Fu 阅读(1191) 评论(0)  编辑  收藏