靜態寫死的表格在真實專案裡幾乎用不到。實務上的 GridPanel 都是「先由後端告訴前端有哪些欄位,前端再動態組出 ColumnModel 與 Store」。以下以一個標籤模型管理介面為例,說明完整流程。
流程分成三個階段:
ColumnModel 與 Store,並綁到分頁工具列。grid.reconfigure(store, cm) 讓既有 GridPanel 換上新的欄位與資料來源。var tagModelManager_toolBar = new Ext.Toolbar({
items: [
{ id:'tagModel_Save', text:'添加', iconCls:'add', handler:tagModel_Save },
'-',
{ id:'tagModel_dropSelected', text:'刪除', iconCls:'remove', handler:tagModel_dropSelected }
]
});
new Ext.grid.GridPanel({
id: 'tagModelManager_tagModelGrid',
autoScroll: true,
store: new Ext.data.Store(),
cm: new Ext.grid.ColumnModel([new Ext.grid.RowNumberer()]),
sm: new Ext.grid.CheckboxSelectionModel(),
renderTo: 'tagModelManager_tagModelDiv',
width: Ext.getCmp('TagModel_win').getSize().width - 16,
height: Ext.getCmp('TagModel_win').getSize().height - 35,
hideHeaders: false,
loadMask: { msg:'正在加載數據,請稍候....' },
collapsible: true,
collapsed: false,
bbar: new Ext.PagingToolbar({
id: 'tagModelManager_tagModelPagingBar',
pageSize: getComboValue(),
store: new Ext.data.Store(),
displayInfo: true
}),
tbar: tagModelManager_toolBar
});
Ext.getCmp('tagModelManager_tagModelGrid').render();
Ext.getCmp('tagModelManager_tagModelGrid').on('rowdblclick', tagModelSelectRowDblClickEvent);
注意一開始的 GridPanel 只有一個空的 Store 與最小的 ColumnModel,實際內容要等資料回來才補上。另外它綁了 rowdblclick 事件,用於雙擊編輯:
function tagModelSelectRowDblClickEvent(selectionModel, rowIndex, selectedRecord) {
var selectedRows = Ext.getCmp('tagModelManager_tagModelGrid')
.getSelectionModel().getSelections();
var row = selectedRows[0];
tagModel_SaveOrEdit('edit', row);
}
function tagModelList_search() {
Ext.Ajax.request({
url: 'editTagModel.html?method=getParams',
callback: getSearchList
});
}
function getSearchList(options, success, response) {
if (!success) return;
var json = Ext.util.JSON.decode(response.responseText);
var tagModelManager_tagModelGridTitle = json.tagModelManager_tagModelGridTitle;
var record = json.record;
var columnModels = json.tagModelManager_tagModelColumnModels;
// 用後端回傳的欄位定義,前面再加上序號欄與核取欄
var cm = new Ext.grid.ColumnModel(
Ext.util.JSON.decode("[" + "new Ext.grid.RowNumberer()" + "," +
"new Ext.grid.CheckboxSelectionModel()" + "," +
columnModels + "]")
);
cm.defaultSortable = true;
var store = new Ext.data.Store({
baseParams: {
tagModelKeyword: Ext.getCmp('tagModelManager_search_button').el.dom.value.trim()
},
proxy: new Ext.data.HttpProxy({ url: 'editTagModel.html?method=getTagModelDataList' }),
reader: new Ext.data.JsonReader({
totalProperty: 'resultSize',
root: 'tagModelList'
}, Ext.util.JSON.decode(record))
});
Ext.getCmp('tagModelManager_tagModelPagingBar').bind(store);
store.load({ params: { start: 0, limit: getComboValue() } });
Ext.getCmp('tagModelManager_tagModelGrid').setTitle(tagModelManager_tagModelGridTitle);
Ext.getCmp('tagModelManager_tagModelGrid').reconfigure(store, cm);
Ext.getCmp('tagModelManager_tagModelGrid').expand(false);
}
tagModelList_all() 與 getTagModel() 是「載入全部資料」的版本,差別只在沒有 baseParams 的關鍵字條件,其餘邏輯一致。頁面載入時即呼叫一次:
Ext.Ajax.request({ url: 'editTagModel.html?method=getParams', callback: getTagModel });
前端要資料,後端負責提供。資料清單介面大致如下:
public void getTagModelDataList(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response){
ITagModelManager tagmgr = this.getPkgServer().getDriver()
.getOperateServer().getTagModelManager();
List<HashMap<String,String>> models = new ArrayList<HashMap<String,String>>();
List<EssTagModel> tagModels = tagmgr.getEssTagModels();
int resultSize = 0;
if (tagModels != null && !tagModels.isEmpty()){
resultSize = tagModels.size();
// 依 start / limit 做分頁
String start = request.getParameter("start");
String perPage = request.getParameter("limit");
if (start != null && perPage != null){
int fromIdx = Integer.parseInt(start);
int per = Integer.parseInt(perPage);
int toIdx = fromIdx + per;
if (toIdx > resultSize) toIdx = resultSize;
tagModels = tagModels.subList(fromIdx, toIdx);
}
for (EssTagModel etm : tagModels){
HashMap<String,String> map = new HashMap<String,String>();
map.put("id", Long.toString(etm.getId()));
map.put("esidentifier", etm.getEsidentifier());
map.put("estype", etm.getEstype());
map.put("esdescription", etm.getEsdescription());
map.put("esorder", Long.toString(etm.getEsorder()));
map.put("metadata", etm.getMetadata());
models.add(map);
}
}
JSONObject json = new JSONObject();
json.put("tagModelList", new JSONArray(models));
json.put("resultSize", resultSize);
writeJson(response, json.toString());
}
欄位定義介面則回傳 record(欄位型別描述)與 columnModels(欄位顯示設定):
public void getParams(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response){
LinkedHashMap<String,String> tags = new LinkedHashMap<String,String>();
tags.put("id", "id");
tags.put("esidentifier", "字段");
tags.put("estype", "類型");
tags.put("esdescription", "描述");
tags.put("esorder", "順序");
tags.put("metadata", "元數據");
tags.put("esisnull", "是否為必填項");
tags.put("eslength", "字段長度");
tags.put("esdotlength", "小數點位數");
tags.put("esissystem", "是否為系統字段");
JSONObject json = new JSONObject();
json.put("record", getJsonRecord(tags));
json.put("tagModelManager_tagModelColumnModels", getJsonColumnModel(tags));
writeJson(response, json.toString());
}
totalProperty: 'resultSize' 搭配 start/limit 參數,讓 PagingToolbar 能正確計算頁數。資料量大時務必這樣做,不要一次把全部資料拉回前端。Ext.util.JSON.decode("[new Ext.grid.RowNumberer(),...]"))是這段程式最脆弱的地方。字串一有錯就需要執行階段才發現,且無法靜態檢查。較好的做法是把 record 定義設計成純資料格式(如 [{header:'id', dataIndex:'id', width:60}, ...]),再由前端 map 成真正的 ColumnConfig 物件。rowdblclick 的第一個參數是 GridPanel 本身而非 selectionModel,範例中的命名容易造成誤解,實際取用時應從 grid.getSelectionModel() 取得選取列。tagModelKeyword 直接送進後端查詢前,務必做參數化處理,避免 SQL 注入。