分页
//1.1 当前页赋值 page.setPageIndex(myindex); //3.总页数=dao.getALl()/pageSize int mytotalPages=0; int Pages = dao.getAllCount(); if (Pages%pageSize==0) { mytotalPages=Pages/pageSize; }else { mytotalPages=Pages/pageSize+1; } page.setTotalPages(mytotalPages); page.getTotalPages(); //4.泛型数据 List<NewsDetail> list = dao.getOnePageNews(myindex,pageSize); //我知道了 page.setList(list); //将泛型集合 放入request作用域 request.setAttribute("list", page); //转发index。jsp 转发不用加名称
request.getRequestDispatcher("/index.jsp").forward(request, response); } catch (Exception e) { }
@Test public void ass() throws Exception{ List<NewsDetail> list= getOnePageNews(1,3) ; for (NewsDetail item : list) { System.out.println(item.getNewsTitle()); } } public List<NewsDetail> getOnePageNews(int pageIndex, int pageSize) throws Exception { List<NewsDetail> list=new ArrayList<NewsDetail>(); String sql="select top "+pageSize+" * from newsDetails where newsId not in ( select top "+ (pageIndex-1)*pageSize +" newsId from newsDetails)"; ResultSet rs = executeQuery(sql); if(rs!=null){ while(rs.next()){ //各个列 //赋值给单个新闻对象的各个属性 NewsDetail news=new NewsDetail(); news.setNewsId(rs.getInt("newsId")); news.setNewsTitle(rs.getString("newsTitle")); news.setNewsContent(rs.getString("newsContent")); news.setNewsCreateDate(rs.getDate("newsCreateDate")); news.setNewsAuthor(rs.getString("newsAuthor")); news.setNewsCategoryId(rs.getInt("newsCategoryId")); //单个新闻对象加入新闻泛型 list.add(news); } } return list; } public int getAllCount() throws Exception { String sql="select count(1) as num from newsdetails"; ResultSet rs = this.executeQuery(sql); int result=0; if(rs!=null) { if(rs.next()) { result=rs.getInt("num"); } } return result; }
<p align="right"> 当前页数:[<%=page2.getPageIndex()%>/<%=page2.getTotalPages()%>] <a href="<%=path %>/NewsServlet?pageIndex=<%int num=page2.getPageIndex(); if((num+1)<=page2.getTotalPages())