From 6bb79064a8d717e191ceda7cb2dc1549d3613691 Mon Sep 17 00:00:00 2001
From: buhuazhen <hua100783@gmail.com>
Date: 星期二, 26 八月 2025 13:58:03 +0800
Subject: [PATCH] purchase添加类型 以及新增字典查询方法
---
ruoyi-framework/src/main/java/com/ruoyi/framework/config/MybatisPlusConfig.java | 33 ++++++++++++++++++++++++++++-----
1 files changed, 28 insertions(+), 5 deletions(-)
diff --git a/ruoyi-framework/src/main/java/com/ruoyi/framework/config/MybatisPlusConfig.java b/ruoyi-framework/src/main/java/com/ruoyi/framework/config/MybatisPlusConfig.java
index 4de14eb..84e8879 100644
--- a/ruoyi-framework/src/main/java/com/ruoyi/framework/config/MybatisPlusConfig.java
+++ b/ruoyi-framework/src/main/java/com/ruoyi/framework/config/MybatisPlusConfig.java
@@ -1,10 +1,13 @@
package com.ruoyi.framework.config;
import com.baomidou.mybatisplus.annotation.DbType;
+import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.BlockAttackInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
+import com.ruoyi.common.handler.LocalDateTimeTypeHandler;
+import org.apache.ibatis.type.JdbcType;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@@ -12,15 +15,35 @@
public class MybatisPlusConfig {
@Bean
- public MybatisPlusInterceptor mybatisPlusInterceptor(){
+ public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
- // 鍒嗛〉
- interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.POSTGRE_SQL));
- // 涔愯閿�
+ // 1. 鍒嗛〉鎻掍欢 - 鎸囧畾 PostgreSQL 鏁版嵁搴撶被鍨�
+ PaginationInnerInterceptor pagination = new PaginationInnerInterceptor(DbType.POSTGRE_SQL);
+ pagination.setOptimizeJoin(true); // 浼樺寲 JOIN 鏌ヨ
+ pagination.setMaxLimit(500L); // 璁剧疆鏈�澶у崟椤甸檺鍒�
+ interceptor.addInnerInterceptor(pagination);
+
+ // 2. 涔愯閿佹彃浠�
interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
- // 闃叉鍏ㄥ眬鍒犻櫎鎴栨洿鏂�
+
+ // 3. 闃叉鍏ㄨ〃鏇存柊/鍒犻櫎鎻掍欢
interceptor.addInnerInterceptor(new BlockAttackInnerInterceptor());
+
return interceptor;
}
+ // 4. 娣诲姞鍏ㄥ眬绫诲瀷澶勭悊鍣ㄩ厤缃�
+ @Bean
+ public ConfigurationCustomizer configurationCustomizer() {
+ return configuration -> {
+ // 娉ㄥ唽 LocalDateTime 绫诲瀷澶勭悊鍣�
+ configuration.getTypeHandlerRegistry().register(new LocalDateTimeTypeHandler());
+
+ // 璁剧疆绌哄�煎鐞嗙瓥鐣�
+ configuration.setJdbcTypeForNull(JdbcType.NULL);
+
+ // 鍚敤鑷姩椹煎嘲鍛藉悕瑙勫垯鏄犲皠
+ configuration.setMapUnderscoreToCamelCase(true);
+ };
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3