工作3年，竟然还有人不知道使用MyBatis的这4个技巧？

比眉伴天荒 2022-12-30 13:33 132阅读 0赞

## 前言 ##

关于Mybatis常见的一些知识点，总结了一个思维导图，分享给大家。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzQ4Nzk1NjA3_size_16_color_FFFFFF_t_70_pic_center][]

> MyBatis是一款优秀的持久层框架，它支持自定义SQL、存储过程以及高级映射。MyBatis免除了几乎所有的JDBC代码以及设置参数和获取结果集的工作。  
> MyBatis可以通过简单的XML或注解来配置和映射原始类型、接口和Java POJO（Plain Old Java  
> Objects，普通老式Java对象）为数据库中的记录。

越来越多的企业已经将MyBatis使用到了正式的生产环境，本文就使用MyBatis的几种方式提供简单的示例。  
以及如何对数据库密码进行加密。

**目前有以下章节：**

单独使用MyBatis

集成Spring框架

集成Spring Boot框架

Spring Boot配置数据库密码加密

## 一、单独使用 ##

引入MyBatis依赖，单独使用，版本是3.5.6

### 引入依赖 ###

<dependencies>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.6</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.19</version>
            </dependency>
        </dependencies>

### 添加mybatis-config.xml ###

### 开始使用 ###

### Model类 ###

tk.mybatis.simple.model.DbTest.java

package tk.mybatis.simple.model;
    
    public class DbTest {
    
        public Integer id;
        public String text;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getText() {
            return text;
        }
    
        public void setText(String text) {
            this.text = text;
        }
    
        @Override
        public String toString() {
            return "DbTest{" +
                    "id=" + id +
                    ", text='" + text + '\'' +
                    '}';
        }
    }

### Mapper接口 ###

tk.mybatis.simple.mapper.DbTestMapper

package tk.mybatis.simple.mapper;
    
    import tk.mybatis.simple.model.DbTest;
    
    public interface DbTestMapper {
    
        DbTest queryById(Integer id);
    }

### XML映射文件 ###

XML映射文件请放于Mapper接口所在路径下，保证名称相同

tk/mybatis/simple/mapper/DbTestMapper.xml

<?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="tk.mybatis.simple.mapper.DbTestMapper">
        <select id="queryById" parameterType="int" resultType="DbTest">
            SELECT db_test_id AS id, db_test_text AS text
            FROM db_test
            WHERE db_test_id = #{id, jdbcType=INTEGER}
        </select>
    </mapper>

### 执行示例 ###

