SpringCloud(Springboot)+Mybatis Plus

Springboot 整合Mybatis Plus

本篇文章就是为SpringCloud 整合seata 准备， 代码内容承接：
SpringCloud+nacos.

主要是通过Springboot 整合Mybatis Plus

1. 引入相关jar包
```
	<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.1.0</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    <dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>druid</artifactId>
         <version>1.1.9</version>
    </dependency>
```

2. 修改nacos 里面nacos-server-dev.yaml 增加数据库配置\

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/users?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      #监控统计拦截的filters
      filters: stat,wall,log4j
      #druid配置
      #配置初始化大小/最小/最大
      initialSize: 5
      minIdle: 5
      maxActive: 20
      #获取连接等待超时时间
      maxWait: 60000
      #间隔多久进行一次检测，检测需要关闭的空闲连接
      timeBetweenEvictionRunsMillis: 60000
      #一个连接在池中最小生存的时间
      minEvictableIdleTimeMillis: 300000
      validationQuery: SELECT 1 FROM DUAL
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      #打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false
      poolPreparedStatements: false
      maxPoolPreparedStatementPerConnectionSize: 20

mybatis-plus:
  mapper-locations: classpath*:mapper/*.xml

2. 创建实体类 UserEntity

package com.chen.scaffolding.nacosserver.entity;

import lombok.Data;

/**
 * 用户
 * @author :master
 */

@Data
public class UserEntity {

    private String userId;
    private String userName;
    private String status;

}

3. 创建mapper

package com.chen.scaffolding.nacosserver.mapper;

import com.chen.scaffolding.nacosserver.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

/**
 * 用户mapper
 * @author :master
 */
@Mapper
public interface UserMapper {

    /**
     * 新增用户
     * @param userEntity 用户实例
     */
    public void addUser (UserEntity userEntity);

    /**
     * 修改用户
     * @param userEntity 用户实例
     */
    public void updateUser (UserEntity userEntity);
}

4. 创建resources/mapper/UserMapper.xml (推荐使用idea 插件 FREE MYBATIS Plugin)

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.chen.scaffolding.nacosserver.mapper.UserMapper">
    <insert id="addUser" parameterType="com.chen.scaffolding.nacosserver.entity.UserEntity" keyProperty="userId" >
        insert into user(userId, userName, status) values (#{userId, jdbcType=VARCHAR}, #{userName, jdbcType=VARCHAR}, #{status, jdbcType=VARCHAR})
    </insert>

    <update id="updateUser" parameterType="com.chen.scaffolding.nacosserver.entity.UserEntity" >
        update user set status=#{status,jdbcType=VARCHAR} where userId = #{userId,jdbcType=VARCHAR}
    </update>
</mapper>

5. 创建service层

package com.chen.scaffolding.nacosserver.service;

import com.chen.scaffolding.nacosserver.entity.UserEntity;

/**
 * 用户业务类
 * @author :master
 */
public interface UserService {
    /**
     * 新增用户
     * @param userEntity 用户实例
     */
    public void addUser (UserEntity userEntity);

    /**
     * 修改用户
     * @param userEntity 用户实例
     */
    public void updateUser (UserEntity userEntity);
}

package com.chen.scaffolding.nacosserver.service.impl;

import com.chen.scaffolding.nacosconfig.entity.Authority;
import com.chen.scaffolding.nacosserver.entity.UserEntity;
import com.chen.scaffolding.nacosserver.mapper.UserMapper;
import com.chen.scaffolding.nacosserver.service.UserService;
import io.seata.spring.annotation.GlobalTransactional;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

/**
 * 用户类
 * @author :master
 */
@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void addUser(UserEntity userEntity) {
        // 第一步
        userMapper.addUser(userEntity);
    }

    @Override
    public void updateUser(UserEntity userEntity) {
        userMapper.updateUser(userEntity);
    }
}

6. 创建controller层

package com.chen.scaffolding.nacosserver.controller;


import com.chen.scaffolding.nacosserver.entity.UserEntity;
import com.chen.scaffolding.nacosserver.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.cloud.context.config.annotation.RefreshScope;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;


/**
 * nacos 服务注册
 * @author :master
 */

@RestController
@RequestMapping("/server")
@RefreshScope
public class NacosServerController {
    @Autowired
    private UserService userService;
    @Value("${server.port}")
    private String port;

    @Value("${test.nacos}")
    private String values;

    @RequestMapping(value = "/echo/{string}", method = RequestMethod.GET)
    public String echo(@PathVariable String string) {
        return "Hello Nacos Discovery " + string;
    }

    @RequestMapping("/get")
    public String get() {
        return values;
    }

    @RequestMapping("/getProt")
    public String getProt() {
        return port;
    }

    @RequestMapping("/addUser")
    public String addUser() {
        UserEntity userEntity = new UserEntity();
        userEntity.setUserId("2");
        userEntity.setUserName("小梦");
        userEntity.setStatus("0");
        try {
            userService.addUser(userEntity);
            return "新增成功";
        }catch (Exception e) {
            return e.getMessage();
        }
    }
}

7. 请求http://localhost:8086/server/addUser

主要问题mapper注入失败， 主要原因有以下几点：

	1. 例如UserMapper 类上没有加@Mapper

	2. 配置文件或者数据源配置类里面没有配Mybatis Plus 静态文件位置

mybatis-plus:
  mapper-locations: classpath*:mapper/*.xml

3. UserMapper.xml 空间名对应

4. 启动类上设置：

@MapperScan("com.chen.scaffolding.nacosserver.mapper")

想要源码点击：我来了！！！！！