hibernate3-SpringMVC+hibernate4+Extjs4.2+mysql

1. 后台处理数据库数据（读取数据）
   @RequestMapping("/getmanagers")@ResponseBodypublic Map getWorkOrders(String page,String limit,String start,String all){ int pageInt = Integer.parseInt(page); int limitInt = Integer.parseInt(limit); int startInt = Integer.parseInt(start); Map map = new HashMap(); List list = workOrdersService.getWorkOrders(); List listTemp ; //数据库中的结果条数小于分页限制,则直接返回结果 map.put("total",list.size()); if(list.size()=list.size()){ listTemp = list.subList(startInt, list.size()); }else{ listTemp = list.subList(startInt, pageInt*limitInt); } map.put("workOrders", listTemp); return map;}

1. ExtMVC

中的model
ext.define('tw.model.globalstatisticsmodel',{
extend : 'ext.data.model',
fields: [
{name: 'id', type: 'int',sorttype :'aesc'},
{name: 'failuretime',type: 'date'},
{name: 'failureaddress', type: 'string'},
{name: 'repairtime', type: 'string'},
{name: 'maintenanceman', type: 'string'},
{name: 'completion', type: 'string'},
{name: 'failurecontent', type: 'string'}
]
});
中的store
ext.define('tw.store.globalstatisticsstore',{
extend:'ext.data.store',
model:'tw.model.globalstatisticsmodel',
pagesize: 17,
proxy:{
type:'ajax',
url: 'gdgl/getmanagers',
reader: {
type: 'json',
root: 'workorders'
},
writer:{
type: 'json'
}
},
autoload: true
});
然后是ext的view
ext.define('tw.view.gdgl.globalstatisticsview',{
extend : 'ext.grid.panel',
xtype : 'globalstatisticsview',
store:'globalstatisticsstore',
seltype : 'checkboxmodel',
forcefit:false,
columns: [{
text: 'id',
dataindex: 'id',
width:50,
editor: {
readonly:true
}
}, {
// text: '故障时间',
header:'故障时间',
dataindex: 'failuretime',
width:180,
renderer : ext.util.format.daterenderer('y-m-d h:i:s'),
editor: {
allowblank: false
}
}, {
text: '故障地点',
dataindex: 'failureaddress',
width:200,
editor: {
allowblank: false
}