学步园

在网上看到一个不错的S2SH分页方案，原地址忘了，把代码贴出来备用。

package domain;<br /> import java.io.Serializable;<br /> import java.sql.Date;<br /> public class TbUser implements Serializable {<br /> private Integer id;<br /> private String name;<br /> private String gender;<br /> private Integer age;<br /> private Date birthday;<br /> private String phone;<br /> private String address;<br /> private String username;<br /> private String password;</p> <p> /*省略get(),set()*/<br /> }<br />

TbUser.hbm.xml

<?xml version="1.0" encoding="utf-8"?><br /> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"<br /> "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><br /> <hibernate-mapping package="domain"><br /> <class name="TbUser" table="tb_user"><br /> <id name="id" type="java.lang.Integer"><br /> <column name="id" /><br /> <generator class="native" /><br /> </id><br /> <property name="name" type="java.lang.String"><br /> <column name="name" length="20"/><br /> </property><br /> <property name="gender" type="java.lang.String"><br /> <column name="gender" length="6"/><br /> </property><br /> <property name="age" type="java.lang.Integer"><br /> <column name="age"/><br /> </property><br /> <property name="birthday" type="java.sql.Date"><br /> <column name="birthday"/><br /> </property><br /> <property name="phone" type="java.lang.String"><br /> <column name="phone" length="11"/><br /> </property><br /> <property name="address" type="java.lang.String"><br /> <column name="address" length="50"/><br /> </property><br /> <property name="username" type="java.lang.String"><br /> <column name="username" length="20" not-null="true" /><br /> </property><br /> <property name="password" type="java.lang.String"><br /> <column name="password" length="20" not-null="true" /><br /> </property><br /> </class><br /> </hibernate-mapping><br />

