通用Mapper使用（Maven+SSM）

1.在pom.xml中导入jar包（引入Maven依赖）

              <!-- 通用mapper -->

              <dependency>

                     <groupId>com.github.abel533</groupId>

                     <artifactId>mapper</artifactId>

                     <version>2.3.4</version>

              </dependency>

2.在resources源文件中创建mybatis.xml配置通用mapper的拦截器

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

     <plugins>

              <!-- 通用mapper -->

              <plugin interceptor="com.github.abel533.mapperhelper.MapperInterceptor">

                     <!--主键自增回写方法,默认值MYSQL,详细说明请看文档 -->

                     <property name="IDENTITY" value="MYSQL" />

                     <!--通用Mapper接口，多个通用接口用逗号隔开 -->

                     <property name="mappers" value="com.github.abel533.mapper.Mapper" />

              </plugin>

       </plugins>

</configuration>

3.在mybatis配置文件(applicationContent-mybatis.xml)中引入mybatis.xml

<?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"

       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

              http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">

      

       <!-- 配置SqlSessionFactory -->

       <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

              <!-- 数据源 -->

              <property name="dataSource" ref="dataSource"/>

              <!-- mapper映射文件 -->

              <property name="mapperLocations" value="classpath:com/zhiyou100/kfs/mapper/*.xml"/>

             

              <!-- 引入mybatis文件 -->

              <property name="configLocation" value="classpath:mybatis.xml"/>

             

              <!-- pagehelp拦截器 -->

              <property name="plugins">

                  <array>

                    <bean class="com.github.pagehelper.PageInterceptor">

                      <property name="properties">

                        <!--使用下面的方式配置参数，一行配置一个 -->

                        <value>

                          reasonable=true

                        </value>

                      </property>

                    </bean>

                  </array>

              </property>

       </bean>

      

       <!-- 接口生成实现类：用MapperScannerConfigurer使dao接口的包和SqlSessionFactory对象中的mapper对应 -->

       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

              <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>

              <property name="basePackage" value="com.zhiyou100.kfs.dao"/>

       </bean>

</beans>

4.实体类要写相应的注解来对应数据库表和字段

package com.zhiyou100.kfs.bean;

import javax.persistence.Column;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Table(name="tbl_user")//@Table：设置对应的表格；name：表格名；

public class User {

       @Id//@Id：这个属性是主键

       @GeneratedValue(strategy=GenerationType.IDENTITY)//设置MYSQL数据库主键递增（其他数据库有相应的字符串表示递增）

    private Integer userId;

       @Column(name="user_name")//这个属性userName和数据库user_name字段对应（属性名为userName会自动对应数据库中的user_name，驼峰命名大写会在数据库转化为下划线，若属性名转化后和数据字段名对应则@Column可以不写）

    private String userName;

    private Integer userAge;

    public Integer getUserId() {

        return userId;

    }

    public void setUserId(Integer userId) {

        this.userId = userId;

    }

    public String getUserName() {

        return userName;

    }

    public void setUserName(String userName) {

        this.userName = userName == null ? null : userName.trim();

    }

    public Integer getUserAge() {

        return userAge;

    }

    public void setUserAge(Integer userAge) {

        this.userAge = userAge;

    }

       @Override

       public String toString() {

              return "User [userId=" + userId + ", userName=" + userName + ", userAge=" + userAge + "]";

       }

}

5.dao接口继承通用mapper的接口（mapper<T>，T表示泛型，输入什么就变成什么），这个接口必须写，后面可以加映射文件（如UserMapper.xml）和其他的方法，但映射文件的方法的id不能和通用mapper方法的方法名一致

package com.zhiyou100.kfs.dao;

import com.github.abel533.mapper.Mapper;

import com.zhiyou100.kfs.bean.User;

public interface UserMapper extends Mapper<User>{

   

}