?? 使用page來分頁.txt
字號:
public Page getStudentList(String page) {
ResultSet rst = null;
ArrayList list = new ArrayList();
int pageNum;
if (page == null || page.equals("")) pageNum = 1;
else pageNum = Integer.parseInt(page);
p.setRowsPerPage(6); //每頁顯示6行
String s1 = "select top " + pageNum * p.getRowsPerPage() + " * from table where ....";
String s2 = "select count(*) from table where ...";
pstmt = conn.prepareStatement(s2);
rst = pstmt.executeQuery();
if (rst.next()) p.setMaxRowCount(rst.getInt(1)); //取得一共的行數(shù)
pstmt = null;
rst = null;
pstmt = conn.prepareStatement(s1, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rst = pstmt.executeQuery();
int i = (pageNum - 1) * p.getRowsPerPage(); //
if (i != 0) rst.absolute(i);
while (rst.next()) {
...
list.add(...);
}
p.setCurPage(pageNum); //第幾頁
p.setList(list); //list
p.setMaxPage(); //最大頁數(shù)
return p;
}
特殊用法:
public Page searchGroup(Group group, int pageSize) throws DaoException {
Page page = new Page();
try {
Session session = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
Example exampleGroup = Example.create(group);
exampleGroup.ignoreCase().enableLike(MatchMode.ANYWHERE);
//exampleGroup.excludeZeroes();
Criteria criteria = session.createCriteria(Group.class).add(
exampleGroup).addOrder(Order.asc("groupCreateDate"));
List list = criteria.list();
page.setMaxRowCount(list.size());
//page.setRowsPerPage(2);
page.setMaxPage();
page.setFormName("groupInfoForm");
Debug.println("記錄的總頁數(shù)為:" + page.getMaxPage());
//判斷如果分頁數(shù)大于最大頁數(shù),則將頁數(shù)設置為第一頁
if (pageSize > page.getMaxPage() || pageSize < 0) {
Debug.println("警告:請求的分頁數(shù) " +
pageSize + " 大于該記錄的總頁數(shù) " +
page.getMaxPage() +
" 或者小于 0 ,請求的頁數(shù)將置為 1 。");
pageSize = 1;
}
//設置當前頁數(shù)
page.setCurPage(pageSize);
list = criteria.setMaxResults(page.getRowsPerPage())
.setFirstResult((pageSize - 1) * page.getRowsPerPage())
.list();
page.setList(list);
HibernateUtil.commitTransaction();
} catch (HibernateException ex) {
HibernateUtil.rollbackTransaction();
} finally {
HibernateUtil.closeSession();
}
return page;
Page page = groupService.getGroupList(1);
page.setTarget(request.getContextPath() + "/group/EditGroup.jsp");
request.setAttribute("groupPageList",page);
jsp頁面用法:
<%
String strpage = request.getParameter("Page");
int PageNum;
if (strpage != null) {
PageNum = Integer.parseInt(strpage);
}
else {
PageNum = 1;
}
Page pagelist = new Page();
pagelist = SimpleGroup.getGroupLists(PageNum);
//request.setAttribute("gps", pagelist.getList());
List groupList = pagelist.getList();
%>
<%
for(int i=0;<groupList.size();i++){
Group group = (Group)groupList.get(i);
out.println(group.getName());
}
%>
//生成前臺分頁信息
<%
if (pagelist.getList() != null) {
out.print(pagelist.pageStr("\"viewGroups.jsp\""));
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -