Spring Boot3整合MyBatisPlus实现多数据源 1.导入多数据源pom依赖<!-- 多数据源 --> <!-- https://mvnrepository.com/artifact/com.baomidou/dynamic-datasource-spring-boot3-starter --> <dependency> <groupId>com.baomidou</groupId> <artifactId>dynamic-datasource-spring-boot3-starter</artifactId> <version>4.3.1</version> </dependency>2.配置数据库链接spring: datasource: dynamic: #主要数据库 primary: master #严格匹配模式，默认false. true未匹配到指定数据源时抛异常,false使用默认数据源 strict: false datasource: master: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/database_1?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 username: database_1 password: database_1 type: com.zaxxer.hikari.HikariDataSource account: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/database_2?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8 username: database_2 password: database_2 type: com.zaxxer.hikari.HikariDataSource charac: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/database_3?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8 username: database_3 password: database_3 type: com.zaxxer.hikari.HikariDataSource postal: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/database_4?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 username: database_4 password: database_4 type: com.zaxxer.hikari.HikariDataSource 3.在Mapper上标注@DS比如我这个mapper是Account数据库import com.baomidou.dynamic.datasource.annotation.DS; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.jam.entities.gameEntities.Accounts; import org.springframework.stereotype.Repository; @DS("account") @Repository public interface AccountsMapper extends BaseMapper<Accounts> { }4.在启动器标注扫描Mapper@MapperScan("com.jam.mapper.**")@SpringBootApplication @EnableCaching @MapperScan("com.jam.mapper.**") public class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } }

