分页技术

if(res.next()){ flag=res.getInt(1); } return flag; } public List<User> page(int start, int offset) throws SQLException { // TODO Auto-generated method stub UserDriver bs= new UserDriver(); conn=bs.getConnection(); String sql="select id,name,age,sex,tel,cardno,address from user limit ?,?"; List<User>list= new ArrayList<User>(); ppt= conn.prepareStatement(sql); ppt.setInt(1, start); ppt.setInt(2, offset); res=ppt.executeQuery(); while(res.next()){ User user = new User(); user.setId(res.getString(1)); user.setName(res.getString(2)); user.setAge(res.getInt(3)); user.setSex(res.getString(4)); user.setTel(res.getString(5)); user.setCardno(res.getString(6)); user.setAddress(res.getString(7)); list.add(user); } return list; }
分页技术
版本1.0 例图：实现翻页
1.网页中添加
<a href="UserServlet?action=page&pageno=1">首页 </a>&nbsp;&nbsp;&nbsp; <a href="UserServlet? action=page&pageno=${nowPage-1}">上一 页</a>&nbsp;&nbsp;&nbsp; <a href="UserServlet? action=page&pageno=${nowPage+1}">下一 页</a>&nbsp;&nbsp;&nbsp; <a href="UserServlet? action=page&pageno=${pageSize}">末页</a>
8.总页数显示 总页数 <span>${pageSize }</span>&nbsp;
public int getPageCount() { return pageCount; } public void setPageCount(int pageCount) { this.pageCount = pageCount; } public int getTotal() { return total; } public void setTotal(int total) { if (pageSize != 0) { pageCount = total / pageSize; if (total % pageSize != 0) { pageCount++; } } this.total = total; } public int getNowPage() { return nowPage; } public void setNowPage(int nowPage) { this.nowPage = nowPage; } public int getOffset() { return offset; } public void setOffset(int offset) { offset = (getNowPage() - 1)*getPageSize();
this.offset = offset; } public String getCountSQL() { return countSQL; } public void setCountSQL(String countSQL) { this.countSQL = countSQL; } public String getPageSQL() { return pageSQL; } public void setPageSQL(String pageSQL) { this.pageSQL = pageSQL; } }
6.改下如图
改下以下代 码：request.getRequestDispatcher("UserServlet?
action=page&pageno=1").forward(request, response); 7.建立分页类
实现代码： public class PageService { private int pageSize = 3;//页面记录数 private int pageCount = 0;//页面总数 private int total = 0;//记录总数 private int nowPage = 1;//当前页码 private int offset = 0;//偏移量 private String countSQL; private String pageSQL; public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; }
count=Userfactory.getUserInter().getCount(); service.setTotal(count); service.setNowPage(pageno); service.setOffset(pageno);
Байду номын сангаас
System.out.println(service.getNowPage()); List<User> list=Userfactory.getUserInter().page(service.ge if(list instanceof List){ request.getSession().setAt service.getPageCount()); request.getSession().setAt list); request.getSession().setAt service.getNowPage()); response.sendRedirect( }else{ response.sendRedirect( } } catch (SQLException e) { // TODO Autogenerated catch block e.printStackTrace(); }
4.Servlet服务里添加判断
}else if("page".equals(action)){ int pageno=
Integer.parseInt(request.getParameter( PageService service= new PageService(); int count; try {
2.DAO中添加两条语句
public List<User> page(int start,int offset)throws SQLException; public int getCount()throws SQLException;
3.DAOimpl实现类中添加两条语句
public int getCount() throws SQLException { // TODO Auto-generated method stub UserDriver bs= new UserDriver(); conn= bs.getConnection(); String sql="select count(*)from user"; int flag=0; ppt = conn.prepareStatement(sql); res=ppt.executeQuery();