1、mybatis通用Mapper

<!-- mybatis通用Mapper-->

<dependency>

    <groupId>tk.mybatis</groupId>

    <artifactId>mapper-spring-boot-starter</artifactId>

    <version>2.0.3</version>

</dependency>

2、mybatis分页插件

<!-- 依赖地址：https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter -->

<dependency>

    <groupId>com.github.pagehelper</groupId>

    <artifactId>pagehelper-spring-boot-starter</artifactId>

    <version>1.2.7</version>

</dependency>

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user`  (

  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系统ID',

  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',

  `age` int(4) NULL DEFAULT NULL COMMENT '年龄',

  `gender` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 1 男 ，2女',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

INSERT INTO `user` VALUES ('1', '路飞', 16, '1');

INSERT INTO `user` VALUES ('2', '罗罗诺亚索隆', 18, '1');

INSERT INTO `user` VALUES ('3', '娜美', 17, '2');

SET FOREIGN_KEY_CHECKS = 1;

#spring

spring:

  #mysql 数据源

  datasource:

    url: jdbc:mysql://127.0.0.1:3306/fish?zeroDateTimeBehavior=convertToNull&characterEncoding=utf8&characterSetResults=utf8&useSSL=false

    username: root

    password: etoak

    driver-class-name: com.mysql.jdbc.Driver

#mybatis

mybatis:

  mapperLocations: classpath:mapper/*.xml

  type-aliases-package: com.fish.winter.model

  configuration:

    map-underscore-to-camel-case: true

#Mybatis通用Mapper

mapper:

  mappers: com.fish.winter.base.BaseMapper

  not-empty: false

  identity: MYSQL

  before: true

#Mybatis分页插件pagehelper

pagehelper:

  helperDialect: mysql

  reasonable: false

  supportMethodsArguments: true

  params: count=countSql

package com.fish.winter;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

import tk.mybatis.spring.annotation.MapperScan;

@SpringBootApplication

@MapperScan(basePackages = "com.fish.winter.mapper") // 注意这里导入的 MapperScan 的包是：tk.mybatis.spring.annotation.MapperScan

public class WinterApplication {

    public static void main(String[] args) {

        SpringApplication.run(WinterApplication.class, args);

    }

}

package com.fish.winter.base;

import tk.mybatis.mapper.common.Mapper;

import tk.mybatis.mapper.common.MySqlMapper;

/**

 * @author 路飞

 * @date 2018-9-19

 * @description     持久化层的父类

 */

public interface BaseMapper<T> extends Mapper<T>, MySqlMapper<T>  { }

package com.fish.winter.model;

import lombok.Builder;
import lombok.Data;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Data
@Builder
@Table(name = "user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY, generator = "select uuid()")
    private String id;
    private String name;
    private Integer age;
    private String gender;

}

package com.fish.winter.controller;

import com.fish.winter.model.User;

import com.fish.winter.service.UserService;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

import java.util.List;

@RestController

@RequestMapping("/test")

public class TestController {

    @RequestMapping("/hello")

    public String test() {

        return "你好spriongBoot";

    }

    @Resource

    private UserService userService;

    @RequestMapping("/user")

    private List<User> queryByExample() {

        return userService.list();

    }

}

package com.fish.winter.service;

import com.fish.winter.model.User;

import java.util.List;

public interface UserService {

    // 获取user 信息

    List<User> list();

}

package com.fish.winter.serviceImpl;

import com.fish.winter.mapper.UserMapper;

import com.fish.winter.model.User;

import com.fish.winter.service.UserService;

import org.springframework.stereotype.Service;

import tk.mybatis.mapper.entity.Example;

import javax.annotation.Resource;

import java.util.List;

@Service("userService")

public class UserServiceImpl implements UserService {

    @Resource

    private UserMapper userMapper;

    @Override

    public List<User> list() {

        Example example = new Example(User.class);

        Example.Criteria criteria = example.createCriteria();

        criteria.andEqualTo("name", "路飞");

        List<User> userList = userMapper.selectByExample(example);

        return userList;

    }

}