构建spring boot web项目：四、集成Mybatis-plus

原创

已于 2024-07-04 18:10:06 修改 · 690 阅读

6 ·

CC 4.0 BY-SA版权

文章标签：

#spring boot #mybatis #后端

于 2024-07-02 20:50:13 首次发布

六、管理应用模块（management）整合mybatis-plus

七、自定义springfox swagger对spring Pageable的支持

一、Mysql数据库安装

参考：docker中安装MySQL、Nacos_docker安装nacos mysql-优快云博客

二、创建Mysql功能模块

三、创建映射模型模块(domain)

四、修改pom.xml

修改pom.xml(mysql)

<?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>com.lyj.initMode</groupId>
        <artifactId>initMode-function</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>initMode-function-mysql</artifactId>

    <description>mysql存储功能模块</description>

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
    </dependencies>

</project>

修改pom.xml(function)

    <modules>
        <module>mysql</module>
    </modules>


        <dependency>
            <groupId>com.lyj.initMode</groupId>
            <artifactId>initMode-common-domain</artifactId>
        </dependency>

修改pom.xml(initMode)


        <!--mybatis-plus版本-->
        <mybatis-plus.version>3.4.2</mybatis-plus.version>


            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            <dependency>
                <groupId>com.lyj.initMode</groupId>
                <artifactId>initMode-common-domain</artifactId>
                <version>${project.version}</version>
            </dependency>

修改pom.xml(base) 引入分页对象依赖，


        <!--数据库持久化 例如分页使用-->
        <dependency>
            <groupId>org.springframework.data</groupId>
            <artifactId>spring-data-commons</artifactId>
        </dependency>

修改pom.xml(common)

<module>domain</module>

五、配置mybatis-plus

编辑配置类DatabaseConfig.java(mysql)

package com.lyj.function.mysql.config;

import com.lyj.common.base.enums.ErrorCodeEnum;
import com.lyj.common.base.util.BizExceptionUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * mybatis-plus配置类
 */
@Configuration
@EntityScan(basePackages = {"com.lyj.**.entity"})
@Slf4j
public class DatabaseConfig {
    @Value("${spring.datasource.url}")
    private String dataSourceUrl;

    @Value("${spring.datasource.username}")
    private String dataSourceUsername;

    @Value("${spring.datasource.password}")
    private String dataSourcePassword;

    @Value("${spring.datasource.driver-class-name}")
    private String dataSourceDriverClassName;

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setUrl(dataSourceUrl);
        dataSource.setUsername(dataSourceUsername);
        dataSource.setPassword(dataSourcePassword);
        dataSource.setDriverClassName(dataSourceDriverClassName);
        testConnection(dataSource); // 调用检查连接方法
        return dataSource;
    }

    private void testConnection(DataSource dataSource) {
        try (Connection connection = dataSource.getConnection()) {
            log.info("数据库连接正常！");
        } catch (SQLException e) {
            // 连接异常处理
            //e.printStackTrace();
            log.error(ErrorCodeEnum.DATA_CONNECT_ERROR.getMessage());
            BizExceptionUtil.bizException(ErrorCodeEnum.DATA_CONNECT_ERROR);
        }
    }
}

六、管理应用模块（management）整合mybatis-plus

引入mysql模块

修改pom.xml(initMode)


            <dependency>
                <groupId>com.lyj.initMode</groupId>
                <artifactId>initMode-function-mysql</artifactId>
                <version>${project.version}</version>
            </dependency>

修改pom.xml(management)

    <dependencies>
        <dependency>
            <groupId>com.lyj.initMode</groupId>
            <artifactId>initMode-function-mysql</artifactId>
        </dependency>
    </dependencies>

配置application.yml(management)

spring:
  datasource:
    url: jdbc:mysql://192.168.163.158:3306/init?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

logging: #日志系统logback配置
  file:
    path: ./ #设置logback日志输出位置 ./代表当前项目下
  level:
    com.lyj.service.dao: debug #调整dao层的日志输出级别 在控制台和日志文件中输出sql日志

在启动类上加 @MapperScan("com.lyj.function.mysql.dao")

启动测试

七、添加EasyCode插件，生成基础代码

导入生成模板

EasyCodeConfig.json

{
  "author" : "lyj",
  "version" : "1.2.8",
  "userSecure" : "",
  "currTypeMapperGroupName" : "Default",
  "currTemplateGroupName" : "MyEasyCode",
  "currColumnConfigGroupName" : "Default",
  "currGlobalConfigGroupName" : "Default",
  "typeMapper" : {
    "Default" : {
      "name" : "Default",
      "elementList" : [ {
        "matchType" : "REGEX",
        "columnType" : "varchar(\\(\\d+\\))?",
        "javaType" : "java.lang.String"
      },

最低0.47元/天解锁文章