mybatis分页

最新推荐文章于 2025-06-13 00:08:01 发布

下半夜的雨

最新推荐文章于 2025-06-13 00:08:01 发布

阅读量1.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mybatis 文章标签： mybatis 分页

本文链接：https://blog.youkuaiyun.com/fancheng614/article/details/78313233

mybatis 专栏收录该内容

6 篇文章

订阅专栏

web项目中经常要用到分页，mybatis对分页操作进行了一个很好的封装！

主要代码：

Service：

package com.mfc.service;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.mfc.entity.Work;
import com.mfc.inter.WorkDao;

/**
 * 2017年10月22日18:49:29
 * 工作的service
 * */
@Service("workService")
public class WorkService implements IWorkService {
	
	@Resource(name = "workDao")
	private WorkDao workDao;
	
	@Override
	public PageInfo<Work> getAllMyWork(int work_UserID,int pageNum,int pageSize){
		PageHelper.startPage(pageNum, pageSize);
		List<Work> list = workDao.getAllMyWork(work_UserID);
		PageInfo<Work> works=new PageInfo<Work>(list);
		return works;
	}
}

Controller：

package com.mfc.ctrl;

import javax.annotation.Resource;
import javax.servlet.http.HttpSession;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.mfc.entity.User;
import com.mfc.service.IWorkService;

/**
 * 2017年10月22日18:19:27
 * 工作使用的控制器
 * */
@Controller
@RequestMapping("workCtrl")
public class WorkCtrl {

	@Resource(name = "workService")
	private IWorkService workService;
	
	//查询当前登录用户的所有工作
	@RequestMapping("getAllMyWork")
	public String getAllMyWork(HttpSession session,Model model,Integer pageNum){
		if(pageNum==null){
			pageNum=1;
		}
		User loginUser = (User) session.getAttribute("loginUser");
		model.addAttribute("pi", workService.getAllMyWork(loginUser.getUserId(),pageNum,5));
		return "admin-templates/right_allmywork";
	}
}

界面：

  <body>
  	<table border="1" cellpadding="0" cellspacing="0" width="80%" style="text-align: center;" align="center">
  		<tr>
  			<th>编号</th>
  			<th>标题</th>
  			<th>内容</th>
  			<th>起始时间</th>
  			<th>结束时间</th>
  			<th>状态</th>
  		</tr>
  		<c:forEach items="${pi.list}" var="work">
  		<tr>
  			<td>${work.workId}</td>
  			<td>
  				<c:if test="${fn:length(work.workTitle)>5}">
  					${fn:substring(work.workTitle, 0, 5)} ...
  				</c:if>
  				<c:if test="${fn:length(work.workTitle)<=5}">
  					${work.workTitle}
  				</c:if>
  			</td>
  			<td>
  				<c:if test="${fn:length(work.workContent)>5}">
  					${fn:substring(work.workContent, 0, 5)} ...
  				</c:if>
  				<c:if test="${fn:length(work.workContent)<=5}">
  					${work.workContent}
  				</c:if>
  			</td>
  			<td><fmt:formatDate value="${work.workStartTime}" pattern="yyyy-MM-dd"/></td>
  			<td><fmt:formatDate value="${work.workStopTime}" pattern="yyyy-MM-dd"/></td>
  			<td>
  				<c:if test="${work.workState == 0}">
  					未完成
  				</c:if>
  				<c:if test="${work.workState == 1}">
  					已完成
  				</c:if>
  			</td>
  		</tr>
  		</c:forEach>
  		<tr align="center">
    			<td colspan="6">
    			  <a href="workCtrl/getAllMyWork.do?pageNum=1">首页</a>  
                  <a href="workCtrl/getAllMyWork.do?pageNum=${pi.pageNum>1 ? (pi.pageNum-1):1 }">上一页</a>  
                  <a href="workCtrl/getAllMyWork.do?pageNum=${pi.pageNum<pi.pages ? (pi.pageNum+1):pi.pages }">下一页</a>  
                  <a href="workCtrl/getAllMyWork.do?pageNum=${pi.pages }">尾页</a>    
                  当前${pi.pageNum }/${pi.pages }页，共${pi.total }条
    			</td>
    		</tr>
  	</table>
  </body>

效果：