Ext.onReady(function() { Ext.BLANK_IMAGE_URL = '../resources/images/default/s.gif'; Ext.QuickTips.init(); function formatDate(value) { //var date = new Date(value); return value ? date.dateFormat('Y-m-d H:i:s') : ''; } var sm = new Ext.grid.CheckboxSelectionModel({checkOnly : true}); var cm = new Ext.grid.ColumnModel([sm, { id : 'ID', header : '编号', dataIndex : 'ID', align : 'center', width : 110, hidden : true }, { header : '名称', dataIndex : 'name', align : 'center', width : 150, editor : new Ext.form.TextField({}) }, { header : "时间", dataIndex : 'time', width : 120, align : 'center', renderer : formatDate, editor : new Ext.ux.form.DateTimeField({ fieldLabel : '时间', id : 'time', name : 'time', width : 130, height : 30, allowBlank : false, blankText : '时间不能为空', editable : false, value : new Date() }) }]); var record = Ext.data.Record.create([{ name : 'ID', type : 'string' }, { name : 'name', type : 'string' }, { name : 'time', type : 'date', dateFormat : 'Y-m-d H:i:s' }]); var store = new Ext.data.Store({ autoLoad : false, pruneModifiedRecords : true, //每次Store加载后,清除所有修改过的记录信息 proxy : new Ext.data.HttpProxy({ url : 'list.action', method : 'POST' }), baseParams : { pageNo : 0, pageSize : 10 }, paramNames : { start : "pageNo", limit : "pageSize" }, reader : new Ext.data.JsonReader({ totalProperty : 'totalCount', root : 'results' }, record) }); store.load(); var tbar = new Ext.Toolbar({ items : [{ text : '新增', iconCls : 'add', handler : add }, '-', { text : '保存', iconCls : 'save', handler : save }, '-', { text : '删除', iconCls : 'remove', handler : remove }] }); var bbar = new Ext.PagingToolbar({ pageSize : 10, store : store, displayInfo : true, lastText : "尾页", nextText : "下一页", beforePageText : "当前", prevText : "上一页", firstText : "首页", refreshText : "刷新", afterPageText : "页,共{0}页", displayMsg : '数据从第{0}条 - 第{1}条 共{2}条数据', emptyMsg : '没有数据' }); var grid = new Ext.grid.EditorGridPanel({ id : "myGrid", title : '信息维护', renderTo : 'grid', sm : sm, cm : cm, store : store, clicksToEdit : 1, loadMask : { msg : '正在加载数据,请稍侯……' }, autoScroll : true, autoWidth : true, autoHeight : true, stripeRows : true, viewConfig : { forceFit : true }, tbar : tbar, bbar : bbar }); grid.render(); function add() { var initValue = { ID : "", name : "", time : new Date() }; var recode = store.recordType; var p = new recode(initValue); // 根据上面创建的recode 创建一个默认值 grid.stopEditing(); store.insert(0, p);// 在第一个位置插入 grid.startEditing(0, 1);// 指定的行/列,进行单元格内容的编辑 } function save() { var modified = store.modified; Ext.Msg.confirm("警告", "确定要保存吗?", function(button) { if (button == "yes") { var json = []; Ext.each(modified, function(item) { json.push(item.data); }); if (json.length > 0) { Ext.Ajax.request({ url : "save.action", params : { data : Ext.util.JSON.encode(json) }, method : "POST", success : function(response) { Ext.Msg.alert("信息","数据保存成功!",function() { store.reload(); }); }, failure : function(response) { Ext.Msg.alert("警告","数据保存失败,请稍后再试!"); } }); } else { Ext.Msg.alert("警告", "没有任何需要更新的数据!"); } } }); } function remove() { var selModel = grid.getSelectionModel(); if (selModel.hasSelection()) { Ext.Msg.confirm("警告", "确定要删除吗?", function(button) { if (button == "yes") { var recs = selModel.getSelections(); var list = []; for (var i = 0; i < recs.length; i++) { var rec = recs[i]; list.push("'" + rec.get('ID') + "'"); } Ext.Ajax.request({ url : "delete.action", params : { data : list.join(',') }, method : "POST", success : function(response) { Ext.Msg.alert("信息","数据删除成功!", function() { store.reload(); }); }, failure : function(response) { Ext.Msg.alert("警告","数据删除失败,请稍后再试!"); } }); } }); } else { Ext.Msg.alert("错误", "没有任何行被选中,无法进行删除操作!"); } } });
public String list() throws Exception { String sql = "select ID,name,time from Info"; String rs= infoService.getJSONBySQL(sql, page); String jsonString = "{totalCount:" + page.getTotal() + ",results:" + rs+ "}"; response.setCharacterEncoding("UTF-8"); response.setContentType("application/json"); response.getWriter().print(jsonString); return null; } public String save() throws Exception { String data = request.getParameter("data"); JSONArray array = JSONArray.fromObject(data); Object[] list = array.toArray(); for (int i = 0; i < list.length; i++) { Map<String, String> map = (Map<String, String>) list[i]; Info info = new Info(); info.setId(map.get("ID")); info.setName(map.get("name")); info.setTime(map.get("time")); if (null != info.getId() && info.getId().length() > 0) { infoService.upate(info); } else { infoService.save(info); } } response.getWriter().write("SUCCESS"); return null; } public String delete() throws Exception { String ids = request.getParameter("data"); infoService.delete(ids); response.getWriter().write("SUCCESS"); return null; }