hibernate分页

最新推荐文章于 2024-10-23 13:44:32 发布

tun279752914

最新推荐文章于 2024-10-23 13:44:32 发布

阅读量240

点赞数

文章标签： hibernate list string session query 任务

本文链接：https://blog.csdn.net/tun279752914/article/details/5204246

版权

ActionTask：

// 分页
public String fenye() {
  HttpServletRequest request = ServletActionContext.getRequest();
  HttpServletResponse response = ServletActionContext.getResponse();
  ListTaskServer lts = new ListTaskServer();
  ActionTask at = new ActionTask();
  int count = at.count();
  int pageSize = 3;// 一页又好多条
  int page = 1;// 表示第几页
  String strpage = request.getParameter("page");
  int pageCount = count / pageSize;// 分了好多页

  if (count % pageSize != 0) {
   pageCount = pageCount + 1;
  }
  if (strpage != null && !strpage.equals("")) {

page = Integer.parseInt(strpage);

}
if (page < 1) {

page = 1;

  }
  if (page >= pageCount) {
   page = pageCount;

  }
  List list = lts.queryForList(page, pageSize);
  request.setAttribute("pageCount", pageCount);// 共有多少页
  request.setAttribute("page", page);

request.setAttribute("listtask", list);

System.out.println(request.getAttribute("listtask"));

return "listTask";

}

// 详细任务
public void detalTask() {
HttpServletRequest request = ServletActionContext.getRequest();
  HttpServletResponse response = ServletActionContext.getResponse();
  String chooseNo = request.getParameter("choose");
  ListTaskServer lts = new ListTaskServer();
  List list = null;

list = lts.detalTask(chooseNo);

request.setAttribute("detalTask", list);

}
ListTaskServer:

public List queryForList(int page, int pageSize) {
  int start=(page-1)*pageSize+1;
  String hql="select t.TName,t.stuff.SName,t.TStart,t.TEnd,t.TStatus,t.TId from Task t";
  return td.queryForList(start,pageSize,hql);
}

TaskDao:

// 分页
public List queryForList(int start, int pageSize, String hql) {
Session session = HibernateSessionFactory.getSession();

Query q = session.createQuery(hql);

System.out.println(start);

q.setFirstResult(start - 1);
q.setMaxResults(pageSize);

  List list = q.list();
  /*
   * for (int i = 0; i < list.size(); i++) { Task t = (Task) list.get(i);
   * System.out.println(t.getStuff().getSDegree());
   *
   * }
   */
    HibernateSessionFactory.closeSession();
  return list;
}