jsp 分页jsp 分页

package com.school.dao.impl; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.school.dao.BaseDao; import com.school.dao.StudentDao; import com.school.entity.Student; public class StudentDaoImpl extends BaseDao implements StudentDao { @Override public int queryCount() { String sql="select count(*) from student"; Connection con=getConn(); PreparedStatement pstmt=null; ResultSet rst=null; int count=0; try { pstmt=con.prepareStatement(sql); rst=pstmt.executeQuery(); if(rst.next()){ count=rst.getInt(1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeConn(rst, pstmt, con); } return count; } @Override public List<Student> queryForPage(int pageSize, int currPage) { int count=(currPage-1)*pageSize; String sql="select top "+ pageSize +"* from student where sid not in (select top "+count+" sid from student)"; return this.executeQuery(sql, null); } @Override public boolean add(Student stu) { String sql="insert into student values (?,?,?)"; String[]parmas={stu.getName(),String.valueOf(stu.getAge()),stu.getBirthday().toString()}; return this.executeUpdate(sql, parmas); } @Override public boolean delete(int id) { String sql="delete from student where sid=?"; String[]parmas={id+""}; return this.executeUpdate(sql, parmas); } @Override public List<Student> executeQuery(String sql, String[] parmas) { Connection con=getConn(); PreparedStatement pstmt=null; ResultSet rst=null; List<Student> list=new ArrayList<Student>(); try { pstmt=con.prepareStatement(sql); if(parmas!=null && parmas.length>0){ for(int i=0;i<parmas.length;i++){ pstmt.setString(i+1, parmas[i]); } } rst=pstmt.executeQuery(); while(rst.next()){ int id=rst.getInt(1); String name=rst.getString(2); int age=rst.getInt(3); Date birthday=rst.getDate(4); Student stu=new Student(id,name,age,birthday); list.add(stu); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeConn(rst,pstmt,con); } return list; } @Override public List<Student> queryAll() { String sql="select * from student"; return this.executeQuery(sql, null); } @Override public List<Student> queryByName(String name) { String sql="select * from student where sname like ?"; String[]parmas={"%"+name+"%"}; return this.executeQuery(sql, parmas); } @Override public List<Student> queryByAge(int age) { String sql="select * from student where sage="+age; return this.executeQuery(sql, null); } @Override public boolean update(Student stu) { String sql="update student set sname=?,sage=?,birthday=? where sid=?"; String[]parmas={stu.getName(),stu.getAge()+"",stu.getBirthday().toString(),stu.getId()+""}; return this.executeUpdate(sql, parmas); } }