壹、頁面內容
為了在頁面中顯示數據庫中字段內容,需要定義壹個table,通過EasyUI內部設計,自動顯示數據,如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><base href="<%=basePath%>">
<title>房產信息管理</title>
<meta .wy.action.HouseAction" method="show">
?<result type="json" name="success">
<param name="root">result</param>
?</result>
? </action>
三、對應的Action 處理類
private JSONObject result; ? //返回的json ?
private String rows; //每頁顯示的記錄數 ?
private String page; //當前第幾頁?
//顯示房產基本信息
public String show(){
//當前頁 ?
int intPage = Integer.parseInt((page == null || page == "0") ? "1":page); ?
//每頁顯示條數 ?
int number = Integer.parseInt((rows == null || rows == "0") ? "10":rows);?
//每頁的開始記錄 ?第壹頁為1 ?第二頁為number +1 ?
int start = (intPage-1)*number;?
HouseDao houseDao=new HouseDao();
ArrayList<THouse> listHouses=houseDao.getHouses(start, number); //從數據庫中查詢數據
Map<String, Object> jsonMap = new HashMap<String, Object>();//定義map ?
int count=houseDao.getHouseCount(); //求出總記錄數
//total鍵 存放總記錄數,必須的 ?
jsonMap.put("total", count);
jsonMap.put("rows", listHouses);//rows鍵 存放每頁記錄 list ?
result=JSONObject.fromObject(CommonUtil.getJsonNotNull(jsonMap));
?
return SUCCESS;
}
action 類中,rows,page 是用於EasyUI分頁操作的,EasyUI會自動向後臺傳入參數:當前頁及每頁顯示記錄數,以此實現分頁功能,此處只需要定義這兩個變量即可。{"total":5,"rows":[{"doorCard":"1-1101","id":22,"roomArea":"140","unitNum":1,"tusers":[],"isUse":"1","buildTime":"2015-04-01"},{"doorCard":"1-1202","id":29,"roomArea":"160","unitNum":1,"tusers":[],"isUse":"0","buildTime":"2015-04-06"},{"doorCard":"2-2202","id":28,"roomArea":"160","unitNum":2,"tusers":[],"isUse":"0","buildTime":"2015-04-06"},{"doorCard":"3-3301","id":26,"roomArea":"150","unitNum":3,"tusers":[],"isUse":"1","buildTime":"2015-04-13"},{"doorCard":"3-2102","id":27,"roomArea":"160","unitNum":3,"tusers":[],"isUse":"1","buildTime":"2015-04-06"}]}
五、效果截圖