struts2 +mysql 分页显示 源码

package com.struts; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class PageDAO { private Connection conn; private PreparedStatement pstmt; private ResultSet rs; private static final String DRIVER = "com.mysql.jdbc.Driver"; private static final String URL = "jdbc:mysql://localhost/www"; private static final String USERNAME = "root"; private static final String PASSWORD = "123"; private Student student; // 数据库连接 public synchronized Connection getConnection() { try { Class.forName(DRIVER); conn = DriverManager.getConnection(URL, USERNAME, PASSWORD); } catch (ClassNotFoundException e) { e.printStackTrace(); return null; } catch (SQLException e) { e.printStackTrace(); return null; } return conn; } // 分页查询 public List<Student> queryByPage(int pageSize, int pageNow) { List<Student> list = new ArrayList<Student>(); try { if (this.getConnection() != null && pageSize > 0 && pageNow > 0) { pstmt = this.getConnection().prepareStatement( "select * from student order by stu_id limit " + (pageNow * pageSize - pageSize) + "," + pageSize); rs = pstmt.executeQuery(); while (rs.next()) { student = new Student(); student.setStu_id(rs.getInt(1)); student.setStuName(rs.getString(2)); student.setAddress(rs.getString(3)); student.setStuPhone(rs.getString(4)); list.add(student); } } } catch (SQLException e) { e.printStackTrace(); } return list; } //返回 表 记录 总数 public int getCount(int pageSize) { int count=0; try { pstmt = this.getConnection().prepareStatement("select count(stu_id) from student"); rs = pstmt.executeQuery(); rs.next(); count = Integer.parseInt(rs.getString(1)); count=(count+pageSize-1)/pageSize; } catch (SQLException e) { e.printStackTrace(); } return count; } }