Action
if(ikey==null){
int count = (int) bijiService.getCount();
System.out.println(userid);
int pageCount = bijiService.getPageCount(count, 10);
if(pageNo == 0){
pageNo = 1;
}
if(pageNo > pageCount){
pageNo = pageCount;
}
List<Biji> bijiList = bijiService.bijiList(pageNo);
session.put("bijiList", bijiList);
session.put("count", count);
session.put("pageNo", pageNo);
session.put("pageCount", pageCount);
return "success";
}
else{
int count = (int) bijiService.getCount1(ikey);
System.out.println(userid);
int pageCount = bijiService.getPageCount(count, 10);
if(pageNo == 0){
pageNo = 1;
}
if(pageNo > pageCount){
pageNo = pageCount;
}
List<Biji> bijiList = bijiService.bijiList1(pageNo,ikey);
session.put("bijiList", bijiList);
session.put("count", count);
session.put("pageNo", pageNo);
session.put("pageCount", pageCount);
return "success";))
daoimpl实现类
public long getCount() {
List count = listHql("select count(b.noteid) from Biji b );
if(count == null){
return 0;
}
return (Long)count.get(0);
}
public long getCount1(int userid,String ikey) {
List count = listHql("select count(b.noteid) from Biji b where b.notename like'%"+ikey+"%' ");
if(count == null){
return 0;
}
return (Long)count.get(0);
}
public List<Biji> findAllByPage(int pageNo, int pageSize) {
if(pageNo < 1){
return null;
}
int offset= (pageNo - 1)*pageSize;
return findByPage("from Biji ", offset, pageSize);
}
public List<Biji> findAllByPage1(int pageNo, int pageSize,int userid,String ikey) {
if(pageNo < 1){
return null;
}
int offset= (pageNo - 1)*pageSize;
return findByPage("from Biji b where b.notename like'%"+ikey+"%' ", offset, pageSize);
}
public List findByPage(final String hql, final int offset,final int pageSize){
Session session = getSessionFactory().getCurrentSession();
List result = session.createQuery(hql).setFirstResult(offset).setMaxResults(pageSize).list();
return result;
}
service
public long getCount(int userid) {
return bijiDao.getCount(userid);
}
public long getCount1(int userid,String ikey) {
return bijiDao.getCount1(userid,ikey);
}
public int getPageCount(int count, int pageSize) {
return (count + pageSize -1)/pageSize;
}
public List<Biji> bijiList(int pageNo) {
return bijiDao.findAllByPage(pageNo, 10);
}
public List<Biji> bijiList1(int pageNo,int userid,String ikey) {
return bijiDao.findAllByPage1(pageNo, 10,ikey);
}
页面
<form method="post" action="<%=pageContext.getServletContext().getContextPath()%>/biji/getAllBiji.action">
标题:<input name="ikey" id="ikey" class="textbox" />
<!--搜索框-->
<input name="" type="submit" value="查询" name="sele" οnclick="sele()" />
<!--搜索按钮-->
</form>
<tr>
<td width="50%">共 <span class="right-text09">${sessionScope.pageCount }</span> 页 |
当前显示第 <span class="right-text09">${sessionScope.pageNo }</span> 页|共<span class="right-text09">${sessionScope.count }</span>条记录</td>
<td width="49%" align="right">[
<a href="<%=pageContext.getServletContext().getContextPath()%>/biji/getAllBiji?pageNo=${sessionScope.pageNo - 1}&userid=${sessionScope.uid}&ikey=${requestScope.ikey }" class="right-font08">上一页</a> |
<a href="<%=pageContext.getServletContext().getContextPath()%>/biji/getAllBiji?pageNo=${sessionScope.pageNo + 1}&userid=${sessionScope.uid}&ikey=${requestScope.ikey }" class="right-font08">下一页</a> ]</td>
</tr>