// 获取pageCount
public int getPageCount(int pageSize) {
String sql = "select count(*) from Course";
ResultSet rs = null;
SqlHelper sqlhelper = new SqlHelper();
String parameters[] = {};
int rowCount = 0;
rs = sqlhelper.executeQuery(sql, parameters);
try {
rs.next();
rowCount = rs.getInt(1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
sqlhelper.close();
}
return (rowCount - 1) / pageSize + 1;
}
// 按照分页来获取用户...
// ResultSet->User对象->ArrayList(集合)
public ArrayList getUserByPage(int pageNow, int pageSize) {
ArrayList<User> al = new ArrayList<User>();
// 查询sql
String sql =
"select top "
+ pageSize
+ " * from Course where (Coursename not in(select top "
+ pageSize * (pageNow - 1)
+ " Coursename from Course )) ";
ResultSet rs = null;
SqlHelper sqlhelper = new SqlHelper();
String parameters[] = {};
rs = sqlhelper.executeQuery(sql, parameters);
// 二次封装
try {
while (rs.next()) {
// 这个User放while中
User u = new User();
u.setGrade(rs.getString(1));
u.setZhuanye(rs.getString(2));
u.setNum(rs.getString(3));
u.setCoursename(rs.getString(4));
u.setType(rs.getString(5));
u.setXuefen(rs.getString(6));
u.setStutime(rs.getString(7));
u.setTime(rs.getString(8));
u.setSztime(rs.getString(9));
u.setStar(rs.getString(10));
u.setTeacher(rs.getString(11));
u.setBz(rs.getString(12));
// 把u放入ArrayList
al.add(u);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
sqlhelper.close();
}
return al;
}