<!-- 方式一：將靜態(tài)HTML渲染為datagrid樣式 -->
	<table class="easyui-datagrid">
		<thead>
			<tr>
				<th data-options="field:'id'">編號(hào)</th>
				<th data-options="field:'name'">姓名</th>
				<th data-options="field:'age'">年齡</th>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td>001</td>
				<td>小明</td>
				<td>90</td>
			</tr>
			<tr>
				<td>002</td>
				<td>老王</td>
				<td>3</td>
			</tr>
		</tbody>
	</table>

<!-- 方式二：發(fā)送ajax請(qǐng)求獲取json數(shù)據(jù)創(chuàng)建datagrid -->
	<table data-options="url:'${pageContext.request.contextPath }/json/datagrid_data.json'" 
			class="easyui-datagrid">
		<thead>
			<tr>
				<th data-options="field:'id'">編號(hào)</th>
				<th data-options="field:'name'">姓名</th>
				<th data-options="field:'age'">年齡</th>
			</tr>
		</thead>
	</table>

<!-- 方式三：使用easyUI提供的API創(chuàng)建datagrid -->
	<script type="text/javascript">
		$(function(){
			//頁(yè)面加載完成后，創(chuàng)建數(shù)據(jù)表格datagrid
			$("#mytable").datagrid({
				//定義標(biāo)題行所有的列
				columns:[[
				 {title:'編號(hào)',field:'id',checkbox:true},
				 {title:'姓名',field:'name'},
				 {title:'年齡',field:'age'},
				 {title:'地址',field:'address'}
				 ]],
				//指定數(shù)據(jù)表格發(fā)送ajax請(qǐng)求的地址
				url:'${pageContext.request.contextPath }/json/datagrid_data.json',
				rownumbers:true,
				singleSelect:true,
				//定義工具欄
				toolbar:[
				 {text:'添加',iconCls:'icon-add',
				 	 //為按鈕綁定單擊事件
				 	 handler:function(){
				 	 	alert('add...');
				 	 }
				 },
				 {text:'刪除',iconCls:'icon-remove'},
				 {text:'修改',iconCls:'icon-edit'},
				 {text:'查詢',iconCls:'icon-search'}
				 ],
				//顯示分頁(yè)條
				pagination:true
			});
		});
	</script>

/**
	 * 通用分頁(yè)查詢方法
	 */
	public void pageQuery(PageBean pageBean) {
		int currentPage = pageBean.getCurrentPage();
		int pageSize = pageBean.getPageSize();
		DetachedCriteria detachedCriteria = pageBean.getDetachedCriteria();
		
		//查詢total---總數(shù)據(jù)量
		detachedCriteria.setProjection(Projections.rowCount());//指定hibernate框架發(fā)出sql的形式----》select count(*) from bc_staff;
		List<Long> countList = (List<Long>) this.getHibernateTemplate().findByCriteria(detachedCriteria);
		Long count = countList.get(0);
		pageBean.setTotal(count.intValue());
		
		//查詢r(jià)ows---當(dāng)前頁(yè)需要展示的數(shù)據(jù)集合

int firstResult = (currentPage - 1) * pageSize;
		int maxResults = pageSize;
		List rows = this.getHibernateTemplate().findByCriteria(detachedCriteria, firstResult, maxResults);
		pageBean.setRows(rows);
	}

//屬性驅(qū)動(dòng)，接收頁(yè)面提交的分頁(yè)參數(shù)
	private int page;
	private int rows;
	
	/**
	 * 分頁(yè)查詢方法
	 * @throws IOException 
	 */
	public String pageQuery() throws IOException{
		PageBean pageBean = new PageBean();
		pageBean.setCurrentPage(page);
		pageBean.setPageSize(rows);
		//創(chuàng)建離線提交查詢對(duì)象
		DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Staff.class);
		pageBean.setDetachedCriteria(detachedCriteria);
		staffService.pageQuery(pageBean);
		
		//使用json-lib將PageBean對(duì)象轉(zhuǎn)為json，通過(guò)輸出流寫回頁(yè)面中
		//JSONObject---將單一對(duì)象轉(zhuǎn)為json
		//JSONArray----將數(shù)組或者集合對(duì)象轉(zhuǎn)為json
		JsonConfig jsonConfig = new JsonConfig();
		//指定哪些屬性不需要轉(zhuǎn)json
		jsonConfig.setExcludes(new String[]{"currentPage","detachedCriteria","pageSize"});
		String json = JSONObject.fromObject(pageBean,jsonConfig).toString();
		ServletActionContext.getResponse().setContentType("text/json;charset=utf-8");
		ServletActionContext.getResponse().getWriter().print(json);
		return NONE;
	}

//修改刪除按鈕綁定的事件：
function doDelete(){
		//獲取數(shù)據(jù)表格中所有選中的行，返回?cái)?shù)組對(duì)象
		var rows = $("#grid").datagrid("getSelections");
		if(rows.length == 0){
			//沒(méi)有選中記錄，彈出提示
			$.messager.alert("提示信息","請(qǐng)選擇需要?jiǎng)h除的取派員！","warning");
		}else{
			//選中了取派員,彈出確認(rèn)框
			$.messager.confirm("刪除確認(rèn)","你確定要?jiǎng)h除選中的取派員嗎？",function(r){
				if(r){
					
					var array = new Array();
					//確定,發(fā)送請(qǐng)求
					//獲取所有選中的取派員的id
					for(var i=0;i<rows.length;i++){
						var staff = rows[i];//json對(duì)象
						var id = staff.id;
						array.push(id);
					}
					var ids = array.join(",");//1,2,3,4,5
					location.href = "staffAction_deleteBatch.action?ids="+ids;
				}
			});
		}
	}

//屬性驅(qū)動(dòng)，接收頁(yè)面提交的ids參數(shù)
	private String ids;
	
	/**
	 * 取派員批量刪除
	 */
	public String deleteBatch(){
		staffService.deleteBatch(ids);
		return LIST;
	}

/**
	 * 取派員批量刪除
	 * 邏輯刪除，將deltag改為1
	 */
	public void deleteBatch(String ids) {//1,2,3,4
		if(StringUtils.isNotBlank(ids)){
			String[] staffIds = ids.split(",");
			for (String id : staffIds) {
				staffDao.executeUpdate("staff.delete", id);
			}
		}
	}

 <!-- 取派員邏輯刪除 -->
 <query name="staff.delete">
 	UPDATE Staff SET deltag = '1' WHERE id = ?
 </query>

//數(shù)據(jù)表格綁定的雙擊行事件對(duì)應(yīng)的函數(shù)
	function doDblClickRow(rowIndex, rowData){
		//打開修改取派員窗口
		$('#editStaffWindow').window("open");
		//使用form表單對(duì)象的load方法回顯數(shù)據(jù)
		$("#editStaffForm").form("load",rowData);
	}

/**
	 * 修改取派員信息
	 */
	public String edit(){
		//顯查詢數(shù)據(jù)庫(kù)，根據(jù)id查詢?cè)紨?shù)據(jù)
		Staff staff = staffService.findById(model.getId());
		//使用頁(yè)面提交的數(shù)據(jù)進(jìn)行覆蓋
		staff.setName(model.getName());
		staff.setTelephone(model.getTelephone());
		staff.setHaspda(model.getHaspda());
		staff.setStandard(model.getStandard());
		staff.setStation(model.getStation());
		staffService.update(staff);
		return LIST;
	}