Spring Cloud 集成Mybatis Plus + Mysql 实现数据存储

准备条件

1. Mysql数据库
2. MyBatis Plus
3. mysql-connector-java
4. 其他配置请看Spring Cloud专栏

子项目配置

//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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.base</groupId>
        <artifactId>spring-project</artifactId>
        <version>1.0-SNAPSHOT</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>org.base</groupId>
    <artifactId>base-server</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>base-server</name>
    <description>base-server</description>
    <url/>
    <licenses>
        <license/>
    </licenses>
    <developers>
        <developer/>
    </developers>
    <scm>
        <connection/>
        <developerConnection/>
        <tag/>
        <url/>
    </scm>
    <properties>
        <java.version>17</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

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

        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <!-- MybatisPlus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>


        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

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

</project>

数据库表结构创建

创建数据库除了我们熟悉的Navicat之外，其实在idea中也集成了一个插件Database，在这里我们也可以可视化创建数据库和表结构

我创建好一个数据库名字叫test01，在其中创建一个user表，字段如上图。

数据库连接配置

修改子项目中的application.yml配置文件

server:
  port: 8080
spring:
  application:
    name: base-server
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test01?serverTimezone=UTC
    username: 'root'
    password: ''//数据库连接密码
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848

代码实现

//User实例

package org.base.server.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

@TableName("user")
//@Data可以省略所有get set方法的书写
@Data
//自动完成有参构造
@AllArgsConstructor
//自动完成无参构造
@NoArgsConstructor
public class User {

    private String id;
    private String user_name;
    private String password;
    private String org_id;
    private String dept_id;
    private Date create_time;
    private Integer delete_flag;

}

引入lombok的作用就可以展现出来了，可以省略所有的get和set方法，也可以自动完成有参、无参构造

//UserDao

package org.base.server.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.base.server.entity.User;

//BaseMapper已经封装了很多基础的增删改查API
public interface UserDao extends BaseMapper<User> {
}

这个类中不必写什么方法，只需要继承BaseMapper即可，因为BaseMapper已经封装了大部分的增删改查API，对于简单的逻辑完全可以覆盖

//UserService

package org.base.server.service;

import org.base.server.dao.UserDao;
import org.base.server.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RestController;

import java.util.Date;
import java.util.UUID;

@Service
public class UserService {

    @Autowired
    UserDao userDao;

    public String insert(String user_name,String password){
        System.out.println(user_name);
        System.out.println(password);
        User user = new User();
        user.setUser_name(user_name);
        user.setPassword(password);
        String uuid = UUID.randomUUID().toString();
        System.out.println(uuid);
        user.setId(uuid);
        user.setDelete_flag(0);
        user.setCreate_time(new Date());
        return userDao.insert(user) > 0?"success":"fail";
    }
}

在UserService中，我们写入insert业务逻辑

//UserController

package org.base.server.controller;

import org.base.server.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    UserService userService;

    @RequestMapping("/insert")
    public String insert(String user_name,String password){
        return userService.insert(user_name,password);
    }
}

整个的insert流程就写好了，我们用Apifox测试一下

数据保存成功！