Mybatis通用Mapper的使用

1.引入依赖

<?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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.wx</groupId>
    <artifactId>currencymapper</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>currencymapper</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!--mysql依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.26</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2.配置一个公共的接口

package com.wx.currencymapper.util;

import tk.mybatis.mapper.common.ConditionMapper;
import tk.mybatis.mapper.common.IdsMapper;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

/**
 * @Description: 公用Mapper接口
 * @Date: 2018/9/22 17:44
 * @Author: xyz
 */
public interface IBaseDao<T>  extends Mapper<T>,MySqlMapper<T>,ConditionMapper<T>, IdsMapper<T> {
}

3.application.yml中配置

 公共Mapper不要放在全局可以扫描的Mapper下面，不然会报错

mapper:
  mappers: com.wx.exam1.utils.BeanUtil
  identity: MYSQL

4.实体类

 

package com.wx.currencymapper.domain;

import org.springframework.stereotype.Repository;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;

@Repository
@Table(name = "category")
public class Category implements Serializable {
    

    private static final long serialVersionUID = -1989674246114209447L;
    //获取数据库自增的主键
    // 主键 自动递增
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Byte category_id;
    //当这个字段是mysql中的保留字时，这样可以解决
    @Column(name = "`name`")
    private String name;

    private Date last_update;
    //表示不是数据库中的字段
   /* @Transient
    private Film_category film_category;*/


    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public Byte getCategory_id() {
        return category_id;
    }

    public void setCategory_id(Byte category_id) {
        this.category_id = category_id;
    }

    public Date getLast_update() {
        return last_update;
    }

    public void setLast_update(Date last_update) {
        this.last_update = last_update;
    }


}

5.业务mapper

package com.wx.currencymapper.dao;

import com.wx.currencymapper.domain.Category;
import com.wx.currencymapper.util.IBaseDao;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Service;

@Mapper
@Service
public interface CategoryMapper extends IBaseDao<Category> {
}

 6.yml文件：

 

server:
  port: 8080
spring:
  datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/sakila?characterEncoding=utf8
      username: root
      password: 133309
#mybatis配置
mybatis:
#实体类所在包名
  type-aliases-package: com.wx.currencymapper.domain
#通用mapper配置
mapper:
#公用接口类路径
  mappers: com.wx.currencymapper.util.IBaseDao
  identity: MYSQL

logging:
  level:
    com:
      wx:
        currencymapper:
          dao: debug
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

 7 .配置dao包扫描

package com.wx.currencymapper;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import tk.mybatis.spring.annotation.MapperScan;

@SpringBootApplication
@MapperScan(basePackages = {"com.wx.currencymapper.dao"})
public class CurrencymapperApplication {

    public static void main(String[] args) {
        SpringApplication.run(CurrencymapperApplication.class, args);
    }

}

测试：

 

package com.wx.currencymapper.controller;

import com.wx.currencymapper.dao.CategoryMapper;
import com.wx.currencymapper.domain.Category;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class IndexController {
    @Autowired
    private CategoryMapper categoryMapper;

    @RequestMapping("/select")
    @ResponseBody
    public Category getCategory(Byte category_id){
        Category category = categoryMapper.selectByPrimaryKey(category_id);
        System.out.println(category.getName());
        return category;
    }

}