@PostMapping(value = "update")
     public Result<String> update(@RequestBody @Validated(value = UpdateGroup.class) User user) {
         int update = userMapper.updateById(user);
         return update > 0 ? Result.ok(null) : Result.err(null);
     }
 ?
     @GetMapping(value = "get")
     public Result<List<User>> get(@RequestParam(value = "id", required = false) Integer id,
                                   @RequestParam(value = "name", required = false) String name
     ) {
         LambdaQueryWrapper<User> queryChainWrapper = new LambdaQueryWrapper<>();
         queryChainWrapper.eq(id != null, User::getId, id);
         queryChainWrapper.eq(name != null, User::getUsername, name);
         List<User> records = userMapper.selectPage(new Page<User>(0, 10), queryChainWrapper).getRecords();
         return Result.ok(records);
     }

 /**
  * @author shigenfu
  * @date 2024/6/16 10:01
  */
 @Intercepts({
         @Signature(type = Executor.class, method = "query", args = {MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class}),
         @Signature(type = Executor.class, method = "query", args = {MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class, CacheKey.class, BoundSql.class}),
         @Signature(type = Executor.class, method = "update", args = {MappedStatement.class, Object.class})
 })
 @Slf4j
 public class SqlInterceptor implements Interceptor {
 ?
     @Override
     public Object intercept(Invocation invocation) throws Throwable {
         // 統(tǒng)計(jì)sql執(zhí)行耗時(shí)
         long startTime = System.currentTimeMillis();
         Object proceed = invocation.proceed();
         long endTime = System.currentTimeMillis();
 ?
         String printSql = null;
         try {
             printSql = generateSql(invocation);
         } catch (Exception exception) {
             log.error("獲取sql異常", exception);
         } finally {
             long costTime = endTime - startTime;
             log.info("\n 執(zhí)行SQL耗時(shí)：{}ms \n 執(zhí)行SQL：{}", costTime, printSql);
         }
         return proceed;
     }
 ?
     private static String generateSql(Invocation invocation) {
 ?
         MappedStatement statement = (MappedStatement) invocation.getArgs()[0];
         Object parameter = null;
         if (invocation.getArgs().length > 1) {
             parameter = invocation.getArgs()[1];
         }
         Configuration configuration = statement.getConfiguration();
         BoundSql boundSql = statement.getBoundSql(parameter);
 ?
         // 獲取參數(shù)對(duì)象
         Object parameterObject = boundSql.getParameterObject();
         // 獲取參數(shù)映射
         List<ParameterMapping> params = boundSql.getParameterMappings();
         // 獲取到執(zhí)行的SQL
         String sql = boundSql.getSql();
         // SQL中多個(gè)空格使用一個(gè)空格代替
         sql = sql.replaceAll("[\s]+", " ");
         if (!ObjectUtils.isEmpty(params) && !ObjectUtils.isEmpty(parameterObject)) {
             // TypeHandlerRegistry 是 MyBatis 用來管理 TypeHandler 的注冊(cè)器 TypeHandler 用于在 Java 類型和 JDBC 類型之間進(jìn)行轉(zhuǎn)換
             TypeHandlerRegistry typeHandlerRegistry = configuration.getTypeHandlerRegistry();
             // 如果參數(shù)對(duì)象的類型有對(duì)應(yīng)的 TypeHandler，則使用 TypeHandler 進(jìn)行處理
             if (typeHandlerRegistry.hasTypeHandler(parameterObject.getClass())) {
                 sql = sql.replaceFirst("\?", Matcher.quoteReplacement(getParameterValue(parameterObject)));
             } else {
                 // 否則，逐個(gè)處理參數(shù)映射
                 for (ParameterMapping param : params) {
                     // 獲取參數(shù)的屬性名
                     String propertyName = param.getProperty();
                     MetaObject metaObject = configuration.newMetaObject(parameterObject);
                     // 檢查對(duì)象中是否存在該屬性的 getter 方法，如果存在就取出來進(jìn)行替換
                     if (metaObject.hasGetter(propertyName)) {
                         Object obj = metaObject.getValue(propertyName);
                         sql = sql.replaceFirst("\?", Matcher.quoteReplacement(getParameterValue(obj)));
                         // 檢查 BoundSql 對(duì)象中是否存在附加參數(shù)
                     } else if (boundSql.hasAdditionalParameter(propertyName)) {
                         Object obj = boundSql.getAdditionalParameter(propertyName);
                         sql = sql.replaceFirst("\?", Matcher.quoteReplacement(getParameterValue(obj)));
                     } else {
                         // SQL匹配不上，帶上“缺失”方便找問題
                         sql = sql.replaceFirst("\?", "缺失");
                     }
                 }
             }
         }
         return sql;
     }
 ?
     private static String getParameterValue(Object object) {
         String value = "";
         if (object instanceof String) {
             value = "'" + object + "'";
         } else if (object instanceof Date) {
             DateFormat format = DateFormat.getDateTimeInstance(DateFormat.DEFAULT, DateFormat.DEFAULT, Locale.CHINA);
             value = "'" + format.format((Date) object) + "'";
         } else if (!ObjectUtils.isEmpty(object)) {
             value = object.toString();
         }
         return value;
     }
 ?
     @Override
     public Object plugin(Object target) {
         return Plugin.wrap(target, this);
     }
 ?
 }

 @Configuration
 @MapperScan(value = "main.java.shigen.demo.dao")
 public class MybatisPlusConfig {
 ?
     @Bean
     public MybatisPlusInterceptor mybatisPlusInterceptor() {
         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
         // 分頁插件
         interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
         // 樂觀鎖插件
         interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
         return interceptor;
     }
 ?
     @Bean
     public ConfigurationCustomizer configurationCustomizer() {
         return configuration -> {
             configuration.addInterceptor(new SqlInterceptor());
         };
     }
 }