| | |
| | | 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; |
| | | |
| | |
| | | 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); |
| | | }; |
| | | } |
| | | } |