SpringBoot在使用@Cacheable缓存对象为空 1.情况SpringBoot在使用@Cacheable缓存对象为空具体就是在实体类的时候，List<Integer>为空1.1 实体类@Schema( description = "赠送礼物id") private List<Integer> itemId; @Schema( description = "赠送礼物数量") private List<Integer> itemNum;1.2 数据库item_id varchar(255)item_num varchar(255)1.3 Service@Cacheable(cacheNames = "Task", sync = true, key = "#root.methodName+ '_'+ #root.args[1] + #page + '_' + #size")1.4 具体情况在mybatisplus的日志中Row: 5, 1333, 333, [3037], [1], 1, 2025-11-05 16:10:45, null, 2025-11-05 16:10:45, 0也就是在mybatisplus读取数据的时候是正常的，但是List<Task> taskList = iPage.getRecords(); for (Task task1 : taskList) { System.out.println(task1); System.out.println(task1.getItemId() + "---" + task1.getItemNum()); }在输出taskList的时候Task(id=9, name=555, content=555, itemId=null, itemNum=null, onlineCount=1, createTime=Wed Nov 05 16:54:30 CST 2025, endTime=Thu Nov 06 00:00:00 CST 2025, updateTime=Wed Nov 05 16:54:30 CST 2025, deleted=0)null---null可以看到itemId itemNum均为nullredisTemplate配置了FastJsonRedisSerializer就是在转为 List<Integer>的时候出了问题2.解决方案我的Fastjson22.1 maven导入Fastjson2 <!-- fastJson --> <!-- https://mvnrepository.com/artifact/com.alibaba.fastjson2/fastjson2 --> <dependency> <groupId>com.alibaba.fastjson2</groupId> <artifactId>fastjson2</artifactId> <version>2.0.59</version> </dependency>2.2 附上我的RedisConfig.javaimport com.fasterxml.jackson.databind.ObjectMapper; import org.springframework.cache.annotation.EnableCaching; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.data.redis.cache.RedisCacheConfiguration; import org.springframework.data.redis.cache.RedisCacheManager; import org.springframework.data.redis.connection.RedisConnectionFactory; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.data.redis.serializer.GenericJackson2JsonRedisSerializer; import org.springframework.data.redis.serializer.RedisSerializationContext; import org.springframework.data.redis.serializer.StringRedisSerializer; import java.time.Duration; import java.util.HashMap; import java.util.Map; @Configuration //@EnableCaching开启对SpringCache的支持（提供基于方法级别的缓存） @EnableCaching public class RedisConfig { /** * 默认缓存到期时间 */ private static final Integer DEFAULT_EXPIRE_TIME = 3600; @Bean @SuppressWarnings("all") public RedisTemplate<String, Object> redisTemplate(RedisConnectionFactory redisConnectionFactory, ObjectMapper objectMapper) { //便于开发自己编写redis RedisTemplate<String, Object> template = new RedisTemplate<>(); template.setConnectionFactory(redisConnectionFactory); //序列化配置 GenericJackson2JsonRedisSerializer serializer = new GenericJackson2JsonRedisSerializer(); // FastJsonRedisSerializer<Object> serializer = new FastJsonRedisSerializer<>(Object.class); // FastJson2JsonRedisSerializer<Object> serializer = new FastJson2JsonRedisSerializer<>(Object.class); //string序列化 StringRedisSerializer stringRedisSerializer = new StringRedisSerializer(); //key 采用string的序列化 template.setKeySerializer(stringRedisSerializer); template.setValueSerializer(serializer); //hansh的key也采用string的序列化方式 template.setHashKeySerializer(stringRedisSerializer); //hansh的value也采用string的序列化方式 template.setHashValueSerializer(serializer); //设置默认 template.setDefaultSerializer(serializer); template.afterPropertiesSet(); return template; } /** * 配置SpringCache基于方法级别的缓存的过期时间、key-value的序列化方式 * * @param connectionFactory * @return */ @Bean public RedisCacheManager cacheManager(RedisConnectionFactory connectionFactory) { //设置特有的Redis配置 Map<String, RedisCacheConfiguration> speCacheConfigurations = new HashMap<>(); //定制化的Cache为300s\400s\500s speCacheConfigurations.put("cacheName1",redisCacheConfiguration(300)); speCacheConfigurations.put("cacheName2",redisCacheConfiguration(400)); speCacheConfigurations.put("cacheName3",redisCacheConfiguration(500)); //根据redis缓存配置和redis连接工厂生成redis缓存管理器 RedisCacheManager redisCacheManager = RedisCacheManager.builder(connectionFactory) .cacheDefaults(redisCacheConfiguration(DEFAULT_EXPIRE_TIME)) // 默认缓存配置 .withInitialCacheConfigurations(speCacheConfigurations) // 定制化的缓存配置 .build(); return redisCacheManager; } /** * RedisCacheConfiguration redis缓存配置 * * @param ttl 缓存过期时间 * @return */ public RedisCacheConfiguration redisCacheConfiguration(Integer ttl) { //redis缓存配置 RedisCacheConfiguration config = RedisCacheConfiguration.defaultCacheConfig() //缓存生存时间60秒 .entryTtl(Duration.ofSeconds(ttl)) // 配置Key序列化（解决乱码的问题） .serializeKeysWith(RedisSerializationContext.SerializationPair.fromSerializer(new StringRedisSerializer())) // 配置Value序列化 .serializeValuesWith(RedisSerializationContext.SerializationPair .fromSerializer( new GenericJackson2JsonRedisSerializer() // new FastJsonRedisSerializer<Object>(Object.class) )) // 不缓存空值 .disableCachingNullValues(); return config; } }2.3 创建JsonListIntegerTypeHandler.javaimport com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.TypeReference; import org.apache.ibatis.type.BaseTypeHandler; import org.apache.ibatis.type.JdbcType; import java.sql.CallableStatement; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; public class JsonListIntegerTypeHandler extends BaseTypeHandler<List<Integer>> { // 插入/更新时：将List<Integer>转为JSON字符串存入数据库 @Override public void setNonNullParameter(PreparedStatement ps, int i, List<Integer> parameter, JdbcType jdbcType) throws SQLException { String jsonStr = JSON.toJSONString(parameter); // 例如：[3037, 3038] ps.setString(i, jsonStr); } // 查询时：从数据库读取字符串并解析为List<Integer> @Override public List<Integer> getNullableResult(ResultSet rs, String columnName) throws SQLException { String jsonStr = rs.getString(columnName); return parseJsonToList(jsonStr); } @Override public List<Integer> getNullableResult(ResultSet rs, int columnIndex) throws SQLException { String jsonStr = rs.getString(columnIndex); return parseJsonToList(jsonStr); } @Override public List<Integer> getNullableResult(CallableStatement cs, int columnIndex) throws SQLException { String jsonStr = cs.getString(columnIndex); return parseJsonToList(jsonStr); } // 解析JSON字符串为List<Integer> private List<Integer> parseJsonToList(String jsonStr) { if (jsonStr == null || jsonStr.trim().isEmpty()) { return null; } // 使用FastJSON解析为List<Integer> return JSON.parseObject(jsonStr, new TypeReference<List<Integer>>() {}); } }2.4 在实体类上注解@TableField @Schema( description = "赠送礼物id") @TableField(value = "item_id", typeHandler = JsonListIntegerTypeHandler.class) private List<Integer> itemId; @Schema( description = "赠送礼物数量") @TableField(value = "item_Num", typeHandler = JsonListIntegerTypeHandler.class) private List<Integer> itemNum;2.5 最重要的在properties或者yaml中启动Handler下面的xxx换成你自己包的目录2.5.1 yamlmybatis-plus: typehandlers-package: com.xxx.handler2.5.2 propertiesmybaits-plus.typehandlers-package=com.xxx.handler3 结果展示Task(id=9, name=555, content=555, itemId=[3037], itemNum=[1], onlineCount=1, createTime=Wed Nov 05 16:54:30 CST 2025, endTime=Thu Nov 06 00:00:00 CST 2025, updateTime=Wed Nov 05 16:54:30 CST 2025, deleted=0)[3037]---[1]

腾讯EdgeOne-免费CDN全球加速 本站已接入EdgeOne获取免费码目前获取免费码有三个方式发送X推文去Discord每天15:00/18:00/21:00在giveaway频道抽奖加入github开发人员计划目前测试下来不错

【Docker】WARNING: IPv4 forwarding is disabled. Networking will not work. docker创建容器报错：WARNING: IPv4 forwarding is disabled. Networking will not work.问题原因没有开启转发，docker网桥配置完后，需要开启转发，配置/etc/sysctl.conf添加net.ipv4.ip_forward=1修改重启Network、Dockersystemctl restart network && systemctl restart docker或sudo sysctl -p

2025 Jetbrains （IDE、WebStorm等）激活问题解决（We could not validate your license FV8EM46DQYC5AW9） 找到jetbra目录，config-jetbrains/url.conf 文件，新增以下内容保存即可[URL] PREFIX,https://account.jetbrains.com.cn/lservice/rpc/validateKey.action知了大佬官博：https://zhile.io/2024/09/05/jetbrains-2024-2-region.htmljetbra工具：https://3.jetbra.in/