idea下SpringBoot整合Mybatis+日志文件配置

电玩女神 2022-11-06 03:55 558阅读 0赞

# 一、SpringBoot整合Mybatis #

## 1、idea创建SpringBoot工程 ##

### 1.1、使用Spring Initializr创建：如下图 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70]

### 1.2、配置项目的组名和包名（修改完成点击next） ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 1]

### 1.3、 添加依赖 ###

*  **添加开发工具包**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 2]
 *  **添加web依赖**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 3]
 *  **添加Mybatis**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 4]
 *  **最后点击next再点击finish**
 *  **删除不需要的文件以及文件夹如下图**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 5]
 *  **最后的文件目录如下**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 6]

### 1.4 不要着急启动项目（安装数据库驱动以及配置） ###

#### 1.4.1 在pom.xml中添加jdbc和mybatis的starter（记得刷新maven） ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 7]  
**配置信息如下：**

<dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
         <version>5.1.49</version>
    </dependency>
    <dependency>
         <groupId>org.mybatis.spring.boot</groupId>
         <artifactId>mybatis-spring-boot-starter</artifactId>
         <version>2.1.4</version>
    </dependency>

#### 1.4.2 在resource文件夹下面新建一个application.yaml配置文件并配置数据库连接信息 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 8]

#### 1.4.3 此时启动工程（运行）（不会报错） ####

*  **找到如下工程入口运行**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 9]
 *  **出现如下图，表示启动成功**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 10]

## 2、整合Mybatis ##

### 2.1、测试数据准备 ###

在你的数据库（本文数据库名称为test）下运行如下sql文件创建一个test\_table表并插入数据

create table `test_table`(
    	`test_id` int not null auto_increment, 
    	`test_name` varchar(32) not null,
    	`test_date` timestamp not null,
    	 primary key(`test_id`)
    );
    
    insert into test_table values(null, "测试", now());

运行完成之后：数据库的table\_test表中存在如下数据  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 11]

### 2.2、创建Bean（使用lombok） ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 12]  
**代码如下**

package com.wechat.sell.bean;
    
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    import java.util.Date;
    
    @AllArgsConstructor
    @NoArgsConstructor
    @Data
    public class TestsBean { 
        private Integer testId;
        private String testName;
        private Date testDate;
    }

### 2.3、创建mapper接口 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 13]

**代码如下：**

package com.wechat.sell.mapper;
    import com.wechat.sell.bean.TestsBean;
    public interface TestsMapper { 
        //根据id获取数据
        public TestsBean getBean(int id);
    }

### 2.4 创建service ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 14]  
**代码如下**

package com.wechat.sell.service;
    
    import com.wechat.sell.bean.TestsBean;
    import com.wechat.sell.mapper.TestsMapper;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    @Service
    public class TestsService { 
        @Autowired
        TestsMapper testsMapper;
    
        public TestsBean getBean(int id){ 
            return testsMapper.getBean(id);
        }
    }

### 2.5、controller编写 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 15]  
**代码如下**

package com.wechat.sell.controller;
    
    import com.wechat.sell.bean.TestsBean;
    import com.wechat.sell.service.TestsService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    @Controller
    public class TestsController { 
       @Autowired
       TestsService testsService;
    
       @ResponseBody
       @GetMapping("/test")
       public TestsBean test(@RequestParam("id")Integer id){ 
           return testsService.getBean(id);
       }
    }

### 2.6、Mybatis配置文件设置 ###

#### 2.6.1 在resource下创建mybatis文件夹，并且在mybatis文件夹下面创建mapper文件夹（注意一定要先创建一个mybatis文件夹然后再创建mapper文件夹，不能直接创建一个mybatis.mapper文件夹，会出错） ####

![在这里插入图片描述][20210307223451560.png]

#### 2.6.2 在上步中的mapper文件夹下，创建一个与TestsMapper同名的.xml文件（[小鸟插件安装][Link 1]） ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 16]  
**内容如下**

<?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.wechat.sell.mapper.TestsMapper">
        <select id="getBean" resultType="com.wechat.sell.bean.TestsBean">
            select * from `test_table` where test_id = #{id}
        </select>
    </mapper>

#### 2.6.3 在application.yaml文件中配置mybatis ####

![在这里插入图片描述][20210307224155991.png]  
**配置代码如下**

