SpringBoot整合MyBatis，通用mapper，Druid，log4j2

╰+哭是因爲堅強的太久メ 2023-03-14 13:15 16阅读 0赞

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.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.4.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>springboot_start</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>springboot_start</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
            <shiro.version>1.3.2</shiro.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter</artifactId>
                
                <exclusions>
                    <exclusion>
                        
                        <groupId>org.springframework.boot</groupId>
                        <artifactId>spring-boot-starter-logging</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-log4j2</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>2.0.4</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.7</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.49</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-tomcat</artifactId>
                <scope>provided</scope>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>2.3.3</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>org.apache.tomcat.embed</groupId>
                <artifactId>tomcat-embed-jasper</artifactId>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp.jstl</groupId>
                <artifactId>javax.servlet.jsp.jstl-api</artifactId>
                <version>1.2.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.apache.shiro</groupId>
                <artifactId>shiro-core</artifactId>
                <version>${shiro.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.shiro</groupId>
                <artifactId>shiro-web</artifactId>
                <version>${shiro.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.shiro</groupId>
                <artifactId>shiro-spring</artifactId>
                <version>${shiro.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
                <version>3.8.1</version>
            </dependency>
            <dependency>
                <groupId>com.github.ulisesbocchio</groupId>
                <artifactId>jasypt-spring-boot-starter</artifactId>
                <version>2.1.0</version>
            </dependency>
    
    
    
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
                <scope>runtime</scope>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-configuration-processor</artifactId>
                <optional>true</optional>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

## log4j2配置 ##

*  排除springboot自带的logback，添加log4j2依赖

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter</artifactId>
                
                <exclusions>
                    <exclusion>
                        
                        <groupId>org.springframework.boot</groupId>
                        <artifactId>spring-boot-starter-logging</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-log4j2</artifactId>
            </dependency>

*  在resource里面添加log4j2.xml配置文件和log4jdbc.log4j2.properties

log4j2.xml

<?xml version="1.0" encoding="UTF-8"?>
    <Configuration status="INFO">
        <Properties>
            <Property name="log.path.root">logs</Property>
            <Property name="log.file">spring-boot-demo</Property>
            <Property name="log.pattern">%d %p [LogId:%X{LogId}] [%C{1.}->%M:%L] [%t] %m%n</Property>
        </Properties>
    
        <Appenders>
            
            <Console name="Console" target="SYSTEM_OUT" follow="true">
                <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
                <PatternLayout>
                    <charset>UTF-8</charset>
                    <pattern>${log.pattern}</pattern>
                </PatternLayout>
            </Console>
    
            
            <RollingFile name="INFO-LOG" fileName="${log.path.root}/info/${log.file}.log"
                         filePattern="${log.path.root}/info/${log.file}-%d{yyyy-MM-dd}_%i.log.gz">
                <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
                <PatternLayout pattern="${log.pattern}" charset="UTF-8"/>
                <Policies>
                    <TimeBasedTriggeringPolicy modulate="true" interval="1"/>
                </Policies>
            </RollingFile>
    
            
            <RollingFile name="ERROR-LOG" fileName="${log.path.root}/error/${log.file}.log"
                         filePattern="${log.path.root}/error/${log.file}-%d{yyyy-MM-dd}_%i.log.gz">
                <ThresholdFilter level="ERROR" onMatch="ACCEPT" onMismatch="DENY"/>
                <PatternLayout pattern="${log.pattern}" charset="UTF-8"/>
                <Policies>
                    <TimeBasedTriggeringPolicy modulate="true" interval="1"/>
                </Policies>
            </RollingFile>
        </Appenders>
    
        <Loggers>
            <logger name="jdbc.sqlonly" level="INFO" />
            <logger name="jdbc.sqltiming" level="OFF"/>
            <logger name="jdbc.resultsettable" level="INFO"/>
            <logger name="jdbc.resultset" level="OFF"/>
            <logger name="jdbc.connection" level="OFF"/>
            <logger name="jdbc.audit" level="OFF"/>
            <Root level="INFO">
                <AppenderRef ref="Console" />
                <AppenderRef ref="INFO-LOG" />
                <AppenderRef ref="ERROR-LOG" />
            </Root>
        </Loggers>
    
    </Configuration>

注：使用log4j2的时候一定要排除springboot自带的logback

平时开发过程中为了方便调试会把完整的sql打印出来

修改pom.xml，添加以下依赖

修改数据库连接属性

spring.datasource.driver-class-name=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
    spring.datasource.url=jdbc:log4jdbc:mysql://localhost:3306/spring_boot_demo?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true
    spring.datasource.username=root
    spring.datasource.password=root

添加log4jdbc.log4j2.properties文件

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

SpringBoot整合Durid数据库连接池

添加以下依赖

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>

添加Durid连接属性

spring.datasource.name=master
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    spring.datasource.druid.initial-size=1
    spring.datasource.druid.max-active=30
    spring.datasource.druid.min-idle=1
    spring.datasource.druid.max-wait=60000
    spring.datasource.druid.validation-query=select 1
    spring.datasource.druid.validation-query-timeout=1
    spring.datasource.druid.test-while-idle=true
    spring.datasource.druid.async-init=true
    spring.datasource.druid.async-close-connection-enable=true

具体Durid配置请参照如下：

[https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98][https_github.com_alibaba_druid_wiki_E5_B8_B8_E8_A7_81_E9_97_AE_E9_A2_98]

SpringBoot整合mybatis和通用mapper

添加以下依赖

<dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>2.0.4</version>
            </dependency>

修改application.xml，添加mybatis配置和通用mapper配置

#============MyBatis配置===================
    mybatis.mapper-locations=classpath:mapper/*.xml
    mybatis.type-aliases-package=com.springboot.template.entity
    mybatis.configuration.map-underscore-to-camel-case=true
    
    #===========通用Mapper=====================
    mapper.mappers=com.springboot.template.mapper.base.BaseMapper
    mapper.safe-update=true
    mapper.safe-delete=true
    mapper.not-empty=true
    mapper.check-example-entity-class=true

添加MyBatis配置类

@Configuration
    @MapperScan(basePackages = "com.springboot.template.mapper",markerInterface = BaseMapper.class)
    public class MyBatisConfig {
    }

BaseMapper是一个mapper的接口

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

SpringBoot整合PageHelper进行分页

添加以下依赖

<dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.7</version>
            </dependency>

修改application.xml添加以下配置

#=============pagehelper==================
    pagehelper.helperDialect=mysql
    pagehelper.reasonable=true
    pagehelper.supportMethodsArguments=true
    pagehelper.params=count=countSql

具体使用

@GetMapping("/getAllUser")
        public PageInfo<User> getAllUser(UserVo userVo) {
            PageHelper.startPage(userVo.getPageNum(), userVo.getPageSize());
            List<User> userList = userService.getAllUser();
            PageInfo<User> pageInfo = new PageInfo<>(userList);
            return pageInfo;
        }

[https_github.com_alibaba_druid_wiki_E5_B8_B8_E8_A7_81_E9_97_AE_E9_A2_98]: https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98