import java.util.Vector;

public class PageInfo {
private int totalPage;//总共有多少页
private int resultCount;//总共有多少条纪录
private int page;//目前的页数
private int previousPage;//上一页
private int nextpage;//下一页

public void setTotalPage(int totalPage){
this.totalPage=totalPage;
}
public int getTotalPage(){
return totalPage;
}
//-------------------------------------------
public void setResultCount(int count){
this.resultCount=count;
}
public int getResultCount(){
return resultCount;
}
//-------------------------------------------
public void setPage(int page){
this.page=page;
}
public int getpage(){
return page;
}
//-------------------------------------------
public void setPreviousPage(int page){
this.previousPage=page;
}
public int getPreviousPage(){
return (this.page-1);
}
//-------------------------------------------
public void setNextPage(int page){
this.nextpage=page;
}
public int getNextPage(){
return (this.page+1);
}

//-------------------------------------------
/**
* 根据传来的数组生成一个PageInfo对象
* 我们约定数组中的index为0的为总页数
* index为1的纪录总数
* @param info
* @return
*/
public static PageInfo load(int[] info){
PageInfo pageinfo =new PageInfo();
int intValue=0;

intValue=info[0];
if(intValue > 0)
pageinfo.setTotalPage(intValue);

intValue=info[1];
if(intValue > 0)
pageinfo.setResultCount(intValue);

return pageinfo;
}
}

import java.sql.Connection;
import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.SQLException;

public class EvaluateDateBase {
/**
*根据方法中的数据表的名称，连接，每页出现的纪录数方法返回一个PageInfo的实例
*/
public static PageInfo getPageInfo(String datebase,Connection conn,int pageSize) throws SQLException{
int totalPage=0;
int resultCount=0;
int[] info=new int[2];
String sql="";
if(conn==null)
throw new SQLException("No Conn in EvaluateDateBase");

ResultSet rsCount=null;

PreparedStatement psmt=null;

sql="select count(*) from "+datebase;//根据数据库的名字得到相对应的SQL语句

try{
psmt=conn.prepareStatement(sql);
rsCount=(ResultSet)psmt.executeQuery();
rsCount.next();
resultCount=rsCount.getInt(1);
rsCount.close();
}catch(SQLException e){
e.printStackTrace();
}

totalPage = (resultCount+pageSize-1) / pageSize;//统计总页数
//还记得我们的约定吗？
// index为0的为总页数，index为1的为纪录总数
info[0]=totalPage;
info[1]=resultCount;
PageInfo pageinfo=PageInfo.load(info);
return pageinfo;
}
}

import java.sql.Connection;
import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.SQLException;
import java.util.LinkedList;

public class MoreFootball {
Connection conn;
public void setConn(Connection conn){
this.conn=conn;
}

public LinkedList getFootballList(int page,int pageSize) throws SQLException{

LinkedList footballList;
if(conn==null)
throw new SQLException("No Connection in MoreFootball");
PreparedStatement pstmt = null;
ResultSet rs = null;
footballList=new LinkedList();

try{
pstmt = conn.prepareStatement("select * from football order by date desc");
rs = (ResultSet)pstmt.executeQuery();
//根据目前需要显示的页数和每一页要求显示的纪录条数移动数据库的指针
int i = (page-1) * pageSize;

//由于不能定位到0这个位置
if(i!=0)
rs.absolute(i);//如果i为10，那么数据库的指针将会移动到第十条数据上
/*
for(int j=0;j<i;j++)
rs.next();
*/
int ii=0;
while(rs.next() && ii<pageSize){
footballList.add(Football.load(rs));
ii++;
}
}catch(SQLException e){
e.printStackTrace();
}
finally {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
}

return footballList;
}
}

import vod.model.PageInfo;
import vod.model.MoreFootball;
import vod.model.EvaluateDateBase;
import java.io.IOException;
import java.util.LinkedList;
import java.util.Locale;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.util.MessageResources;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;

