struts实现数据库分页的代码及实现步骤.doc

Struts2.1实现数据分页第一步：先建数据库数据库中的数据：第二步：先建立数据库的连接数据库连接用的是数据库连接池package org;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import javax.naming.Context;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;public class DbPool private Connection conn; public void createConn()throws Exception try Context initContext = new InitialContext();Context envContext = (Context)initContext.lookup(java:/comp/env);DataSource ds = (DataSource)envContext.lookup(jdbc/mysql); conn=ds.getConnection();System.out.println(数据库连接成功); catch (Exception e) System.out.println(数据库连接失败);e.printStackTrace();public Connection getConn() throws Exceptionif(conn=null)createConn();return conn;public ResultSet executeQuery(String sql) throws ExceptionResultSet rs=null;if(conn=null)createConn();try Statement st=(Statement)this.conn.createStatement();rs=st.executeQuery(sql); catch (Exception e) e.printStackTrace();return rs;然后在下建一个context.xml用来读取配置信息 第三步：建web工程及文件部署第四步：建立相应显示数据库分页显示的jsp页面Show.jsp base href= My JSP show.jsp starting page !- 全部用户 用户ID 姓名 年龄 个人简介 第页|总共页 1 首页 1 上一页 下一页 末页 第五步：struts2.0的相关配置1. xml的配置 /showPerson.jsp 2. 需要的jar包3. allPersons的action类package action;import java.util.List;import model.Person;import com.opensymphony.xwork2.ActionSupport;import dao.PageDao;public class AllPersons extends ActionSupportprivate List persons;private int pageNumber=1;/当前页数private int pageSize=4;/每页显示的记录数private int totalPage; /所有的用户对象public List getPersons() return persons;public void setPersons(List persons) this.persons = persons;private PageDao pageDao=new PageDao();public int getPageNumber() return pageNumber;public void setPageNumber(int pageNumber) this.pageNumber = pageNumber;public int getPageSize() return pageSize;public void setPageSize(int pageSize) this.pageSize = pageSize;public int getTotalPage() return totalPage;public void setTotalPage(int totalPage) this.totalPage = totalPage;public String execute()persons=pageDao.allPersons(pageSize,pageNumber);totalPage=pageDao.getPersonAmount()/pageSize;return SUCCESS;4. pageDao的代码：package dao;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import model.PersonName;import org.DbPool;import model.Person;public class PageDao DbPool dbPool=new DbPool(); private Person person; PreparedStatement ps; ResultSet rs; public List allPersons(int pageSize,int pageNumber) List list=new ArrayList(); /String sql=select * from person limit ?,?; try / pstmt = this.getConnection().prepareStatement(/ select * from student order by stu_id limit +(pageNow*pageSize-pageSize)+,+pageSize/ ); if(pageSize0&pageNumber0) ps=dbPool.getConn().prepareStatement(select * from person order by personId limit +(pageNumber*pageSize-pageSize)+,+pageSize); / ps=dbPool.getConn().prepareStatement(/ select * from person order by personId limit +(pageNumber*pageSize-pageSize)+,+pageSize/ ); rs=ps.executeQuery();while(rs.next()person=new Person();person.setPersonId(rs.getInt(1);person.setPersonName(rs.getString(2);person.setPersonAge(rs.getInt(3);person.setPersonInfo(rs.getString(4);list.add(person); catch (Exception e) e.printStackTrace();return list; public int getPersonAmount() int i=0; String sql=select count(*) from person; PreparedStatement ps=null; try ps=dbPool.getConn().prepareStatement(sql); ResultSet rs =ps.executeQuery();if(rs.next()i=rs.getInt(1); catch (Exception e) e.printStackTrace(); return i; 5. model包中的person代码：package model;public class Person private int personId;private String personName;private String personInfo;private int personAge;public int getPersonId() return personId;public void setPersonId(int personId) this.personId = personId;public String getPersonName() return personName;public void setPersonName(String personName) this.personName = personName;public String getPersonInfo() return personInfo;public void setPersonInfo(String personInfo) this.pers