SSM框架集成分页插件

在SSM框架搭建之maven方式(二)基础上进一步做以下修改

pom.xml添加如下代码

            com.github.pagehelper
            pagehelper
            5.1.2

spring-mybatis.xml的id标签为sqlSessionFactory节点中添加如下内容

            
                
                    
                        
                            
                             helperDialect=mysql
                             reasonable=true
                             autoRuntimeDialect=true
                        
                    
                
            

将UserController.java中的内容改写为如下代码

package com.lymn.it.controller;

import java.util.List;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.lymn.it.model.User;
import com.lymn.it.service.UserService;

@Controller
public class UserController {
    @Autowired
    UserService userService;
    Logger logger=Logger.getLogger(UserController.class);
    @RequestMapping(value="/user")
    public String user(@RequestParam(defaultValue="1",required=true,value="pageNo") Integer pageNo,Model model) {
        logger.info("查询所有用户数据");
        PageHelper.startPage(pageNo, 5);
        List userList =  userService.getAllUsers();
        PageInfo pageInfo=new PageInfo(userList);
        model.addAttribute("userList", userList);
        model.addAttribute("pageInfo", pageInfo);
        logger.info("查询完毕，返回页面");
        return "user";
    }

}

将user.jsp中的内容改写为如下代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>







    
        
          

          

            
userid
            
username
            
password
            
email
          
          

            
${user.userid}
            
${user.username}
            
${user.password}
            
${user.email}
          
          
        
        
当前 ${pageInfo.pageNum }页,总${pageInfo.pages }
                页,总 ${pageInfo.total } 条记录