MyBatisPlus提供了许多实用的功能，如自动分页、通用Mapper、通用Service、通用MapperScannerConfigurer等，可以大大减少开发人员的工作量。

二、SpringBoot中MyBatisPlus的安全防护策略 1. 基本安全配置 (1)开启SQL参数绑定异常处理 在SpringBoot的配置文件中，添加如下配置：

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    db-config:
      log-statements: true

(2)设置数据库密码加密方式 在application.properties或application.yml中添加如下配置：

spring:
  datasource:
    druid:
      password: #{encodePassword}
      username: #{username}
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8#{params}

这样配置后，数据库密码会在插入数据库时自动进行加密，提高了安全性。

2. 高级安全防护措施 (1)使用乐观锁 在实体类中，为需要加锁的字段添加@Version注解，例如：

public class User {
    // 其他字段...
    @Version
    private Integer version;
}

这种方式可以有效防止脏读、不可重复读和幻读等并发问题。

(2)使用分页插件PageHelper PageHelper是一个强大的MyBatis分页插件，可以在不改变原有代码的情况下实现物理分页。

使用方法如下： 1 在pom.xml中添加依赖：

    com.github.pagehelper
    pagehelper-spring-boot-starter
    1.2.13

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    mapper-locations: classpath*:mapper/*Mapper.xml
  pagehelper: #{enabled} | default = false; helper-dialect = #{helperDialect} | mysql;reasonable = #{reasonable}; support-methods-arguments = true; params = #{params}; auto-parameters = true; row-bounds = #{rowBounds}; count-over = #{countOver}; cache-enabled = #{cacheEnabled}; cache-key-generator-column = #{cacheKeyGeneratorColumn}; cache-key-generator-expression = #{cacheKeyGeneratorExpression}; reasonable-default-limit = #{reasonableDefaultLimit}; local-cache-scope = #{localCacheScope}; use-generated-keys = #{useGeneratedKeys}; auto-mapping-behavior = #{autoMappingBehavior}; default-executor-type = #{defaultExecutorType}; default-statement-timeout = #{defaultStatementTimeout}; safe-row-bounds-enabled = #{safeRowBoundsEnabled}; lazy-load-trigger-methods = #{lazyLoadTriggerMethods}; multiple-resultset-enabled = #{multipleResultSetEnabled}; max-results-per-page = #{maxResultsPerPage}; reasonable-default-page-size = #{reasonableDefaultPageSize}; join-fetch = #{joinFetch}; fetch-height = #{fetchHeight}; big-sql-id = #{bigSqlId}; default-fetch-size = #{defaultFetchSize}; default-stmt-timeout = #{defaultStmtTimeout}; default-auto-mapping = #{defaultAutoMapping}; default-executor = #{defaultExecutor}; aliases = #{aliases}; show-sql = #{showSql}; autocommit = #{autocommit}; autorollback = #{autorollback}; flushCacheRequired = #{flushCacheRequired}; use-continues = #{useContinues}; lazy-load-trigger-methods = #{lazyLoadTriggerMethods}; multiple-resultset-enabled = #{multipleResultSetEnabled}; max-results-per-page = #{maxResultsPerPage}; reasonable-default-page-size = #{reasonableDefaultPageSize}; join_fetch = #{joinFetch}; fetch_height = #{fetchHeight}; big_sql_id = #{bigSqlId}; default_fetch_size = #{defaultFetchSize}; default_stmt_timeout = #{defaultStmtTimeout}; default_auto_mapping = #{defaultAutoMapping}; default_executor = #{defaultExecutor}; aliases = #{aliases}; show_sql = #{showSql}; autocommit = #{autocommit}; autorollback = #{autorollback}; flushCacheRequired = #{flushCacheRequired}; use_continues = #{useContinues}; lazy_load_trigger_methods = #{lazyLoadTriggerMethods}; multiple_resultset_enabled = #{multipleResultSetEnabled}; max_results_per_page = #{maxResultsPerPage}; reasonable_default_page_size = #{reasonableDefaultPageSize}; join_fetch = #{joinFetch}; fetch_height = #{fetchHeight}; big_sql_id = #{bigSqlId}; default_fetch_size = ${#dbConfig['defaultFetchSize']} | null; default_stmt_timeout=${#dbConfig['defaultStmtTimeout']} | null; default_auto_mapping=${#dbConfig['defaultAutoMapping']} | null; default_executor=${#dbConfig['defaultExecutor']} | null; aliases=${#dbConfig['aliases']} | null; show_sql=${#dbConfig['showSql']} | null; autocommit=${#dbConfig['autocommit']} | null; autorollback=${#dbConfig['autorollback']} | null; flushCacheRequired=${#dbConfig['flushCacheRequired']} | null; useContinues=${#dbConfig['useContinues']} | null; lazyLoadTriggerMethods=${#dbConfig['lazyLoadTriggerMethods']} | null; multipleResultSetEnabled=${#dbConfig['multipleResultSetEnabled']} | null; maxResultsPerPage=${#dbConfig['maxResultsPerPage']} | null; reasonableDefaultPageSize=${#dbConfig['reasonableDefaultPageSize']}|null; joinFetch=${#dbConfig['joinFetch']} | null; fetchHeight=${#dbConfig['fetchHeight']}|null; bigSqlId=${#dbConfig['bigSqlId']}|null;"

SpringBoot中MyBatisPlus的安全防护策略 - 集智数据集