ajax+jsp+mssql分页

package com.dao; import java.sql.ResultSet; import java.util.ArrayList; import com.bean.Student; import com.util.DBUtils; public class StuDao { /** * 获取总行数 * * @return */ public int getCount() { int count = 0; String sql = "select count(*) from student"; ResultSet rs = DBUtils.querySQL(sql, null); try { if (rs.next()) { count = rs.getInt(1); } } catch (Exception e) { // TODO: handle exception } return count; } /** * 获取分页数据 * * @param page_current当前页数 * @param page_num每页显示数据 * @return */ public ArrayList<Student> getPageDateAll(int page_current, int page_num, Student stu) { ArrayList<Student> list = new ArrayList<Student>(); // 计算显示计页数 int count = (page_current - 1) * page_num; String sql = "select top " + page_num + " * from Student " + " where sid not in(select top " + count + " sid from Student where 1=1 "; /** * 这些为单条件查询语句 * //获得id并且id不为空和零 if (stu.getSid() != -1) { sql += " and sid=" + stu.getSid(); } //获得名字如果名字不为空就添加sql语句 if (stu.getSname() != null && !stu.getSname().equals("")) { sql += " and sname like '%" + stu.getSname() + "%'"; } //获得年龄如果年龄不为空就添加sql语句 if (stu.getSsex() != null && !stu.getSsex().equals("")) { sql += " and ssex = '" + stu.getSsex() + "'"; } sql += ")";*/ //获得id并且id不为空和零 if (stu.getSid() != -1) { sql += " and sid=" + stu.getSid(); } //获得名字如果名字不为空就添加sql语句 if (stu.getSname() != null && !stu.getSname().equals("")) { sql += " and sname like '%" + stu.getSname() + "%'"; } //获得年龄如果年龄不为空就添加sql语句 if (stu.getSsex() != null && !stu.getSsex().equals("")) { sql += " and ssex = '" + stu.getSsex() + "'"; } sql += ")"; /** * 这些为多条件查询语句 * if (stu.getSid() != -1) { sql += " and sid=" + stu.getSid(); } if (stu.getSname() != null && !stu.getSname().equals("")) { sql += " and sname like '%" + stu.getSname() + "%'"; } if (stu.getSsex() != null && !stu.getSsex().equals("")) { sql += " and ssex = '" + stu.getSsex() + "'"; }*/ if (stu.getSid() != -1) { sql += " and sid=" + stu.getSid(); } if (stu.getSname() != null && !stu.getSname().equals("")) { sql += " and sname like '%" + stu.getSname() + "%'"; } if (stu.getSsex() != null && !stu.getSsex().equals("")) { sql += " and ssex = '" + stu.getSsex() + "'"; } ResultSet rs = DBUtils.querySQL(sql, null); try { while (rs.next()) { Student st = new Student(); st.setSid(rs.getInt(1)); st.setSname(rs.getString(2)); st.setSsex(rs.getString(3)); list.add(st); } } catch (Exception e) { e.printStackTrace(); } return list; } }