struts2 分页

作者：ThirdteenDevil 十三妖

qq : 181907667

 

 

如果用的是struts1 请见struts1分页的文章 此片文章是介绍struts2分页的

 

思路：struts2用的是Action ，并没有ActionForm,所有表单的信息都封装在Action中，所以建立一个分页的信息类Page.java 记录当前页，最大页，每页记录数等信息，然后在action引入的service中进行分页就可以了 

 

添加Page类

package com.thd.bean;

public class Page {
	
	public Page(){
		this.currentPage = 1;
	}
	
	//最大页数
	private int maxPage;
	//当前页
	private int currentPage;
	//一页记录数
	private int pageSize;
	//最大记录数
	private int listSize;
	
	public int getMaxPage() {
		return maxPage;
	}
	public void setMaxPage(int maxPage) {
		this.maxPage = maxPage;
	}
	public int getCurrentPage() {
		return currentPage;
	}
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public int getListSize() {
		return listSize;
	}
	public void setListSize(int listSize) {
		this.listSize = listSize;
	}
}

 

 

拷贝page.jsp到项目中

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ include file="tag.jsp"%>
<style type="text/css">
#dividPage{height:20px;line-height:20px;text-align:right;margin-top:5px;}
#pages a{display:inline-block;border-bottom:2px solid #ccc;text-decoration:none;margin-right:5px;height:12px;line-height:12px;padding:0px 2px;}
#pages a.current{border-bottom:0px;font-weight:bold;}
#pages a:link{color:#aaa;}
#pages a:visited{color:#aaa;}
#pages a:hover{color:#aaa;}
#pages a:active{color:#aaa;}
#pages a:link.current{color:#333;}
#pages a:visited.current{color:#333;}
#pages a:hover.current{color:#333;}
#pages a:active.current{color:#333;}
</style>
<div id="dividPage">
共<span id="listSize"></span>条记录
<span id="pages">
</span>
<s:hidden name="page.currentPage" id="cp"></s:hidden>
共<span id="maxPage"></span>页
当前第<span id="currentPage"></span>页
</div>
<script type="text/javascript">
var maxPage = <s:property value="page.maxPage"/>;
var listSize = <s:property value="page.listSize"/>;
var currentPage = <s:property value="page.currentPage"/>;
var formId = "<%= request.getParameter("formId") %>";
document.getElementById("maxPage").innerHTML = maxPage;
document.getElementById("listSize").innerHTML = listSize;
document.getElementById("currentPage").innerHTML = currentPage;
function formSMT(cp){
	document.getElementById("cp").value = cp;
	document.getElementById(formId).submit();
}
for(var i = 1 ; i <= maxPage ; i++){
	var lk = document.createElement("a");
	lk.setAttribute("cp",i);
	lk.innerHTML = i;
	lk.href = "#";
	document.getElementById("pages").appendChild(lk);
	if (i == currentPage){
		lk.className = "current";		
	}else{
		lk.onclick = function(){
			formSMT(this.getAttribute("cp"));
		}
	}
}
</script>

			

 

在需要分页的页面中引入page.jsp

<jsp:include page="../pub/page.jsp">
	<jsp:param name="formId" value="materialQueryForm"/>
</jsp:include>

 其中materialQueryForm是查询表单的id,点击分页的页码后js调用这个表单对象的submit()方法

 

 

DAO类

package com.thd.dao;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class DaoImpl extends HibernateDaoSupport {

	public void save(Object obj) {
		this.getHibernateTemplate().save(obj);
	};

	public void update(Object obj) {
		this.getHibernateTemplate().update(obj);
	}

	public void delete(Object obj) {
		this.getHibernateTemplate().delete(obj);
	}
	
	public List findByHql(String hql){
		return this.getHibernateTemplate().find(hql);
	}
	
	public Object findById(Class c,Serializable id){
		return this.getHibernateTemplate().get(c, id);
	}
	

	public List findBySql(final String sql) {
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session) {
				Query query = session.createSQLQuery(sql);
				return query.list();
			}
		});
	}

	public void executeSql(final String sql) {
		this.getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session) {
				Query query = session.createSQLQuery(sql);
				query.executeUpdate();
				return null;
			}
		});
	}
	
	public List findPageSql( final String sql,final int currpage, final int rowsNum, final int maxResult) {
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
								Query query = s.createSQLQuery(sql);
				
				if (rowsNum != -1) {
					query.setFirstResult((currpage - 1) * maxResult);
					query.setMaxResults(maxResult);
				}
				List list = query.list();
				return list;
			}
		});
	}

}

	

 

 

service类

public List queryMaterial(Tit tit,Page page){
		String sql = "select "+
		"t.id," +
		"t.tit," + 
		"t.des," +
		"t.idate," +
		"d.tname " +
		" from tit t left join dic d on t.dic = d.id where 1=1 ";
		
		if(tit != null){
			if((tit.getTit() != null) && !"".equals(tit.getTit())){
				sql += " and t.tit like '%" + tit.getTit() + "%'";
			}
			
			if(tit.getDic() != null){
				sql += " and d.id = " + tit.getDic();
			}
		}
		sql += " order by t.idate desc";
		
		page.setPageSize(5);//设置每一页的条目数量
		List l = this.getDao().findBySql(sql);
		  if(l != null){
		        int rowsNum = l.size();   
		        int temp = rowsNum % page.getPageSize(); //取模   
		        int pageNum = 0;   
		        if (temp > 0) {//如果有余数   
		            pageNum = rowsNum / page.getPageSize() + 1;   
		        } else if (temp == 0)   
		            pageNum = rowsNum / page.getPageSize();   
		        page.setListSize(rowsNum);//设置总记录条数
		        page.setMaxPage(pageNum);// 设置最大页数
		       System.out.println(page.getListSize());
		       System.out.println(page.getMaxPage());
		        return dao.findPageSql(sql, page.getCurrentPage(), rowsNum, page.getPageSize());   
		    }else{   
		        return null;   
		    }  
		
	}
	

 

 

Action中加入Page类

private Page page;

public Page getPage() {
	return page;
}

public void setPage(Page page) {
	this.page = page;
}

 

Action查询部分代码

public String materialQuery(){
		//如果不是表单提交要判断page对象是不是为空
    	if(null == page){
    		page = new Page();
    	}
    	List l = this.getMaterialService().queryMaterial(tit,page);
    	this.getRequest().setAttribute("l",l);
    	return "materialQuery";
}