Java的分页查询方法

package com.student.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.student.dao.StuInfoDao;
import com.student.entity.StuInfo;

public class StuInfoDaoImpl extends BaseDaoImpl implements StuInfoDao{

 public int deleteStuInfo(int[] ids) {
  Connection con=null;
  con=this.getConnection();
  PreparedStatement ps=null;  
  String sql="delete from StuInfo where stuId=?";
  try {
   ps=con.prepareStatement(sql);   
   for(int i=0;i<ids.length;i++)
   {
    ps.setInt(1,ids[i]);
    ps.addBatch();
   }
   ps.executeBatch();
  } catch (SQLException e) {   
   e.printStackTrace();
  }
  finally
  {
   this.closeConnection(con);
  }
  return 0;
 }

 public List<StuInfo> getStuInfoPage(int page, int pageSize) {
  List<StuInfo> stus=new ArrayList<StuInfo>();
  Connection con=null;
  PreparedStatement ps=null;
  ResultSet rs=null;
  con=this.getConnection();
  String sql="select top (?) * from StuInfo where stuid not in(select top (?) stuid from StuInfo )";
  try {
   ps=con.prepareStatement(sql);
   ps.setInt(1, pageSize);
   ps.setInt(2, (page-1)*pageSize);
   rs=ps.executeQuery();
   while(rs.next())
   {
    StuInfo stu=new StuInfo();
    stu.setStuid(rs.getInt("stuId"));
    stu.setStuName(rs.getString("stuName"));
    stu.setStuAddress(rs.getString("stuAddress"));
    stu.setStuSex(rs.getInt("stuSex"));
    stus.add(stu);
   }
  } catch (SQLException e) {    
   e.printStackTrace();
  }
  finally
  {   
   this.closeConnection(con);
  }  
  return stus;
 }
 /*
  *  查询总页数
  */
 public int getSumPage(int pageSize) {//参数是每页显示的条数
  int count=0;//总条数
  Connection con=null;
  PreparedStatement ps=null;
  ResultSet rs=null;
  con=this.getConnection();//获得连接
 
  try {
   String sql="select count(*) from StuInfo";
   ps=con.prepareStatement(sql);
   rs=ps.executeQuery();
   while(rs.next())
   {
    count=rs.getInt(1);//总条数---获得总条数      
   }
      return count%pageSize==0?count/pageSize:count/pageSize+1;
  } catch (SQLException e) {
   e.printStackTrace();
  }  
  finally
  {
   this.closeConnection(con);
  }
  return count;
 }
// public static void main(String[] args) {
//  StuInfoDao sid=new StuInfoDaoImpl();
//  int pageNum=sid.getSumPage(5);
//  System.out.println(pageNum);
//  
// }

}