public class MoreFootballAction extends Action {
Connection connection;
LinkedList footballList;

public ActionForward perform(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException{

ActionErrors errors = new ActionErrors();
HttpSession session = request.getSession();

int page=0;//目前需要的页数
int pageSize=0;//每页显示多少条数据
PageInfo footballPageInfo=null;//关于页数的相关信息
String tempPage;

//从web.xml文件中取得每页显示的条目数（我设置为10条）
pageSize=Integer.parseInt((String)servlet.getServletContext().getInitParameter("pageSize"));

//如果没有明确页数那么默认为第一页
tempPage=request.getParameter("page");
if(tempPage==null)
tempPage="1";
page=Integer.parseInt(tempPage);

try {
DataSource dataSource =servlet.findDataSource(null);
connection =dataSource.getConnection();
//检查session中是否已经存在了PageInfo，如果没有就执行查询,并且将footballPageInfo
//放入session之中
//如果已经存在的话直接从session中读取
if(session.getAttribute("footballPageInfo")==null){
//参数分别为数据表名称，连接，每一页显示多少条目
footballPageInfo=EvaluateDateBase.getPageInfo("football",connection,pageSize);
}else{
footballPageInfo=(PageInfo)session.getAttribute("footballPageInfo");
}

if(page > footballPageInfo.getTotalPage()){
page=footballPageInfo.getTotalPage();
}else if(page < 0){
page=1;
}
//设置footballPageInfo中的上一页和下一页的数值
footballPageInfo.setPage(page);
//将footballPageInfo放入session
session.setAttribute("footballPageInfo",footballPageInfo);

footballList=new LinkedList();
MoreFootball morefootball=new MoreFootball();
morefootball.setConn(connection);//设置数据的连接
//根据需要的页数和每页显示的页数条数得到LinkedList
footballList=morefootball.getFootballList(page,pageSize);
if (footballList==null) {
saveErrors(request, errors);
return (new ActionForward("No footballList in vod.controller.MoreFootallAction"));
}

session.setAttribute("footballList",footballList);//将取得的footballList放入session

//do what you wish with myConnection
} catch (SQLException sqle) {
getServlet().log("Connection.process", sqle);
} finally {
//enclose this in a finally block to make
//sure the connection is closed
if(connection!=null)
try {
connection.close();
} catch (SQLException e) {
getServlet().log("Connection.close", e);
}
}

return (mapping.findForward("success"));
}
}

<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.0//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd">

<!--
This is the Struts configuration file for the example application,
using the proposed new syntax.

NOTE: You would only flesh out the details in the "form-bean"
declarations if you had a generator tool that used them to create
the corresponding Java classes for you. Otherwise, you would
need only the "form-bean" element itself, with the corresponding
"name" and "type" attributes.
-->

<struts-config>

<!-- ========== Data Source Configuration =============================== -->
<data-sources>
<data-source>
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="Data Source Configuration"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxCount"
value="200"/>
<set-property property="minCount"
value="20"/>
<set-property property="password"
value="sailing"/>
<set-property property="url"
value="jdbc:mysql://localhost/gdmovie"/>
<set-property property="user"
value="DateBase"/>
</data-source>
</data-sources>

<!-- ========== Form Bean Definitions =================================== -->
<form-beans>

<!-- Football form bean -->
<form-bean name="footballForm"
type="vod.model.footballForm"/>

<!-- Fun form bean -->
<form-bean name="funForm"
type="vod.model.funForm"/>

<!-- Movie form bean -->
<form-bean name="movieForm"
type="vod.model.movieForm"/>

<!-- MTV form bean -->
<form-bean name="mtvForm"
type="vod.model.mtvForm"/>

</form-beans>

<!-- ========== Global Forward Definitions ============================== -->
<global-forwards>
<forward name="welcome" path="/welcome.do"/>
</global-forwards>

<!-- ========== Action Mapping Definitions ============================== -->
<action-mappings>

<!-- Enter into welcome Page -->
<action path="/welcome"
type="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>

<!-- Enter into morefootball Page -->
<action path="/morefootball"
type="vod.controller.MoreFootballAction">
<forward name="success" path="/morefootball.jsp"/>
</action>

<!-- Enter into viewfootball Page -->
<action path="/viewfootball"
type="vod.controller.ViewFootballAction">
<forward name="success" path="/viewfootball.jsp"/>
</action>

</action-mappings>

</struts-config>

<action-mappings>

<!-- Global Forward Declarations -->
<forward name="welcome" path="/welcome.do"/>

<!-- Process a user logon -->
<action path="/welcome"
actionClass="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>
<action path="/morefootball"
actionClass="vod.controller.MoreFootballAction">
<forward name="success" path="/morefootball.jsp"/>
</action>
<action path="/viewfootball"
actionClass="vod.controller.ViewFootballAction">
<forward name="success" path="/viewfootball.jsp"/>
</action>

</action-mappings>