华水

<table id="list"></table>
<div id="pager"></div><!--分页专用,如果要使用分页导航必须有该标记-->

jQuery("#grid_id").jqGrid({
...
   pager : '#pager',
...
});

jQuery("#grid_id").jqGrid({
...
   pager : '#pager',
   emptyrecords: "Nothing to display",
...
});

<script>
...
jQuery("#grid_id").setGridParam({rowNum:10}).trigger("reloadGrid");
...
</script>

	/*
	 * 分页
	 */
	private Integer page;// 当前页
	private Integer total;// 总页数
	private Integer pageSize = 20;// 每页显示多少
	private Integer records;// 总记录数
	private List<StudentBean> rows;// 记录

public class Page {
 
	private int count = 0; // 记录总数
 
	private int pageSize = 20; // 每页显示记录数
 
	private int pageCount = 0; // 总页数
 
	private int page = 1; // 当前页数
 
	private String totalCountSQL;// 得到总记录数sql语句
 
	private String listSQL;// 得到查询记录sql语句
 
	public int getCount() {
		return count;
	}
 
	public void setCount(int count) {
		this.count = count;
	}
 
	public int getPageSize() {
		return pageSize;
	}
 
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
 
	public int getPageCount() {
		return pageCount;
	}
 
	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}
 
	public int getPage() {
		return page;
	}
 
	public void setPage(int page) {
		this.page = page;
	}
 
	public String getTotalCountSQL() {
		return totalCountSQL;
	}
 
	public void setTotalCountSQL(String totalCountSQL) {
		this.totalCountSQL = totalCountSQL;
	}
 
	public String getListSQL() {
		return listSQL;
	}
 
	public void setListSQL(String listSQL) {
		this.listSQL = listSQL;
	}
 
}

public interface IPage {
 
 
 
	public List getList(PageBean page);
	public List getList(PageBean page, Map param);
 
 
	public Long getTotalCount(PageBean p,Map param);
 
	public Long getTotalCount(PageBean page);
 
 
}

@Service("page")
@SuppressWarnings("unchecked")
public class PageImpl implements IPage {
	@Resource
	private SessionFactory sessionFactory;
 
 
	public List getList(PageBean page) {
		Query query = sessionFactory.getCurrentSession().createQuery(
				page.getListSQL());
		query.setMaxResults(page.getPageSize());
		query.setFirstResult((page.getPage() - 1) * page.getPageSize());
		return query.list();
	}
 
	public List getList(PageBean page, Map param) {
 
		Query query = sessionFactory.getCurrentSession().createQuery(
				page.getListSQL());
		if (null != param) {
			Iterator it = param.entrySet().iterator();
			while (it.hasNext()) {
				Map.Entry entry = (Map.Entry) it.next();
				String key = (String) entry.getKey();
				Object val = entry.getValue();
				query.setParameter(key, val);
 
			}
		}
		return query.list();
	}
 
	public Long getTotalCount(PageBean p, Map param) {
		Query query = sessionFactory.getCurrentSession().createQuery(p.getTotalCountSQL());
		if (null != param) {
			Iterator it = param.entrySet().iterator();
			while (it.hasNext()) {
				Map.Entry entry = (Map.Entry) it.next();
				String key = (String) entry.getKey();
				Object val = entry.getValue();
				query.setParameter(key, val);
 
			}
		}
		return (Long) query.uniqueResult();
	}
 
	public Long getTotalCount(PageBean p) {
 
		return (Long) sessionFactory.getCurrentSession().createQuery(p.getTotalCountSQL()).uniqueResult();
	}
 
}

@ParentPackage("json-default")
@Namespace("/admin/json")
public class StudentListAction implements ServletRequestAware {
 
	@Resource
	private IPaginate paginate;
	private HttpServletRequest request;
 
	/*
	 * 分页
	 */
	private Integer page;// 当前页
	private Integer total;// 总页数
	private Integer pageSize = 20;// 每页显示多少
	private Integer records;// 总记录数
	private List<StudentBean> rows;// 记录
 
	public StudentListAction() {
		System.out.println(new Date());
 
	}
 
	public Integer getPage() {
		return page;
	}
 
	public void setPage(Integer page) {
		this.page = page;
	}
 
	public Integer getTotal() {
		return total;
	}
 
	public void setTotal(Integer total) {
		this.total = total;
	}
 
	@JSON(serialize = false)
	public Integer getPageSize() {
		return pageSize;
	}
 
	public void setPageSize(Integer pageSize) {
		this.pageSize = pageSize;
	}
 
	public Integer getRecords() {
		return records;
	}
 
	public void setRecords(Integer records) {
		this.records = records;
	}
 
	public List<StudentBean> getRows() {
		return rows;
	}
 
	public void setRows(List<StudentBean> rows) {
		this.rows = rows;
	}
 
	public void setServletRequest(HttpServletRequest request) {
		this.request = request;
 
	}
 
	@Action(value = "jsondata", results = { @Result(type = "json") })
	public String execute() throws Exception {
		get();
 
		return com.opensymphony.xwork2.Action.SUCCESS;
	}
 
	@SuppressWarnings("unchecked")
	private void get() throws Exception {
		PageBean pageBean = new PageBean();
		pageBean.setPage(page);
		pageBean.setPageSize(pageSize);
		JqGridHandler handler = new JqGridHandler(request);
		pageBean.setTotalCountSQL("select count(*) from Student "
				+ handler.getWheres(null, false)
				+ handler.getOrders(null, false));
		pageBean.setListSQL("from Student "
				+ handler.getWheres(null, false)
				+ handler.getOrders(null, false));
		pageBean.setCount(paginate.getTotalCount(pageBean).intValue());
 
		List<Student> list = paginate.getList(pageBean);
		rows = new ArrayList<StudentBean>();
		for (Student student : list) {
			StudentBean bean = new StudentBean();
			bean.setAge(student.getAge());
			bean.set__department_id(student.getDepartment().getId());
			bean.setId(student.getId());
			bean.setName(student.getName());
			bean.setSex(student.getSex());
			bean.setDate(student.getDate());
			rows.add(bean);
		}
		total = pageBean.getPageCount();
		records = pageBean.getCount();
	}
 
}