一.DAO实现
二.page對象
四.頁面設置
- public List<History> queryHistroyByPage(Page page) {
- Session session = getSession();
- page.setTotalRows(getTotalRows(session));
- DetachedCriteria dc = DetachedCriteria.forClass(History.class);
- Criteria criteria = dc.getExecutableCriteria(session);
- List list = criteria.setMaxResults(page.getPageSize()).setFirstResult(
- page.getStartRow()).list();
- session.close();
- return list;
- }
- private int getTotalRows(Session session) {
- DetachedCriteria dc = DetachedCriteria.forClass(History.class);
- Criteria criteria = dc.getExecutableCriteria(session);
- int totalRows = (Integer) criteria
- .setProjection(Projections.rowCount()).list().get(0);
- return totalRows;
- }
二.page對象
- public class Page {
- private int pageSize = 10;
- private int currentPage;
- private int totalPages;
- private int totalRows;
- private int startRow;
- private List historiesList=new ArrayList();
- public List getHistoriesList() {
- return historiesList;
- }
- public void setHistoriesList(List historiesList) {
- this.historiesList = historiesList;
- }
- public int getCurrentPage() {
- if(currentPage==0){
- return 1;
- }
- 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 getStartRow() {
- return pageSize*(currentPage-1);
- }
- public void setStartRow(int startRow) {
- this.startRow = startRow;
- }
- public int getTotalPages() {
- if(totalRows % pageSize==0){
- return totalRows/pageSize;
- }else{
- return totalRows/pageSize+1;
- }
- }
- public void setTotalPages(int totalPages) {
- this.totalPages = totalPages;
- }
- public int getTotalRows() {
- return totalRows;
- }
- public void setTotalRows(int totalRows) {
- this.totalRows = totalRows;
- }
- }
- public Page queryHistoryByPageNum(int pageNum) {
- Page page=new Page();
- page.setCurrentPage(pageNum);
- List list=subBankDAO.queryHistroyByPage(page);
- page.setHistoriesList(list);
- return page;
- }
- pageSize: ${page.pageSize} <br/>
- currentPage: ${page.currentPage} <br/>
- totalPages: ${page.totalPages} <br/>
- <form action="showhistory.html" method="post">
- 输入你想查看的页码:<input type="text" name="pageNum" id="pageNum"/>
- <input type="submit" value="submit" /><br/>
- <#list page.historiesList as x>
- ${x.id}---${x.userId}---${x.userName}---${x.amount}---${x.status} <br/>
- </#list>