struts分页

 

Student.java

 

 

package po;

//封装一个学生资料

public class Student {

    private String stuId;

    private String stuName;

    private String stuSex;

    private String stuBir;

    private String stuAdd;

    public String getStuAdd() {

       return stuAdd;

    }

    public void setStuAdd(String stuAdd) {

       this.stuAdd = stuAdd;

    }

    public String getStuBir() {

       return stuBir;

    }

    public void setStuBir(String stuBir) {

       this.stuBir = stuBir;

    }

    public String getStuId() {

       return stuId;

    }

    public void setStuId(String stuId) {

       this.stuId = stuId;

    }

    public String getStuName() {

       return stuName;

    }

    public void setStuName(String stuName) {

       this.stuName = stuName;

    }

    public String getStuSex() {

       return stuSex;

    }

    public void setStuSex(String stuSex) {

       this.stuSex = stuSex;

    }

}

 

 

 

================================================

StudentDao.java

 

 

 

package dao;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.util.ArrayList;

 

import po.Student;

 

//访问数据库

public class StudentDao {

       private Connection conn = null;

      

       public void initConnection(){//初始化数据库连接

              try{

                     Class.forName("oracle.jdbc.driver.OracleDriver");

                     conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.240:1521:oracle","scott","tiger");

              }catch(Exception ex){ex.printStackTrace();}

       }

      

       public ArrayList queryStu(){

              ArrayList stus = new ArrayList();

              String sql = "SELECT 学号,姓名,性别,出生年月,家庭住址 FROM 学籍";

              try{

                     this.initConnection();

                     ResultSet rs = conn.createStatement().executeQuery(sql);

                     while(rs.next()){

                            Student stu = new Student();

                            stu.setStuId(rs.getString("学号"));

                            stu.setStuName(rs.getString("姓名"));

                            stu.setStuSex(rs.getString("性别"));

                            stu.setStuBir(rs.getString("出生年月"));

                            stu.setStuAdd(rs.getString("家庭住址"));

                            stus.add(stu);

                     }

              }catch(Exception ex){ex.printStackTrace();}

              finally{

                     this.closeConnection();

              }

              return stus;

       }

      

       public void deleteStuById(String stuId){

              String sql = "DELETE FROM 学籍 WHERE 学号='" + stuId + "'";

              try{

                     this.initConnection();

                     conn.createStatement().executeUpdate(sql);

              }catch(Exception ex){ex.printStackTrace();}

              finally{

                     this.closeConnection();

              }

       }

      

       public void closeConnection(){

              try{

                     if(conn!=null){

                            conn.close();

                            conn = null;

                     }

              }catch(Exception ex){ex.printStackTrace();}

       }

}

 

 

 

 

 

===========================================

PageController.java

 

 

package prj13_1;

 

import java.util.ArrayList;

 

//负责传入一个大的集合，根据页号返回所需要的数据

/*

 * 页数= 

       记录条数%每页条数＝＝0     记录条数/每页条数

       否则          记录条数/每页条数+1

       第N页显示第几条记录(记录从0开始算)? (N-1)*每页条数=<序号< N*每页条数

 * */

public class PageController {

    private ArrayList bigList;         //大的集合，外界传入

    private int curentPageIndex = 1;   //当前页号，外界传入

    private int countPerpage    = 5;   //每页条数，外界可以设定

    private ArrayList smallList;       //小的集合，返回

    private int pageCount;             //页数

    private int recordCount;        //记录条数

    private int prePageIndex;          //上一页序号

    private int nextPageIndex;         //下一页序号

    private boolean firstPage;         //是否第一页

    private boolean lastPage;          //是否最后一页

   

    public void setCurentPageIndex(int curentPageIndex) {   //每当页数改变，都会调用这个函数，筛选代码可以写在这里   

       this.curentPageIndex = curentPageIndex;

      

       //上一页，下一页确定

       prePageIndex = curentPageIndex - 1;

       nextPageIndex = curentPageIndex + 1;

       //是否第一页，最后一页

       if(curentPageIndex==1){

           firstPage = true;

       }

       else{

           firstPage = false;

       }

       if(curentPageIndex==pageCount){

           lastPage = true;

       }

       else{

           lastPage = false;

       }

       //筛选工作

       smallList = new ArrayList();

       for(int i=(curentPageIndex-1)*countPerpage; i<curentPageIndex*countPerpage&&i<recordCount; i++){

           smallList.add(bigList.get(i));

       }  

    }