package dao;<br /> import org.hibernate.HibernateException;<br /> import org.hibernate.Session;<br /> import org.hibernate.cfg.Configuration;<br /> public class HibernateSessionFactory {<br /> private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";<br /> private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();<br /> private static Configuration configuration = new Configuration();<br /> private static org.hibernate.SessionFactory sessionFactory;<br /> private static String configFile = CONFIG_FILE_LOCATION;<br /> static {<br /> try {<br /> configuration.configure(configFile);<br /> sessionFactory = configuration.buildSessionFactory();<br /> } catch (Exception e) {<br /> System.err<br /> .println("%%%% Error Creating SessionFactory %%%%");<br /> e.printStackTrace();<br /> }<br /> }<br /> private HibernateSessionFactory() {<br /> }</p> <p> public static Session getSession() throws HibernateException {<br /> Session session = (Session) threadLocal.get();<br /> if (session == null || !session.isOpen()) {<br /> if (sessionFactory == null) {<br /> rebuildSessionFactory();<br /> }<br /> session = (sessionFactory != null) ? sessionFactory.openSession()<br /> : null;<br /> threadLocal.set(session);<br /> }<br /> return session;<br /> }<br /> public static void rebuildSessionFactory() {<br /> try {<br /> configuration.configure(configFile);<br /> sessionFactory = configuration.buildSessionFactory();<br /> } catch (Exception e) {<br /> System.err<br /> .println("%%%% Error Creating SessionFactory %%%%");<br /> e.printStackTrace();<br /> }<br /> }<br /> public static void closeSession() throws HibernateException {<br /> Session session = (Session) threadLocal.get();<br /> threadLocal.set(null);<br /> if (session != null) {<br /> session.close();<br /> }<br /> }<br /> public static org.hibernate.SessionFactory getSessionFactory() {<br /> return sessionFactory;<br /> }<br /> public static void setConfigFile(String configFile) {<br /> HibernateSessionFactory.configFile = configFile;<br /> sessionFactory = null;<br /> }<br /> public static Configuration getConfiguration() {<br /> return configuration;<br /> }<br /> }

package dao;<br /> import util.Page;<br /> import domain.TbUser;<br /> public interface UserDAO {</p> <p> public TbUser findByUsernamePassword(String username,String password);</p> <p> public Page findByPageNo(int pageNo,int pageSize);<br /> }<br />

package dao;<br /> import org.hibernate.Query;<br /> import org.hibernate.Session;<br /> import util.Page;<br /> import domain.TbUser;<br /> public class UserDAOImpl implements UserDAO {<br /> private Session session = HibernateSessionFactory.getSession();<br /> public Page findByPageNo(int pageNo, int pageSize) {<br /> Page page = new Page();<br /> Query query = session.createQuery("select count(*) from TbUser");<br /> int count = Integer.parseInt(query.uniqueResult().toString());</p> <p> query = session.createQuery("from TbUser");<br /> query.setMaxResults(pageSize);<br /> query.setFirstResult((pageNo-1)*pageSize);</p> <p> page.setList(query.list());<br /> page.setTotal(count);<br /> page.setPageNo(pageNo);<br /> page.setPageSize(pageSize);</p> <p> return page;<br /> }<br /> public TbUser findByUsernamePassword(String username, String password) {<br /> String hql = "from TbUser where username=? and password=?";<br /> Query query = session.createQuery(hql);<br /> query.setParameter(0, username);<br /> query.setParameter(1, password);<br /> return (TbUser) query.uniqueResult();<br /> }<br /> }<br />

package service;<br /> import util.Page;<br /> import domain.TbUser;<br /> public interface UserService {</p> <p> public TbUser findByUsernamePassword(String username,String password);</p> <p> public Page findByPageNo(int pageNo,int pageSize);<br /> }<br />

package service;<br /> import util.Page;<br /> import dao.UserDAO;<br /> import domain.TbUser;<br /> public class UserServiceImpl implements UserService {<br /> private UserDAO userDAO;</p> <p> public Page findByPageNo(int pageNo, int pageSize) {<br /> return userDAO.findByPageNo(pageNo, pageSize);<br /> }<br /> public TbUser findByUsernamePassword(String username, String password) {<br /> return userDAO.findByUsernamePassword(username, password);<br /> }<br /> public void setUserDAO(UserDAO userDAO) {<br /> this.userDAO = userDAO;<br /> }<br /> public UserDAO getUserDAO() {<br /> return userDAO;<br /> }<br /> }<br />

package util;<br /> import java.util.List;<br /> public class Page {<br /> private int total;<br /> private int pageSize;<br /> private int totalPage;<br /> private int pageNo;<br /> private int prePage;<br /> private int nextPage;<br /> private List list;</p> <p> public int getTotal() {<br /> return total;<br /> }<br /> public void setTotal(int total) {<br /> this.total = total;<br /> }<br /> public int getPageSize() {<br /> return pageSize;<br /> }<br /> public void setPageSize(int pageSize) {<br /> this.pageSize = pageSize;<br /> }<br /> public int getTotalPage() {<br /> if(total%pageSize == 0){<br /> totalPage = total/pageSize;<br /> }else{<br /> totalPage = total/pageSize + 1;<br /> }<br /> return totalPage;<br /> }<br /> public void setTotalPage(int totalPage) {<br /> this.totalPage = totalPage;<br /> }<br /> public int getPageNo() {<br /> return pageNo;<br /> }<br /> public void setPageNo(int pageNo) {<br /> this.pageNo = pageNo;<br /> }<br /> public int getPrePage() {<br /> if(pageNo == 1){<br /> prePage = pageNo;<br /> }else{<br /> prePage = pageNo - 1;<br /> }<br /> return prePage;<br /> }<br /> public void setPrePage(int prePage) {<br /> this.prePage = prePage;<br /> }<br /> public int getNextPage() {<br /> if(pageNo == totalPage){<br /> nextPage = pageNo;<br /> }else{<br /> nextPage = pageNo + 1;<br /> }<br /> return nextPage;<br /> }<br /> public void setNextPage(int nextPage) {<br /> this.nextPage = nextPage;<br /> }<br /> public List getList() {<br /> return list;<br /> }<br /> public void setList(List list) {<br /> this.list = list;<br /> }<br /> }<br />

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?><br /> <beans xmlns="http://www.springframework.org/schema/beans"<br /> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br /> xsi:schemaLocation="http://www.springframework.org/schema/beans<br /> http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><br /> <bean id="sessionFactory"<br /> class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><br /> <property name="configLocation"<br /> value="classpath:hibernate.cfg.xml" /><br /> </bean><br /> <bean id="userDAO" class="dao.UserDAOImpl"/></p> <p> <bean id="userService" class="service.UserServiceImpl"><br /> <property name="userDAO"><br /> <ref local="userDAO"/><br /> </property><br /> </bean></p> <p> <bean id="loginAction" class="action.UserAction"><br /> <property name="userService"><br /> <ref local="userService"/><br /> </property><br /> </bean><br /> </beans>

hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?><br /> <!DOCTYPE hibernate-configuration PUBLIC<br /> "-//Hibernate/Hibernate Configuration DTD 3.0//EN"<br /> "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><br /> <hibernate-configuration><br /> <session-factory><br /> <property name="connection.username">root</property><br /> <property name="connection.url">jdbc:mysql://localhost:3306/mydb</property><br /> <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property><br /> <property name="connection.driver_class">com.mysql.jdbc.Driver</property><br /> <property name="connection.password">1101</property><br /> <property name="show_sql">true</property><br /> <property name="format_sql">true</property><br /> <property name="hbm2ddl.auto">update</property></p> <p> <mapping resource="domain/TbUser.hbm.xml"/></p> <p> </session-factory><br /> </hibernate-configuration>

native_zh_CN.properties

user.username=/u7528/u6237/u540d<br /> user.password=/u5bc6/u7801<br /> login=/u767b/u5f55

struts.xml

<?xml version="1.0" encoding="UTF-8"?><br /> <!DOCTYPE struts PUBLIC<br /> "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"<br /> "http://struts.apache.org/dtds/struts-2.0.dtd"><br /> <struts><br /> <constant name="struts.ui.theme" value="simple"/><br /> <constant name="struts.custom.i18n.resources" value="native"/><br /> <constant name="struts.objectFactory" value="spring"/><br /> <package name="user" namespace="/user" extends="struts-default"><br /> <action name="*" class="loginAction" method="{1}"><br /> <result name="success">/index.jsp</result><br /> <result name="input">/login.jsp</result><br /> <result name="browse">/index.jsp</result><br /> </action><br /> </package><br /> </struts>

login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"<br /> pageEncoding="UTF-8"%><br /> <%@ taglib prefix="s" uri="/struts-tags" %><br /> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br /> <html><br /> <head><br /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><br /> <title>登录</title><br /> </head><br /> <body><br /> <fieldset><br /> <legend>系统登录</legend><br /> <s:form action="user/login" method="post"><br /> <s:text name="user.username"/><s:textfield name="username" key="user.username" label="%{getText('user.username')}"/><br /> <s:text name="user.password"/><s:password name="password" key="user.password" label="%{getText('user.password')}"/><br /> <s:submit key="login"/><br /> </s:form><br /> </fieldset><br /> </body><br /> </html>

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"<br /> pageEncoding="UTF-8"%><br /> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><br /> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br /> <html><br /> <head><br /> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><br /> <title>首页</title><br /> </head><br /> <body><br /> ${message }<hr/><br /> <a href="user/browse" mce_href="user/browse">用户列表</a><br/><br /> <table><br /> <tr><br /> <th>ID</th><br /> <th>姓名</th><br /> <th>性别</th><br /> <th>年龄</th><br /> <th>生日</th><br /> <th>电话</th><br /> <th>地址</th><br /> </tr><br /> <c:forEach items="${userList}" var="user"><br /> <tr><br /> <td>${user.id }</td><br /> <td>${user.name }</td><br /> <td>${user.gender }</td><br /> <td>${user.age }</td><br /> <td>${user.phone }</td><br /> <td>${user.address }</td><br /> </tr><br /> </c:forEach><br /> </table><br /> 共${page.totalPage }页|当前第${page.pageNo }页|共${page.total }条记录<br/><br /> <!-- 分页列表 --><br /> <c:if test="${page.totalPage != 1}"><br /> <!-- 首页情况 --><br /> <c:if test="${page.pageNo == 1}"><br /> <font color="gray">首页 上一页</font><br /> <a href="user/browse?pageNo=${page.nextPage }" mce_href="user/browse?pageNo=${page.nextPage }">下一页</a><br /> <a href="user/browse?pageNo=${page.totalPage }" mce_href="user/browse?pageNo=${page.totalPage }">尾页</a><br /> </c:if><br /> <!-- 尾页情况 --><br /> <c:if test="${page.pageNo == page.totalPage}"><br /> <a href="user/browse?pageNo=1" mce_href="user/browse?pageNo=1">首页</a><br /> <a href="user/browse?pageNo=${page.prePage }" mce_href="user/browse?pageNo=${page.prePage }">上一页</a><br /> <font color="gray">下一页 尾页</font><br /> </c:if><br /> <!-- 普通情况 --><br /> <c:if test="${page.pageNo!=1 and page.pageNo!=page.totalPage}"><br /> <a href="user/browse?pageNo=1" mce_href="user/browse?pageNo=1">首页</a><br /> <a href="user/browse?pageNo=${page.prePage }" mce_href="user/browse?pageNo=${page.prePage }">上一页</a><br /> <a href="user/browse?pageNo=${page.nextPage }" mce_href="user/browse?pageNo=${page.nextPage }">下一页</a><br /> <a href="user/browse?pageNo=${page.totalPage }" mce_href="user/browse?pageNo=${page.totalPage }">尾页</a><br /> </c:if><br /> </c:if><br /> <!-- 分页列表 --><br /> </body><br /> </html>