package tk.mybatis.simple;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import tk.mybatis.simple.mapper.DbTestMapper;
    
    import java.io.IOException;
    import java.io.Reader;
    
    public class MyBatisHelper {
    
        private static SqlSessionFactory sqlSessionFactory;
    
        static {
            try {
                // MyBatis的配置文件
                Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
                // 创建一个 sqlSessionFactory 工厂类
                sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
                reader.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    
        public static SqlSession getSqlSession() {
            return sqlSessionFactory.openSession();
        }
    
        public static void main(String[] args) {
            // 创建一个 SqlSession 会话
            SqlSession sqlSession = MyBatisHelper.getSqlSession();
            // 获取 DbTestMapper 接口的动态代理对象
            DbTestMapper dbTestMapper = sqlSession.getMapper(DbTestMapper.class);
            // 执行查询
            System.out.println(dbTestMapper.queryById(1).toString());
        }
    }

## 二、集成Spring ##

在 Spring 项目中，使用 MyBatis 的模板，请注意 Spring 的版本为5.2.10.RELEASE

日志框架使用Log4j2（推荐），版本为2.13.3，性能高于logback和log4j

我的项目模板 Git 地址

### 工程结构图 ###

![b8d1104bc97f57c47058f8dd1282c1a7.png][]

MyBatis-Spring-Example-Structure  
其中jquery.min.js文件可以去官网下载

### 引入依赖 ###

<?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>
        
        <groupId>tk.mybatis.simple</groupId>
        <artifactId>mybatis-spring</artifactId>
        <packaging>war</packaging>
    
        <properties>
            
            <mybatis.version>3.5.6</mybatis.version>
            
            <jackson.version>2.11.3</jackson.version>
            <java.version>1.8</java.version>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        </properties>
    
        <dependencyManagement>
            <dependencies>
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-framework-bom</artifactId>
                    <version>5.2.10.RELEASE</version>
                    <type>pom</type>
                    <scope>import</scope>
                </dependency>
                <dependency>
                    <groupId>org.apache.logging.log4j</groupId>
                    <artifactId>log4j-bom</artifactId>
                    <version>2.13.3</version>
                    <scope>import</scope>
                    <type>pom</type>
                </dependency>
            </dependencies>
        </dependencyManagement>
    
        <dependencies>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.19</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.3</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>5.2.0</version>
            </dependency>
            <dependency>
                <groupId>com.github.jsqlparser</groupId>
                <artifactId>jsqlparser</artifactId>
                <version>3.2</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.1</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.2</version>
            </dependency>
            
            <dependency>
                <groupId>javax.annotation</groupId>
                <artifactId>javax.annotation-api</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>javax.transaction</groupId>
                <artifactId>javax.transaction-api</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${jackson.version}</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-web</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-1.2-api</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-jcl</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.7</version>
            </dependency>
            
            <dependency>
                <groupId>com.lmax</groupId>
                <artifactId>disruptor</artifactId>
                <version>3.4.2</version>
            </dependency>
            
    
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.4</version>
            </dependency>
            <dependency>
                <groupId>commons-io</groupId>
                <artifactId>commons-io</artifactId>
                <version>2.8.0</version>
            </dependency>
            <dependency>
                <groupId>commons-codec</groupId>
                <artifactId>commons-codec</artifactId>
                <version>1.15</version>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>study-ssm</finalName>
            <plugins>
                <plugin>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                        <encoding>UTF-8</encoding>
                    </configuration>
                </plugin>
            </plugins>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources/META-INF/spring</directory>
                    <includes>
                        <include>spring-mybatis.xml</include>
                        <include>spring-mvc.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    
    </project>

### 添加spring-mvc.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                               http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                               http://www.springframework.org/schema/context
                               http://www.springframework.org/schema/context/spring-context-3.1.xsd
                               http://www.springframework.org/schema/mvc
                               http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
        
        <context:component-scan base-package="tk.mybatis.simple" />
    
        
        <bean id="mappingJacksonHttpMessageConverter"
              class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
            <property name="supportedMediaTypes">
                <list>
                    <value>text/html;charset=UTF-8</value>
                </list>
            </property>
        </bean>
        
        <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter ">
            <property name="messageConverters">
                <list>
                    <ref bean="mappingJacksonHttpMessageConverter" /> 
                </list>
            </property>
        </bean>
    
        
        <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
            
            <property name="defaultEncoding" value="utf-8" />
            
            <property name="maxUploadSize" value="104857600" />
            
            <property name="maxInMemorySize" value="40960" />
            
            <property name="resolveLazily" value="true"/>
        </bean>
    
        
        <bean class="org.springframework.web.accept.ContentNegotiationManagerFactoryBean">
            <property name="favorParameter" value="true" />
            <property name="parameterName" value="format"/>
            <property name="ignoreAcceptHeader" value="true" />
            <property name="mediaTypes">
                <value>
                    
                    json=application/json
                    xml=application/xml
                    html=text/html
                </value>
            </property>
            <property name="defaultContentType" value="text/html" />
    
        </bean>
    
        
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            <property name="prefix" value="/WEB-INF/jsp/" />
            <property name="suffix" value=".jsp" />
        </bean>
    
        
        <mvc:annotation-driven />
        
        <mvc:default-servlet-handler/>
        
        <mvc:resources location="static/" mapping="/static/**"/>
    
    </beans>

### 添加mybatis-config.xml ###

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
     
     
     <settings>
      
      <setting name="cacheEnabled" value="false" />
      
      <setting name="localCacheScope" value="STATEMENT" />
      
      
      <setting name="lazyLoadingEnabled" value="true" />
      
      
      <setting name="aggressiveLazyLoading" value="false" />
      
      <setting name="useColumnLabel" value="true" />
      
      <setting name="useGeneratedKeys" value="false" />
      
      <setting name="mapUnderscoreToCamelCase" value="true" />
     </settings>
     
     <typeAliases>
      <package name="tk.mybatis.simple.model" />
     </typeAliases>
     <plugins>
      
      <plugin interceptor="com.github.pagehelper.PageInterceptor">
       
       <property name="helperDialect" value="mysql"/>
       
       <property name="offsetAsPageNum" value="true" />
       
       <property name="rowBoundsWithCount" value="true" />
       
       <property name="pageSizeZero" value="true" />
      </plugin>
     </plugins>
    </configuration>

### 添加spring-mybatis.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                            http://www.springframework.org/schema/tx
                            http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
                            http://www.springframework.org/schema/aop
                            https://www.springframework.org/schema/aop/spring-aop.xsd">
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
              init-method="init" destroy-method="close">
            <property name="url" value="jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8"/>
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
            <property name="username" value="root"/>
            <property name="password" value="password"/>
            <property name="filters" value="stat,log4j,wall"/>
            
            <property name="maxActive" value="20"/>
            <property name="minIdle" value="20"/>
            
            <property name="initialSize" value="5"/>
            
            <property name="maxWait" value="10000"/>
            
            <property name="timeBetweenEvictionRunsMillis" value="3600000"/>
            
            <property name="minEvictableIdleTimeMillis" value="120000"/>
            <property name="testWhileIdle" value="true"/>
            <property name="testOnBorrow" value="false"/>
        </bean>
    
        
        <bean id="mySqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            
            <property name="mapperLocations" value="classpath:tk/mybatis/simple/mapper/*.xml"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="tk.mybatis.simple.mapper"/>
            
            <property name="sqlSessionFactoryBeanName" value="mySqlSessionFactory"/>
        </bean>
    
        
        <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
        
        <tx:annotation-driven transaction-manager="txManager"/>
    
        
        <tx:advice id="transactionAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="insert*" rollback-for="java.lang.Exception"/>
                <tx:method name="delete*" rollback-for="java.lang.Exception"/>
                <tx:method name="update*" rollback-for="java.lang.Exception"/>
                <tx:method name="*" read-only="true"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:advisor advice-ref="transactionAdvice" pointcut="execution(* tk.mybatis.*.service..*Service*.*(..))"/>
        </aop:config>
        <aop:aspectj-autoproxy/>
    
    </beans>

### 添加log4j2.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <configuration status="INFO" monitorInterval="30">
        <appenders>
            
            
            <Console name="Console" target="SYSTEM_OUT">
                
                <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
                
                <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
            </Console>
            
            <RollingFile name="RollingFile" fileName="logs/trace.log"
                         append="true" filePattern="logs/$${date:yyyy-MM}/trace-%d{yyyy-MM-dd}-%i.log.gz">
                
                <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
       
                <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
                <Policies>
                    <TimeBasedTriggeringPolicy/>
                    <SizeBasedTriggeringPolicy size="100 MB"/>
                </Policies>
            </RollingFile>
      
            <RollingFile name="RollingErrorFile" fileName="logs/error.log"
                         append="true" filePattern="logs/$${date:yyyy-MM}/error-%d{yyyy-MM-dd}-%i.log.gz">
       
                <ThresholdFilter level="WARN" onMatch="ACCEPT" onMismatch="DENY"/>
       
                <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
                <Policies>
                    <TimeBasedTriggeringPolicy/>
                    <SizeBasedTriggeringPolicy size="100 MB"/>
                </Policies>
            </RollingFile>
        </appenders>
        <loggers>
            
            <logger name="org.springframework" level="INFO"/>
            <logger name="org.mybatis" level="INFO"/>
            <root level="INFO" includeLocation="true">
                <appender-ref ref="Console"/>
                <appender-ref ref="RollingFile"/>
                <appender-ref ref="RollingErrorFile"/>
            </root>
        </loggers>
    </configuration>

### 添加web.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xmlns="http://java.sun.com/xml/ns/javaee"
             xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
             version="3.0">
        <display-name>Archetype Created Web Application</display-name>
    
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mybatis.xml</param-value>
        </context-param>
    
        
        <filter>
            <filter-name>encodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <async-supported>true</async-supported>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF-8</param-value>
            </init-param>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
        
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        
        <listener>
            <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
        </listener>
    
        
        <servlet>
            
            <servlet-name>SpringMVC</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring-mvc.xml</param-value>
            </init-param>
            
            <load-on-startup>1</load-on-startup>
            <async-supported>true</async-supported>
        </servlet>
        <servlet-mapping>
            
            <servlet-name>SpringMVC</servlet-name>
            
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
    
        <welcome-file-list>
            
            <welcome-file>index.jsp</welcome-file>
        </welcome-file-list>
    
    </web-app>

### 开始使用 ###

### Model类 ###

tk.mybatis.simple.model.DbTest.java

### Mapper接口 ###

tk.mybatis.simple.mapper.DbTestMapper

package tk.mybatis.simple.mapper;
    
    import tk.mybatis.simple.model.DbTest;
    
    public interface DbTestMapper {
    
        DbTest queryById(Integer id);
    }

### XML映射文件 ###

XML映射文件请放于Mapper接口所在路径下，保证名称相同

tk/mybatis/simple/mapper/DbTestMapper.xml

### Controller类 ###

package tk.mybatis.simple.controller;
    
    import org.apache.logging.log4j.LogManager;
    import org.apache.logging.log4j.Logger;
    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.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.servlet.ModelAndView;
    import tk.mybatis.simple.mapper.DbTestMapper;
    import tk.mybatis.simple.model.DbTest;
    
    @Controller
    @RequestMapping(value = "/test")
    public class DbTestController {
    
        private static final Logger logger = LogManager.getLogger(DbTestController.class);
    
        @Autowired
        private DbTestMapper dbTestMapper;
    
        @GetMapping("/")
        public String index() {
            return "welcome";
        }
    
        @GetMapping("/query")
        public ModelAndView query(@RequestParam("id") Integer id) {
            DbTest dbTest = dbTestMapper.queryById(id);
            logger.info("入参：{}，查询结果：{}", id, dbTest.toString());
            ModelAndView mv = new ModelAndView();
            mv.setViewName("result");
            mv.addObject("test", dbTest);
            return mv;
        }
    }

### index.jsp ###

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html lang="zh-CN">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>首页</title>
    </head>
    <body>
    <h3>Hello World!</h3>
    <form method="get" action="<c:url value="/test/"/>">
        <button class="btn btn-default" type="submit">
            <span>开始测试</span>
        </button>
    </form>
    </body>
    </html>

### welcome.jsp ###

<%--
      Created by IntelliJ IDEA.
      User: jingp
      Date: 2019/6/5
      Time: 15:17
      To change this template use File | Settings | File Templates.
    --%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html lang="zh-CN">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>查询</title>
    
    </head>
    <body>
    <h3>查询数据库</h3>
    <form method="get" action="<c:url value="/test/query"/>">
        <div class="input-group">
            <span class="input-group-addon">ID：</span>
            <input type="number" name="id" class="form-control" required>
        </div>
        <button class="btn btn-default" type="submit">
            <span>查询</span>
        </button>
    </form>
    
    <script src="../../static/jquery.min.js"></script>
    </body>
    </html>

### result.jsp ###

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html lang="zh-CN">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>结果</title>
    </head>
    <body>
    <h4>查询结果：${test.toString()}</h4>
    <form method="post" action="<c:url value="/"/>">
        <button class="btn btn-default" type="submit">
            <span>退出</span>
        </button>
    </form>
    
    <script src="../../static/jquery.min.js"></script>
    </body>
    </html>

### 运行程序 ###

配置好Tomcat，然后启动就可以了，进入页面，点击开始测试，然后查询数据库就可以通过MyBatis操作数据库了

## 三、集成SpringBoot ##

### 引入依赖 ###

<?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">
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.3.RELEASE</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
        
        <groupId>tk.mybatis.simple</groupId>
        <artifactId>mybatis-spring-boot</artifactId>
        <packaging>jar</packaging>
    
        <properties>
            <java.version>1.8</java.version>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        </properties>
    
        <dependencyManagement>
            <dependencies>
                <dependency>
                    <groupId>org.apache.logging.log4j</groupId>
                    <artifactId>log4j-bom</artifactId>
                    <version>2.13.3</version>
                    <scope>import</scope>
                    <type>pom</type>
                </dependency>
            </dependencies>
        </dependencyManagement>
    
        <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-web</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.16.22</version>
                <scope>provided</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.4</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.19</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.2.3</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.3.0</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-web</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-1.2-api</artifactId>
            </dependency>
            <dependency> 
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-jcl</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.7</version>
            </dependency>
            
            <dependency>
                <groupId>com.lmax</groupId>
                <artifactId>disruptor</artifactId>
                <version>3.4.2</version>
            </dependency>
            
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.54</version>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>basic</finalName>
            
            <plugins>
                
                
                <plugin>
                    <groupId>org.codehaus.mojo</groupId>
                    <artifactId>appassembler-maven-plugin</artifactId>
                    <version>1.10</version>
                    <configuration>
                        
                        <platforms>
                            <platform>unix</platform>
                            <platform>windows</platform>
                        </platforms>
                        
                        <repositoryName>lib</repositoryName>
                        
                        <repositoryLayout>flat</repositoryLayout>
                        
                        <configurationDirectory>conf</configurationDirectory>
                        
                        <copyConfigurationDirectory>true</copyConfigurationDirectory>
                        
                        <configurationSourceDirectory>src/main/resources</configurationSourceDirectory>
                        <includeConfigurationDirectoryInClasspath>true</includeConfigurationDirectoryInClasspath>
                        
                        <assembleDirectory>${project.build.directory}/basic-assemble</assembleDirectory>
                        <programs>
                            <program>
                                
                                <mainClass>com.fullmoon.study.Application</mainClass>
                                
                                <id>basic</id>
                                
                                <jvmSettings>
                                    <extraArguments>
                                        
                                        <extraArgument>-XX:+HeapDumpOnOutOfMemoryError</extraArgument>
                                        <extraArgument>-XX:HeapDumpPath=/app/dump</extraArgument>
                                        <extraArgument>-Xmx512m</extraArgument>
                                        <extraArgument>-Xms512m</extraArgument>
                                    </extraArguments>
                                </jvmSettings>
                            </program>
                        </programs>
                    </configuration>
                </plugin>
                
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                    </configuration>
                </plugin>
            </plugins>
            
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>*.properties</include>
                        <include>*.xml</include>
                        <include>*.yml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources/mapper</directory>
                    <targetPath>mapper/</targetPath>
                    <includes>
                        <include>*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    
    </project>

### 添加mybatis-config.xml ###

### MyBatis 的配置文件 ###

### 添加application.yml ###

### Spring Boot 的配置文件 ###

server:
      port: 9092
      servlet:
        context-path: /mybatis-spring-boot-demo
      tomcat:
        accept-count: 200
        min-spare-threads: 200
    spring:
      application:
        name: mybatis-spring-boot-demo
      profiles:
        active: test
      servlet:
        multipart:
          max-file-size: 100MB
          max-request-size: 100MB
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        druid:
          driver-class-name: com.mysql.cj.jdbc.Driver # 不配置则会根据 url 自动识别
          initial-size: 5 # 初始化时建立物理连接的个数
          min-idle: 20 # 最小连接池数量
          max-active: 20 # 最大连接池数量
          max-wait: 10000 # 获取连接时最大等待时间，单位毫秒
          validation-query: SELECT 1 # 用来检测连接是否有效的 sql
          test-while-idle: true # 申请连接的时候检测，如果空闲时间大于 timeBetweenEvictionRunsMillis，则执行 validationQuery 检测连接是否有效
          test-on-borrow: false # 申请连接时执行 validationQuery 检测连接是否有效
          min-evictable-idle-time-millis: 120000 # 连接保持空闲而不被驱逐的最小时间，单位是毫秒
          time-between-eviction-runs-millis: 3600000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
          filters: stat,log4j,wall # 配置过滤器，stat-监控统计，log4j-日志，wall-防御 SQL 注入
          connection-properties: 'druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000' # StatFilter配置，打开合并 SQL 功能和慢 SQL 记录
          web-stat-filter: # WebStatFilter 配置
            enabled: true
            url-pattern: '/*'
            exclusions: '*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*'
          stat-view-servlet: # StatViewServlet 配置
            enabled: true
            url-pattern: '/druid/*'
            reset-enable: false
            login-username: druid
            login-password: druid
          aop-patterns: 'com.fullmoon.study.service.*' # Spring 监控配置
    mybatis:
      type-aliases-package: tk.mybatis.simple.model
      mapper-locations: classpath:mapper/*.xml
      config-location: classpath:mybatis-config.xml
    pagehelper:
      helper-dialect: mysql
      reasonable: true # 分页合理化参数
      offset-as-page-num: true # 将 RowBounds 中的 offset 参数当成 pageNum 使用
      supportMethodsArguments: true # 支持通过 Mapper 接口参数来传递分页参数
    # 测试环境
    ---
    spring:
      profiles: test
      datasource:
        druid:
          url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
          username: root
          password: password

注意上面 mybatis 的相关配置，XML 映射文件是存放于 classpath 下的 mapper 文件夹下面的

### 添加log4j2.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <configuration status="INFO" monitorInterval="30">
     <appenders>
      
      
      <Console name="Console" target="SYSTEM_OUT">
       
       <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
       
       <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
      </Console>
      
      <RollingFile name="RollingFile" fileName="logs/trace.log"
          append="true" filePattern="logs/$${date:yyyy-MM}/trace-%d{yyyy-MM-dd}-%i.log.gz">
       
       <ThresholdFilter level="INFO" onMatch="ACCEPT" onMismatch="DENY"/>
       
       <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
       <Policies>
        <TimeBasedTriggeringPolicy/>
        <SizeBasedTriggeringPolicy size="100 MB"/>
       </Policies>
      </RollingFile>
      
      <RollingFile name="RollingErrorFile" fileName="logs/error.log"
          append="true" filePattern="logs/$${date:yyyy-MM}/error-%d{yyyy-MM-dd}-%i.log.gz">
       
       <ThresholdFilter level="WARN" onMatch="ACCEPT" onMismatch="DENY"/>
       
       <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss,SSS}:%4p %t (%F:%L) - %m%n"/>
       <Policies>
        <TimeBasedTriggeringPolicy/>
        <SizeBasedTriggeringPolicy size="100 MB"/>
       </Policies>
      </RollingFile>
     </appenders>
     <loggers>
      
      <logger name="org.springframework" level="INFO"/>
      <logger name="org.mybatis" level="INFO"/>
      <root level="INFO" includeLocation="true">
       <appender-ref ref="Console"/>
       <appender-ref ref="RollingFile"/>
       <appender-ref ref="RollingErrorFile"/>
      </root>
     </loggers>
    </configuration>

### 开始使用 ###

在Spring Boot项目的启动类上面添加 @MapperScan(“tk.mybatis.simple.mapper”) 注解，指定Mapper接口所在的包路径，启动类如下：

@SpringBootApplication
    @EnableTransactionManagement
    @MapperScan("tk.mybatis.simple.mapper")
    public class Application {
        public static void main(String[] args){
            SpringApplication.run(Application.class, args);
        }
    }

然后在 classpath 下的 mapper 文件夹（根据 application.yml 配置文件中的定义）添加 XML 映射文件，即可开始使用 MyBatis了

其中 @EnableTransactionManagement 注解表示开启事务的支持（@SpringBootApplication 注解在加载容器的时候已经开启事务管理的功能了，也可不需要添加该注解）

在需要事务的方法或者类上面添加 @Transactional 注解即可，引入spring-boot-starter-jdbc依赖，注入的是 DataSourceTransactionManager 事务管理器，事务的使用示例如下：

@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
    public int insertFeedback(UserFeedbackInfo requestAddParam) {
        try {
            // ... 业务逻辑 
        } catch (Exception e) {
            // 事务回滚
            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
            return 0;
        }
    }

## 四、SpringBoot配置数据库密码加密？ ##

### 1.借助Druid数据源 ###

Druid数据源支持数据库密码进行加密，在Spring Boot中配置方式如下：

加密数据库密码，通过Druid的com.alibaba.druid.filter.config.ConfigTools工具类对数据库密码进行加密（RSA 算法），如下：

public static void main(String[] args) throws Exception {
        ConfigTools.main(new String[]{"you_password"});
    }

**或者执行以下命令：**

java -cp druid-1.0.16.jar com.alibaba.druid.filter.config.ConfigTools you_password

**输出：**

privateKey:MIIBVgIBADANBgkqhkiG9w0BAQEFAASCAUAwggE8AgEAAkEA6+4avFnQKP+O7bu5YnxWoOZjv3no4aFV558HTPDoXs6EGD0HP7RzzhGPOKmpLQ1BbA5viSht+aDdaxXp6SvtMQIDAQABAkAeQt4fBo4SlCTrDUcMANLDtIlax/I87oqsONOg5M2JS0jNSbZuAXDv7/YEGEtMKuIESBZh7pvVG8FV531/fyOZAiEA+POkE+QwVbUfGyeugR6IGvnt4yeOwkC3bUoATScsN98CIQDynBXC8YngDNwZ62QPX+ONpqCel6g8NO9VKC+ETaS87wIhAKRouxZL38PqfqV/WlZ5ZGd0YS9gA360IK8zbOmHEkO/AiEAsES3iuvzQNYXFL3x9Tm2GzT1fkSx9wx+12BbJcVD7AECIQCD3Tv9S+AgRhQoNcuaSDNluVrL/B/wOmJRLqaOVJLQGg==
    publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAOvuGrxZ0Cj/ju27uWJ8VqDmY7956OGhVeefB0zw6F7OhBg9Bz+0c84RjzipqS0NQWwOb4kobfmg3WsV6ekr7TECAwEAAQ==
    password:PNak4Yui0+2Ft6JSoKBsgNPl+A033rdLhFw+L0np1o+HDRrCo9VkCuiiXviEMYwUgpHZUFxb2FpE0YmSguuRww==
    然后在 application.yml 中添加以下配置：
    
    spring:
      datasource:
        druid:
          password: ${password} # 加密后的数据库密码
          filters: config # 配置 ConfigFilter ，通过它进行解密
          # 提示需要对数据库密码进行解密
          connection-properties: 'config.decrypt=true;config.decrypt.key=${publickey}'
    publicKey: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAJvQUB7pExzbzTpaQCCY5qS+86MgYWvRpqPUCzjFwdMgrBjERE5X5oojSe48IGZ6UtCCeaI0PdhkFoNaJednaqMCAwEAAQ==

这样就OK了，主要是在 ConfigFilter过滤器中，会先对密码进行解密，然后再设置到DataSource数据源

### 2.借助Jasypt加密包 ###

Jasypt是一个Java库，可以让开发人员将基本的加密功能添加到项目中，而无需对加密的工作原理有深入的了解

接下来讲述的在Spring Boot项目中如何使用Jasypt，其他使用方法请参考Jasypt Github地址

**引入依赖**

<dependency>
        <groupId>com.github.ulisesbocchio</groupId>
        <artifactId>jasypt-spring-boot-starter</artifactId>
        <version>3.0.3</version>
    </dependency>

**添加注解**

在启动类上面添加@EnableEncryptableProperties注解，使整个Spring环境启用Jasypt加密功能，如下：

@SpringBootApplication
    @EnableEncryptableProperties
    public class Application {
        public static void main(String[] args){
            SpringApplication.run(Application.class, args);
        }
    }

**获取密文**

需要通过Jasypt官方提供的jar包进行加密，如下：

import com.ulisesbocchio.jasyptspringboot.properties.JasyptEncryptorConfigurationProperties;
    import org.jasypt.encryption.pbe.PooledPBEStringEncryptor;
    import org.jasypt.encryption.pbe.config.PBEConfig;
    import org.jasypt.encryption.pbe.config.SimpleStringPBEConfig;
    /**
     * @author jingping.liu
     * @date 2020-11-20
     * @description Jasypt 安全框架加密类工具包
     */
    public class JasyptUtils {
        /**
         * 生成一个{@link PBEConfig} 配置对象
         * <p>
         * 注意！！！
         * 可查看Jasypt全局配置对象{@link JasyptEncryptorConfigurationProperties}中的默认值
         * 这里的配置建议与默认值保持一致，否则需要在application.yml中定义这里的配置（也可以通过 JVM 参数的方法）
         * 注意password和algorithm 配置项，如果不一致在启动时可能会解密失败而报错
         *
         * @param salt 盐值
         * @return SimpleStringPBEConfig 加密配置
         */
        private static SimpleStringPBEConfig generatePBEConfig(String salt) {
            SimpleStringPBEConfig config = new SimpleStringPBEConfig();
            // 设置salt盐值
            config.setPassword(salt);
            // 设置要创建的加密程序池的大小，这里仅临时创建一个，设置 1 即可
            config.setPoolSize("1");
            // 设置加密算法， 此算法必须由 JCE 提供程序支持，默认值 PBEWITHHMACSHA512ANDAES_256
            config.setAlgorithm("PBEWithMD5AndDES");
            // 设置应用于获取加密密钥的哈希迭代次数
            config.setKeyObtentionIterations("1000");
            // 设置要请求加密算法的安全提供程序的名称
            config.setProviderName("SunJCE");
            // 设置 salt 盐的生成器
            config.setSaltGeneratorClassName("org.jasypt.salt.RandomSaltGenerator");
            // 设置 IV 生成器
            config.setIvGeneratorClassName("org.jasypt.iv.RandomIvGenerator");
            // 设置字符串输出的编码形式，支持 base64 和 hexadecimal
            config.setStringOutputType("base64");
            return config;
        }
    
        /**
         * 通过 {@link PooledPBEStringEncryptor} 进行加密密
         *
         * @param salt 盐值
         * @param message 需要加密的内容
         * @return 加密后的内容
         */
        public static String encrypt(String salt, String message) {
            PooledPBEStringEncryptor encryptor = new PooledPBEStringEncryptor();
            SimpleStringPBEConfig pbeConfig = generatePBEConfig(salt);
            // 生成加密配置
            encryptor.setConfig(pbeConfig);
            System.out.println("----ARGUMENTS-------------------");
            System.out.println("message: " + message);
            System.out.println("salt: " + pbeConfig.getPassword());
            System.out.println("algorithm: " + pbeConfig.getAlgorithm());
            System.out.println("stringOutputType: " + pbeConfig.getStringOutputType());
            // 进行加密
            String cipherText = encryptor.encrypt(message);
            System.out.println("----OUTPUT-------------------");
            System.out.println(cipherText);
            return cipherText;
        }
        public static String decrypt(String salt, String message) {
            PooledPBEStringEncryptor encryptor = new PooledPBEStringEncryptor();
            // 设置解密配置
            encryptor.setConfig(generatePBEConfig(salt));
            // 进行解密
            return encryptor.decrypt(message);
        }
        public static void main(String[] args) {
            // 随机生成一个 salt 盐值
            String salt = UUID.randomUUID().toString().replace("-", "");
            // 进行加密
            encrypt(salt, "message");
        }
    }

### 如何使用 ###

直接在application.yml配置文件中添加Jasypt配置和生成的密文

jasypt:
      encryptor:
        password:salt#salt盐值，需要和加密时使用的salt一致
        algorithm:PBEWithMD5AndDES#加密算法，需要和加密时使用的算法一致
        string-output-type:hexadecimal#密文格式，，需要和加密时使用的输出格式一致
    spring:
      datasource:
        druid:
          username:root
          password:ENC(cipherText)#Jasypt密文格式：ENC(密文)

“salt盐值也可以通过JVM参数进行设置，例如：-Djasypt.encryptor.password=salt”

启动后，Jasypt会先根据配置将ENC(密文)进行解密，然后设置到Spring环境中

## 最后 ##

> 我这边整理了：Mybatis常见的一些知识点、MyBatis源码分析图解、MyBtis面试解析、深入浅出MyBatis技术原理与实战PDF272页，Mybatis思维导图（还有Java核心知识点、面试专题和20年最新的互联网真题、电子书等）有需要的朋友可以[点击这里获取][Link 1]。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzQ4Nzk1NjA3_size_16_color_FFFFFF_t_70_pic_center 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzQ4Nzk1NjA3_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/d29b8757c10549bab4148084e231f97a.png
[b8d1104bc97f57c47058f8dd1282c1a7.png]: /images/20221120/08931115cd0d4e56b6e97c15fd3dbbbb.png
[Link 1]: https://shimo.im/docs/6gXtcP8R99jtG9dX
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzQ4Nzk1NjA3_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221120/aca4b7f597714f95b3bf9d246a54d2d1.png