EXT+DWR+SPRING+IBATIS+ORACLE分页展示+模糊查询

EXT+DWR+SPRING+IBATIS+ORACLE分页显示+模糊查询

EXT代码：

Ext.onReady(function(){//页条数var pageSize=13;// 创建checkboxvar sm = new Ext.grid.CheckboxSelectionModel({// 监听器listeners : {selectionchange : function(sm) {if (sm.getCount()) {grid.passButton.enable();grid.noPassButton.enable();} else {grid.passButton.disable();grid.noPassButton.disable();}}}});// 创建列模型var cm = new Ext.grid.ColumnModel([sm,{id:'torder_id',header:'电信工单编号',dataIndex:'TORDER_ID',width:0,sortable:true},{header:'电信工单号',dataIndex:'TORDER_CODE',width:120,sortable:true},{header:'套餐类型',dataIndex:'PACKAGE_TYPE',width:120,sortable:true},{header:'金额',dataIndex:'MONEY',width:120,sortable:true},{header:'开户区号',dataIndex:'AREA',width:120,sortable:true},{header:'用户名称',dataIndex:'CUST_NAME',width:120,sortable:true},{header:'用户标致码',dataIndex:'USER_FLAG',width:120,sortable:true},{header:'E家通套餐识别码',dataIndex:'E_USER_FLAG',width:120,sortable:true},{header:'性别',dataIndex:'SEX',width:120,sortable:true},{header:'联系电话',dataIndex:'TELEPHONE',width:120,sortable:true},{header:'身份证号',dataIndex:'IDCARD',width:120,sortable:true},{header:'联系地址',dataIndex:'ADDRESS',width:120,sortable:true},{header:'宽带账号',dataIndex:'WIDE_CODE',width:120,sortable:true},{header:'宽带绑定电话',dataIndex:'WIDE_TELE',width:120,sortable:true},{header:'经办人',dataIndex:'CREATOR',width:120,sortable:true},{header:'创建时间',dataIndex:'CREATE_TIME',width:120,sortable:true}]);// 生成一个构造器var dataRecords = Ext.data.Record.create([{name:'TORDER_ID',type:'long'},{name:'TORDER_CODE',type:'String'},{name:'PACKAGE_TYPE',type:'String'},{name:'MONEY',type:'String'},{name:'AREA',type:'String'},{name:'CUST_NAME',type:'String'},{name:'USER_FLAG',type:'String'},{name:'SEX',type:'String'},{name:'TELEPHONE',type:'String'},{name:'IDCARD',type:'String'},{name:'ADDRESS',type:'String'},{name:'WIDE_CODE',type:'String'},{name:'WIDE_TELE',type:'String'},{name:'CREATOR',type:'String'},{name:'CREATE_TIME',type:'String'}]);// Store对象将使用配置 的DataProxy的实现类来加载数据var store = new Ext.data.Store({proxy : new Ext.data.DWRProxy(keyMgr.findNewTOrder, true),reader : new Ext.data.ListRangeReader({totalProperty : 'totalSize',root : 'data',id : 'torder_id'}, dataRecords)//remoteSort : true});// 创建grid窗体var grid = new Ext.grid.GridPanel({store : store,loadMask : {msg : '数据加载中...'},sm : sm,cm : cm,height : 400,width : 760,frame : true,autoExpandMax :true,//自动扩展列宽度width : 800,tbar:[    {id: 'keyword',xtype:'textfield',x:0,emptyText:'请输入条件后按enter',style:'width:120px;'}],bbar : new Ext.PagingToolbar({pageSize : pageSize,store : store,displayInfo : true,emptyMsg :'没有记录',displayMsg :'显示{0}-{1}条 共{2}条',plugins : new Ext.ux.ProgressBarPager()})});var keyword="";grid.render('com-div');store.baseParams.keyword=keyword;store.load({params : {start : 0,limit : pageSize,keyword:keyword}});var keywordObj=window.document.getElementById('keyword');keywordObj.onkeydown=function(){if(window.event.keyCode=='13'){   keyword = keywordObj.value;   if(keyword.length &lt; 1){   Ext.MessageBox.alert("status","关键字不能为空! ");   return;   }    store.baseParams =[{}];   store.baseParams.keyword = keyword;   store.reload({params:{start:0,limit:pageSize,keyword:keyword}});}}});

SERVICE实现：

public ListRange findNewTOrder(Map&lt;String, String&gt; map) {List list=null;list=this.keyMgrDao.findNewTOrderDao(map);return new ListRange(list.toArray(),this.keyMgrDao.findNewTOrderTotalDao(map));}

DAO实现：

public List findNewTOrderDao(Map&lt;String, String&gt; map) {  Map m=new HashMap();  Long start=null;  Long end=null;  Long limit=null;  limit=new Long(map.get("limit"));  start=new Long(map.get("start"));  end=start+limit;  System.out.println("limit:"+limit);  System.out.println("start:"+start);  m.put("start", start);  m.put("end", end);  m.put("keyword", map.get("keyword").toString());  return this.getSqlMapClientTemplate().queryForList("telecom_order.findNewTOrderSql",m); } public String findNewTOrderTotalDao(Map&lt;String, String&gt; map) {  String str="0";  List list=null;  list=this.getSqlMapClientTemplate().queryForList("telecom_order.findNewTOrderTotalSql",map);  if(list!=null&&list.size()&gt;0){   Map m=new HashMap();   m=(Map)list.get(0);   str=m.get("COUNT").toString();  }  System.out.println("total:" + str);  return str; }

IBATIS SQL：

&lt;!--根据条件查找电信新KEY工单 --&gt;&lt;select id="findNewTOrderSql" parameterresultparameterresultsrc="/img/2012/07/17/1620546520.png" width="96" height="16" alt="EXT+DWR+SPRING+IBATIS+ORACLE分页展示+模糊查询">
    1 楼    fuliang    2010-09-28              个人感觉Spring3.0 MVC + ExtJS是更好的选择。

EXT+DWR+SPRING+IBATIS+ORACLE分页展示

热点推荐