java 分页(1)

package com.stu.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.stu.entity.Student;

public class StudentDAO {
 protected static final int PAGE_SIZE=3;
 public List<Student> queryStudentByPage(int page){
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   Connection connection =DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=stu_db","sa","");
   Statement statement =connection.createStatement();
   String sql ="select top "+PAGE_SIZE+" * from student where id not in(select top "+PAGE_SIZE*(page-1)+" id from student )";
   ResultSet rset  = statement.executeQuery(sql);
   List<Student> list =new ArrayList<Student>();
   while(rset.next()){
    Student student =new Student();
    student.setId(rset.getInt("id"));
    student.setStuName(rset.getString("stuname"));
    student.setStuSex(rset.getString("stusex"));
    student.setStuAge(rset.getString("stuage"));
    student.setBirthDay(rset.getDate("birthday"));
    student.setScore(rset.getInt("score"));
    list.add(student);
   }
   rset.close();
   statement.close();
   connection.close();
   return list;
  } catch (Exception e) {
   return null;
  }
  
 }
}