mybatis:
      # config-location: classpath:mybatis/mybatis-config.xml
      mapper-locations: classpath:mybatis/mapper/*.xml
      configuration: # 指定mybatis全局配置文件中的相关配置项
        map-underscore-to-camel-case: true

#### 测试：重启工程，并且在网页中输入[http://localhost:8080/test?id=1][http_localhost_8080_test_id_1] ####

**出现下图表示整合成功**  
![在这里插入图片描述][20210307225357147.png]

## 3、日志文件配置 ##

### 3.1、直接在resource文件夹下创建一个logback-spring.xml文件 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 17]

### 3.2 文件内容如下 ###

<?xml version="1.0" encoding="UTF-8" ?>
    <configuration>
        
        <appender name="consoleLog" class="ch.qos.logback.core.ConsoleAppender">
            <layout class="ch.qos.logback.classic.PatternLayout">
                <pattern>
                    %d - %msg%n
                </pattern>
            </layout>
        </appender>
        
        <appender name="fileInfoLog" class="ch.qos.logback.core.rolling.RollingFileAppender">
            <filter class="ch.qos.logback.classic.filter.LevelFilter">
                <level>ERROR</level>
                <onMatch>DENY</onMatch>
                <onMismatch>ACCEPT</onMismatch>
            </filter>
            <encoder>
                <pattern>%msg%n</pattern>
            </encoder>
            
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                
                <FileNamePattern>D:/study/offer/Java/log/info.%d.log</FileNamePattern>
            </rollingPolicy>
        </appender>
        
        <appender name="fileErrorLog" class="ch.qos.logback.core.rolling.RollingFileAppender">
            <filter class="ch.qos.logback.classic.filter.ThresholdFilter">
                <level>ERROR</level>
            </filter>
            <encoder>
                <pattern>%msg%n</pattern>
            </encoder>
            
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                
                <FileNamePattern>D:/study/offer/Java/log/error.%d.log</FileNamePattern>
            </rollingPolicy>
        </appender>
        <root level="info">
            <appender-ref ref="consoleLog"/>
            <appender-ref ref="fileInfoLog"/>
            <appender-ref ref="fileErrorLog"/>
        </root>
    </configuration>

**注意：以上代码需要修改的地方**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 18]

### 3.3 测试 ###

#### 3.3.1、在如下图位置创建一个LogTest.java文件 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 19]

#### 3.3.2、文件内容如下（注：如果出现红色报错，直接鼠标点击到红色处，按照提示添加依赖即可） ####

package com.wechat.sell;
    
    import lombok.extern.slf4j.Slf4j;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    @RunWith(SpringRunner.class)
    @SpringBootTest
    @Slf4j
    public class LogTest { 
    
    // private final Logger logger = LoggerFactory.getLogger(LogTest.class);
    
        @Test
        public void test() { 
            String name = "test";
            String password = "123456";
            log.debug("debug...");
            log.info("name：{}, password：{}", name, password);
            log.info("info...");
            log.error("error...");
            log.warn("warning...");
        }
    }

#### 3.3.3、测试结果 ####

*  **控制台打印**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 20]
 *  **在配置的路径下可以输出两个日志文件**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 21]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70]: /images/20221023/7944248d62e9469f89c7008cac3fc0cd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 1]: /images/20221023/e004d4cdb6bf48fbb6d7fe4cf7cc9100.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 2]: /images/20221023/4c236651e5524c06b71dd89ed78c4cc6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 3]: /images/20221023/cb9935dcc7744d89b3d4168de8c5e4f4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 4]: /images/20221023/958116d3613c49b0b88945d1a47841b3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 5]: /images/20221023/ccc662b80165467c80d1dba1002abb33.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 6]: /images/20221023/76394323d4244c1f8bdb69cc49a29047.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 7]: /images/20221023/76cfe89763094d9384c7cac4c4ad8cd6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 8]: /images/20221023/63801e9710aa4256bbc987b588b869ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 9]: /images/20221023/d30c789f5ec542d3a02d686f95080ac1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 10]: /images/20221023/b089a80da0c548db9fd94a594ae52ed1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 11]: /images/20221023/006615a3011743a38a3aca7d4d9f9dfb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 12]: /images/20221023/5c622cb8a9f34a21885fdba6440b7a70.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 13]: /images/20221023/9bf2aec8a193462a938d57035cf341a1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 14]: /images/20221023/3733f2d06d904e8abaf771bde22e71cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 15]: /images/20221023/04abd740fa1d4a4390a32c4f07d66a10.png
[20210307223451560.png]: /images/20221023/a1db9d1d70b949b1aafd59167a453006.png
[Link 1]: https://blog.csdn.net/wcc178399/article/details/89880936
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 16]: /images/20221023/6a13be525a824f56a1fdbf7e8933bef3.png
[20210307224155991.png]: /images/20221023/922ea88840414a02a1722897b1135885.png
[http_localhost_8080_test_id_1]: http://localhost:8080/test?id=1
[20210307225357147.png]: /images/20221023/069901d023874cb19836ac5f0c3c7405.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 17]: /images/20221023/6084e5540c9c48e4bfd6460431371a6e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 18]: /images/20221023/dabc4a294c7d4f79bd3c7a8bb5973eda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 19]: /images/20221023/15b7a4e54f134fc2a79733adf9c0c270.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 20]: /images/20221023/0db4f45eb11f451ca3d6a7d7c158512c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2ODkwMzcw_size_16_color_FFFFFF_t_70 21]: /images/20221023/d05471ee0807497db2bef8a867070b72.png