Mybatis与spring集成 & Aop整合pagehelper插件

Mybatis与spring集成

1、导入pom依赖

• 1.1 添加 spring 相关依赖 (5.0.2.RELEASE)

    		spring-core
    		spring-beans
    		spring-context
    		spring-orm
    		spring-tx
    		spring-aspects
    		spring-web
  

• 1.2 添加 Mybatis 相关依赖

    		mybatis核心：mybatis(3.4.5)
    		Mybatis分页：pagehelper(5.1.2)
  

• 1.3 spring 整合 mybatis(1.3.1)

    		mybatis-spring
  

• 1.4 添加dbcp2连接池

    		commons-dbcp2(2.1.1)
    		commons-pool2(2.4.3)
  

• 1.5 添加日志配置(2.9.1)

    		log4j-core
    		log4j-api
    		log4j-web
  

• 1.6 其他

    		junit(4.12)
    		javax.servlet-api(4.0.0)
    		lombok(1.18.2)
  

  注：使用mybatis-generator插件，pom文件添加支持

  pom.xml

  
  <?xml version="1.0" encoding="UTF-8"?>
  
  <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
  
    <groupId>com.dj</groupId>
    <artifactId>ssm</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>
  
    <name>ssm Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>
  
    <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      <maven.compiler.source>1.7</maven.compiler.source>
      <maven.compiler.target>1.7</maven.compiler.target>
      <maven.compiler.plugin.version>3.7.0</maven.compiler.plugin.version>
  
      <!--添加jar包依赖-->
      <!--1.spring 5.0.2.RELEASE相关-->
      <spring.version>5.0.2.RELEASE</spring.version>
      <!--2.mybatis相关-->
      <mybatis.version>3.4.5</mybatis.version>
      <!--mysql-->
      <mysql.version>5.1.44</mysql.version>
      <!--pagehelper分页jar依赖-->
      <pagehelper.version>5.1.2</pagehelper.version>
      <!--mybatis与spring集成jar依赖-->
      <mybatis.spring.version>1.3.1</mybatis.spring.version>
      <!--3.dbcp2连接池相关 druid-->
      <commons.dbcp2.version>2.1.1</commons.dbcp2.version>
      <commons.pool2.version>2.4.3</commons.pool2.version>
      <!--4.log日志相关-->
      <log4j2.version>2.9.1</log4j2.version>
      <!--5.其他-->
      <junit.version>4.12</junit.version>
      <servlet.version>4.0.0</servlet.version>
      <lombok.version>1.18.2</lombok.version>
    </properties>
  
    <dependencies>
      <!--1.spring相关-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
      </dependency>
  
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId