SSM整合后的使用

<!-- 添加分页插件的依赖包 -->
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.2</version>
</dependency>

</plugins>vice层添加一个分页方法

//分页查询
@Override
public PageInfo selectItems(int pageindex, int pagesize) {

    //开启分页  在后面调用查询语句的时候会加入limit
    PageHelper.startPage(pageindex,pagesize);

    //调用查询所有的方法  （会被加入limit）
    List itemsList=  itemsMapper.selectItems();

    //组装pageinfo对象返回
    PageInfo pageInfo=new PageInfo(itemsList);

    return pageInfo;


}

@RequestMapping("/selectItemsListByPage")
public ModelAndView selectItemsListByPage(@RequestParam(value ="pageindex",defaultValue ="1" ) int pageindex)
{

    PageInfo pageInfo = itemsService.selectItems(pageindex,3);

    ModelAndView modelAndView=new ModelAndView();

    modelAndView.addObject("pageInfo",pageInfo);

    modelAndView.setViewName("showItemsByPage");

    return modelAndView;



}

    ${items.name}



总共查询到${pageInfo.total}条记录,
共${pageInfo.pages}页
当前是第${pageInfo.pageNum}页


    ${i}  

<!-- 导入aop jar -->
<dependency>
  <groupId>org.aspectj</groupId>
  <artifactId>aspectjweaver</artifactId>
  <version>1.8.10</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-aspects</artifactId>
  <version>4.1.3.RELEASE</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-aop</artifactId>
  <version>4.1.3.RELEASE</version>
</dependency>

package com.test.aspects;

import net.sf.jsqlparser.statement.execute.Execute;
import org.aspectj.lang.annotation.AfterReturning;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Before;
import org.aspectj.lang.annotation.Pointcut;

import java.beans.Expression;
import java.text.SimpleDateFormat;
import java.util.Date;

@Aspect
public class TimeAspects {

    @Pointcut("execution(* com.test.service.impl.ItemsService.select*(..))")
    public void point()
    {}

    @Before("TimeAspects.point()")
    public void before()
    {
        SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss:ms");

        System.out.println("开始执行的时间:"+simpleDateFormat.format(new Date()));
    }

    @AfterReturning("execution(* com.test.service.impl.ItemsService.select*(..))")
    public void afterReturn()
    {
        SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss:ms");

        System.out.println("成功执行的时间:"+simpleDateFormat.format(new Date()));
    }

}

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
   http://www.springframework.org/schema/context
   http://www.springframework.org/schema/context/spring-context-4.0.xsd
   http://www.springframework.org/schema/aop
   http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
   http://www.springframework.org/schema/tx
   http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!-- 创建切面类对象 -->
    <bean id="timeAspects" class="com.test.aspects.TimeAspects" />

    <!-- 开启 aop 自动代理
        做织入操作
     -->
    <aop:aspectj-autoproxy></aop:aspectj-autoproxy>


</beans>

<!-- 配置spring...xml文件的路径 -->
<context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath:applicationContext-*.xml</param-value>
</context-param>

<!-- 配置context 加载的监听器   -->
<!-- 加载spring 的容器 -->
<listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>