public class PageBeanForm {
BaseFactory baseFactory = new BaseFactory();
private int currentPage;
private int totalPage;
private int totalNumber;
private int listNumber = 10;
private String upPage = "上一页";
private String downPage = "下一页";
JdbcInter jdbcInter = new BaseDAO().getJdbc();
Hashtable hashCourseName = baseFactory.getCourseDaoInter().getResult();
Hashtable hashChapterName = baseFactory.getChapterDaoInter().getResult();
Hashtable hashLoreInfor = baseFactory.getLoreDaoInter().getResult();
Hashtable hashThemeTye = baseFactory.getThemeTypeDaoInter().getResult();
Hashtable hashStuClass = baseFactory.getClassDaoInter().getResult();
Hashtable hashStuGrade = baseFactory.getGradeDaoInter().getResult();
public ArrayList getResult(String table, String sql, String strCurrentPage) {
ResultSet rs = null;
ArrayList list = new ArrayList();
try {
this.currentPage = new Integer(strCurrentPage).intValue();
if (this.currentPage < 1) {
this.currentPage = 1;
}
} catch (java.lang.NumberFormatException e) {
System.out.println("the input not a number!");
this.currentPage = 1;
}
try {
rs = jdbcInter.getConnection().createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY).executeQuery(sql);
if (rs != null && rs.next()) {
rs.last();
this.totalNumber = rs.getRow();
this.totalPage = (int) Math.ceil((float) totalNumber
/ (float) listNumber);
if (this.currentPage > this.totalPage) {
this.currentPage = this.totalPage;
}
rs.absolute((currentPage - 1) * listNumber + 1);
int addNum = 0;
if (table.trim().equals("course")) {
do {
CourseForm courseForm = new CourseForm();
courseForm.setCourseId(rs.getInt("courseId"));
courseForm.setCourseName(rs.getString("courseName"));
courseForm.setCourseMark(rs.getString("courseMark"));
courseForm.setAddUser(rs.getString("addUser"));
courseForm.setAddTime(BaseUtil.getChangeTime(rs
.getString("addTime").trim()));
courseForm
.setCourseNumber(rs.getString("courseNumber"));
if (rs.getString("updateTime").trim().equals("")) {
courseForm.setUpdateTime("未曾修改");
} else {
courseForm.setUpdateTime(BaseUtil.getChangeTime(rs
.getString("updateTime").trim()));
}
list.add(courseForm);
addNum++;
} while (rs.next() && addNum < listNumber);
}}
return list;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
public void setListNumber(int listNumber) {
this.listNumber = listNumber;
}
public int getListNumber() {
return listNumber;
}
public int getTotalPage() {
return this.totalPage;
}
public int getCurrent() {
return this.currentPage;
}
public int getTotalNumber() {
return this.totalNumber;
}
public void setTotalNumber(int totalNumber) {
this.totalNumber = totalNumber;
}
public String getTotalPageString() {
return "总共 " + this.totalPage + "页";
}
public String getCurrentPageString() {
return "当前是第 " + this.currentPage + "页";
}
public String getTotalNumbers() {
return "共" + this.totalNumber + "条记录";
}
public String getListNumbers() {
return "每页" + this.listNumber + "条记录";
}
public String getDownPage(String jspPage) {
String param = "";
if (this.currentPage < this.totalPage) {
int curNum = this.currentPage + 1;
param = "<a href=" + jspPage + "page=" + curNum;
param += ">" + downPage + "</a>/n";
} else {
this.currentPage = this.totalPage;
param = "<a href=" + jspPage + "page=" + this.totalPage;
param += ">" + downPage + "</a>/n";
}
return param;
}
public String getUpPage(String jspPage) {
String param = "";
if (this.currentPage > 1) {
int curNum = this.currentPage - 1;
param = "<a href=" + jspPage + "page=" + curNum;
param += ">" + upPage + "</a>/n";
} else {
this.currentPage = 1;
param = "<a href=" + jspPage + "page=" + 1;
param += ">" + upPage + "</a>/n";
}
return param;
}
public String getFirstPage(String jspPage) {
int curNum = 1;
String ret = "";
if (this.currentPage > 1) {
ret = "<a href=" + jspPage + "&page=" + curNum + ">第一页</a>";
} else {
this.currentPage = 1;
ret = "";
}
return ret;
}
public String getEndPage(String jspPage) {
int curNum = this.totalPage;
String ret = "";
if (totalPage > 1 && this.currentPage < totalPage) {
ret = "<a href=" + jspPage + "&page=" + curNum + ">尾页</a>";
} else {
ret = "";
}
return ret;
}