在dao包的Hibernate类中
public List findAllSearch(int pageNo , int pageSize){
Session session = this.getSession() ;
Query query = session.createQuery("from test") ;
int firstResultIndex = pageSize*(pageNo-1) ;
query.setFirstResult(firstResultIndex) ;
query.setMaxResults(pageSize) ;
return query.list() ;
} 在servlet中调用
try {
request.setAttribute("all", new Hibernate().findAllSearch(1, 5));
} catch (Exception e) {
e.printStackTrace() ;
}finally{
HibernateSessionFactory.closeSession() ;
}在jsp中
<body>
This is my JSP page. <br>
<jsp:include flush="true" page="servlet/Servlet"/>
<table>
<c:forEach items="${requestScope.all}" var="o">
<tr>
<td>${o.name }</td>
</tr>
</c:forEach>
</table>
</body>怎么控制上一页和下一页??
public List findAllSearch(int pageNo , int pageSize){
Session session = this.getSession() ;
Query query = session.createQuery("from test") ;
int firstResultIndex = pageSize*(pageNo-1) ;
query.setFirstResult(firstResultIndex) ;
query.setMaxResults(pageSize) ;
return query.list() ;
} 在servlet中调用
try {
request.setAttribute("all", new Hibernate().findAllSearch(1, 5));
} catch (Exception e) {
e.printStackTrace() ;
}finally{
HibernateSessionFactory.closeSession() ;
}在jsp中
<body>
This is my JSP page. <br>
<jsp:include flush="true" page="servlet/Servlet"/>
<table>
<c:forEach items="${requestScope.all}" var="o">
<tr>
<td>${o.name }</td>
</tr>
</c:forEach>
</table>
</body>怎么控制上一页和下一页??
if (pageindex < 0 || pagesize < 0)
return list;
try {
int startIndex = (pageindex - 1) * pagesize + 1;
Query query = session.createQuery("from Project p where p.statusFlag!=9 order by p.createtime desc");
query.setFirstResult(startIndex - 1);
query.setMaxResults(pagesize);
list = query.list();
} catch (DataAccessException e) {
e.printStackTrace();
list = null;
}
return list;