    public int getCurentPageIndex() {

       return curentPageIndex;

    }

    public ArrayList getBigList() {

       return bigList;

    }

    public void setBigList(ArrayList bigList) {

       this.bigList = bigList;

       //计算条数

       recordCount = bigList.size();

       //计算页数

       if(recordCount%countPerpage==0){

           pageCount = recordCount/countPerpage;

       }

       else{

           pageCount = recordCount/countPerpage + 1;

       }

      

    }

    public int getCountPerpage() {

       return countPerpage;

    }

    public void setCountPerpage(int countPerpage) {

       this.countPerpage = countPerpage;

    }

    public ArrayList getSmallList() {

       return smallList;

    }

    public void setSmallList(ArrayList smallList) {

       this.smallList = smallList;

    }

    public int getPageCount() {

       return pageCount;

    }

    public void setPageCount(int pageCount) {

       this.pageCount = pageCount;

    }

    public int getRecordCount() {

       return recordCount;

    }

    public void setRecordCount(int recordCount) {

       this.recordCount = recordCount;

    }

    public int getNextPageIndex() {

       return nextPageIndex;

    }

    public void setNextPageIndex(int nextPageIndex) {

       this.nextPageIndex = nextPageIndex;

    }

    public int getPrePageIndex() {

       return prePageIndex;

    }

    public void setPrePageIndex(int prePageIndex) {

       this.prePageIndex = prePageIndex;

    }

    public boolean isFirstPage() {

       return firstPage;

    }

    public void setFirstPage(boolean firstPage) {

       this.firstPage = firstPage;

    }

    public boolean isLastPage() {

       return lastPage;

    }

    public void setLastPage(boolean lastPage) {

       this.lastPage = lastPage;

    }

   

 

}

 

================================================

QueryAction.java

 

package prj13_1.action;

 

import java.util.ArrayList;

 

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

 

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

 

import prj13_1.PageController;

import dao.StudentDao;

 

public class QueryAction extends Action {

 

       public ActionForward execute(ActionMapping mapping, ActionForm form,

                     HttpServletRequest request, HttpServletResponse response) {

 

              String str = request.getParameter("PageIndex");

              if(str==null)    {

                     str = "1";

              }

              int currentPageIndex = Integer.parseInt(str);             

             

              PageController pc = (PageController)request.getAttribute("pc");

              if(pc==null){

                     pc = new PageController();

                     StudentDao studentDao = new StudentDao();

                     ArrayList stus = studentDao.queryStu();     

                     pc.setBigList(stus);

                     request.setAttribute("pc", pc);                    

              }

             

              pc.setCurentPageIndex(currentPageIndex);

             

             

              return new ActionForward("/display.jsp");

       }

}

 

 

 

============================================

 

 

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>

<jsp:directive.page import="po.Student;"/>

<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>

<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>

<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>

<!DOCTYPE HTML PUBLIC "-//W 3C //DTD HTML 4.01 Transitional//EN">

<html>

  <head>   

    <title>My JSP 'queryForm.jsp' starting page</title>

  </head>

 

  <body>

   显示结果. <br>

   <table bgcolor="#ff80ff">

   <tr>

   <td>学号</td>

   <td>姓名</td>

   <td>性别</td>

   <td>出生年月</td>

   <td>家庭住址</td>

   </tr>

  <logic:iterate id="stu" name="pc" property="smallList">

   <tr>

   <td><bean:write name="stu" property="stuId"/></td>

   <td><bean:write name="stu" property="stuName"/></td>

   <td><bean:write name="stu" property="stuSex"/></td>

   <td><bean:write name="stu" property="stuBir"/></td>

   <td><bean:write name="stu" property="stuAdd"/></td>

  </tr>

  </logic:iterate>

   </table>

   <html:link action="/query.do?PageIndex=1">首页</html:link>

   <logic:equal name="pc" property="firstPage" value="false">

         <html:link action="/query.do" paramId="PageIndex" paramName="pc" paramProperty="prePageIndex">上一页</html:link>

   </logic:equal>

   <logic:equal name="pc" property="lastPage" value="false">

        <html:link action="/query.do" paramId="PageIndex" paramName="pc" paramProperty="nextPageIndex">下一页</html:link>

   </logic:equal>

   <html:link action="/query.do" paramId="PageIndex" paramName="pc" paramProperty="pageCount">尾页</html:link>

  </body>

</html>