• springboot整合其它项目

    目录

    一，整合Druid

     

    二，整合Redis(非注解式缓存 )

    三，整合Redis(注解式缓存 )

    一，整合Druid

    学习网址：https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter

     添加配置，不要最新的，进过测试SQL监控失效

    pom.xml依赖

    1. <dependency>
    2.        <groupId>com.alibabagroupId>
    3.        <artifactId>druid-spring-boot-starterartifactId>
    4.        <version>1.1.10version>
    5.   dependency>

    application.yml

    1. mybatis:
    2.     mapper-locations: classpath:mappers/**/*.xml
    3.     type-aliases-package: com.dengxiyan.springboot04.entity
    4. logging:
    5.     level:com.dengxiyan.springboot04: debug
    6. server:
    7.     port: 8080
    8. spring:
    9.     application:
    10.         name: springboot04
    11.         datasource:
    12.             driver-class-name: com.mysql.jdbc.Driver
    13.             name: defaultDataSource
    14.             mima: 123456
    15.             url: jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    16.             username: root
    17.             type: com.alibaba.druid.pool.DruidDataSource
    18.             druid:
    19.                 #2.连接池配置
    20.                 #初始化连接池的连接数量 大小，最小，最大
    21.                 initial-size: 5
    22.                 min-idle: 5
    23.                 max-active: 20
    24.                 #配置获取连接等待超时的时间
    25.                 max-wait: 60000
    26.                 #配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    27.                 time-between-eviction-runs-millis: 60000
    28.                 # 配置一个连接在池中最小生存的时间，单位是毫秒
    29.                 min-evictable-idle-time-millis: 30000
    30.                 validation-query: SELECT 1 FROM DUAL
    31.                 test-while-idle: true
    32.                 test-on-borrow: true
    33.                 test-on-return: false
    34.                 # 是否缓存preparedStatement，也就是PSCache  官方建议MySQL下建议关闭   个人建议如果想用SQL防火墙 建议打开
    35.                 pool-prepared-statements: true
    36.                 max-pool-prepared-statement-per-connection-size: 20
    37.                 # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
    38.                 filter:
    39.                     stat:
    40.                         merge-sql: true
    41.                         slow-sql-millis: 5000
    42.                 #3.基础监控配置
    43.                 web-stat-filter:
    44.                     enabled: true
    45.                     url-pattern: /*
    46.                     #设置不统计哪些URL
    47.                     exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
    48.                     session-stat-enable: true
    49.                     session-stat-max-count: 100
    51.     freemarker:
    52.         cache: false
    53.         charset: utf-8
    54.         expose-request-attributes: true
    55.         expose-session-attributes: true
    56.         suffix: .ftl
    57.         template-loader-path: classpath:/templates/
    58.     resources:
    59.         static-locations: classpath:/static/**
    60.    mvc:
    61.        static-path-pattern: /static/**
    62.     pagehelper:
    63.         reasonable: true
    64.         supportMethodsArguments: true
    65.         page-size-zero: true
    66.         helper-dialect: mysql

    效果图

     输入yil文件中对应的用户名及密码即可    进入首页

    在我们访问地址之后 URL监控会有限显示

     

    二，整合Redis(非注解式缓存 )

    application.yml相关配置

    1. mybatis:
    2.     mapper-locations: classpath:mappers/**/*.xml
    3.     type-aliases-package: com.dengxiyan.springboot04.entity
    4. logging:
    5.     level:com.dengxiyan.springboot04: debug
    6. server:
    7.     port: 8080
    8. spring:
    9.     application:
    10.         name: springboot04
    11.         datasource:
    12.             driver-class-name: com.mysql.jdbc.Driver
    13.             name: defaultDataSource
    14.             mima: 123456
    15.             url: jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    16.             username: root
    17.             type: com.alibaba.druid.pool.DruidDataSource
    18.             druid:
    19.                 #2.连接池配置
    20.                 #初始化连接池的连接数量 大小，最小，最大
    21.                 initial-size: 5
    22.                 min-idle: 5
    23.                 max-active: 20
    24.                 #配置获取连接等待超时的时间
    25.                 max-wait: 60000
    26.                 #配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    27.                 time-between-eviction-runs-millis: 60000
    28.                 # 配置一个连接在池中最小生存的时间，单位是毫秒
    29.                 min-evictable-idle-time-millis: 30000
    30.                 validation-query: SELECT 1 FROM DUAL
    31.                 test-while-idle: true
    32.                 test-on-borrow: true
    33.                 test-on-return: false
    34.                 # 是否缓存preparedStatement，也就是PSCache  官方建议MySQL下建议关闭   个人建议如果想用SQL防火墙 建议打开
    35.                 pool-prepared-statements: true
    36.                 max-pool-prepared-statement-per-connection-size: 20
    37.                 # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
    38.                 filter:
    39.                     stat:
    40.                         merge-sql: true
    41.                         slow-sql-millis: 5000
    42.                 #3.基础监控配置
    43.                 web-stat-filter:
    44.                     enabled: true
    45.                     url-pattern: /*
    46.                     #设置不统计哪些URL
    47.                     exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
    48.                     session-stat-enable: true
    49.                     session-stat-max-count: 100
    50.  
    51.     freemarker:
    52.         cache: false
    53.         charset: utf-8
    54.         expose-request-attributes: true
    55.         expose-session-attributes: true
    56.         suffix: .ftl
    57.         template-loader-path: classpath:/templates/
    58.     resources:
    59.         static-locations: classpath:/static/**
    60.    mvc:
    61.        static-path-pattern: /static/**
    62.     redis:
    63.         host: 192.168.230.129
    64.         password: xiaodeng_redis
    65.         port: 6379
    66.         database: 0
    67.     pagehelper:
    68.         reasonable: true
    69.         supportMethodsArguments: true
    70.         page-size-zero: true
    71.         helper-dialect: mysql

    配置类RedisConfig.java

    1. package com.dengxiyan.springboot04.config;
    2.  
    3. import org.springframework.context.annotation.Bean;
    4. import org.springframework.context.annotation.Configuration;
    5. import org.springframework.data.redis.connection.RedisConnectionFactory;
    6. import org.springframework.data.redis.core.RedisTemplate;
    7. import org.springframework.data.redis.serializer.GenericJackson2JsonRedisSerializer;
    8. import org.springframework.data.redis.serializer.StringRedisSerializer;
    9.  
    10.  
    11. @Configuration
    12. public class RedisConfig {
    13.     @Bean
    14.     public RedisTemplate<String,Object> getRedisTemplate(RedisConnectionFactory connectionFactory){
    15.         RedisTemplate<String,Object> redisTemplate = new RedisTemplate<>();
    16.  
    17.         redisTemplate.setKeySerializer(new StringRedisSerializer());
    18.         redisTemplate.setHashKeySerializer(new StringRedisSerializer());
    19.         redisTemplate.setValueSerializer(new GenericJackson2JsonRedisSerializer());
    20.         redisTemplate.setHashValueSerializer(new GenericJackson2JsonRedisSerializer());
    21. //        redisTemplate.afterPropertiesSet();
    22.  
    23.         redisTemplate.setConnectionFactory(connectionFactory);
    24.         return redisTemplate;
    25.     }
    26. }

    service层ClazzBizImpl.java使用

    1. @Autowired
    2.     private RedisTemplate<String,Object> redisTemplate;
    3.     
    4.     @Override
    5.     public List<Clazz> listPager(Clazz clazz, PageBean pageBean) {
    6.         List<Clazz> clzs = clazzMapper.listPager(clazz);
    7.         redisTemplate.opsForValue().set("clz:1",clzs.get(0));
    8.         redisTemplate.opsForValue().set("clzs",clzs);
    9. //        redisTemplate.opsForHash().entries()
    10.         return clzs;
    11.     }

     测试时有云服务器的可用云服务器，没有的打开虚拟机即可

     

    三，整合Redis(注解式缓存 )

    redisConfig.java

    1. package com.dengxiyan.springboot04.config;
    2.  
    3. import org.springframework.cache.annotation.EnableCaching;
    4. import org.springframework.context.annotation.Bean;
    5. import org.springframework.context.annotation.Configuration;
    6. import org.springframework.data.redis.cache.RedisCacheConfiguration;
    7. import org.springframework.data.redis.cache.RedisCacheManager;
    8. import org.springframework.data.redis.connection.RedisConnectionFactory;
    9. import org.springframework.data.redis.core.RedisTemplate;
    10. import org.springframework.data.redis.serializer.GenericJackson2JsonRedisSerializer;
    11. import org.springframework.data.redis.serializer.RedisSerializationContext;
    12. import org.springframework.data.redis.serializer.StringRedisSerializer;
    13.  
    14. import java.time.Duration;
    15. import java.util.HashMap;
    16. import java.util.HashSet;
    17. import java.util.Map;
    18. import java.util.Set;
    19.  
    20.  
    21. @EnableCaching
    22. @Configuration
    23. public class RedisConfig {
    24.     private final int defaultExpireTime = 600;
    25.  
    26.     private final int userCacheExpireTime = 60;
    27.  
    28.     private final String userCacheName = "test";
    29.  
    30.     @Bean
    31.     public RedisTemplate<String,Object> getRedisTemplate(RedisConnectionFactory connectionFactory){
    32.         RedisTemplate<String,Object> redisTemplate = new RedisTemplate<>();
    33.  
    34.         redisTemplate.setKeySerializer(new StringRedisSerializer());
    35.         redisTemplate.setHashKeySerializer(new StringRedisSerializer());
    36.         redisTemplate.setValueSerializer(new GenericJackson2JsonRedisSerializer());
    37.         redisTemplate.setHashValueSerializer(new GenericJackson2JsonRedisSerializer());
    38. //        redisTemplate.afterPropertiesSet();
    39.  
    40.         redisTemplate.setConnectionFactory(connectionFactory);
    41.         return redisTemplate;
    42.     }
    43.  
    44.     @Bean
    45.     public RedisCacheManager redis(RedisConnectionFactory connectionFactory){
    46.         RedisCacheConfiguration defaultCacheConfig = RedisCacheConfiguration.defaultCacheConfig();
    47.         // 设置缓存管理器管理的缓存的默认过期时间
    48.         defaultCacheConfig = defaultCacheConfig.entryTtl(Duration.ofSeconds(defaultExpireTime))
    49.                 // 设置 key为string序列化
    50.                 .serializeKeysWith(RedisSerializationContext.SerializationPair.fromSerializer(new StringRedisSerializer()))
    51.                 // 设置value为json序列化
    52.                 .serializeValuesWith(RedisSerializationContext.SerializationPair.fromSerializer(new GenericJackson2JsonRedisSerializer()))
    53.                 // 不缓存空值
    54.                 .disableCachingNullValues();
    55.  
    56.         Set<String> cacheNames = new HashSet<>();
    57.         cacheNames.add(userCacheName);
    58.  
    59.         // 对每个缓存空间应用不同的配置
    60.         Map<String, RedisCacheConfiguration> configMap = new HashMap<>();
    61.         configMap.put(userCacheName, defaultCacheConfig.entryTtl(Duration.ofSeconds(userCacheExpireTime)));
    62.  
    63.         RedisCacheManager cacheManager = RedisCacheManager.builder(connectionFactory)
    64.                 .cacheDefaults(defaultCacheConfig)
    65.                 .initialCacheNames(cacheNames)
    66.                 .withInitialCacheConfigurations(configMap)
    67.                 .build();
    68.  
    69.         return cacheManager;
    70.     }
    71. }

    测试注解式开发，修改代码如下

    ClazzBiz.java

    1. package com.dengxiyan.springboot04.biz;
    2.  
    3. import com.dengxiyan.springboot04.entity.Clazz;
    4. import com.dengxiyan.springboot04.util.PageBean;
    5.  
    6. import java.util.List;
    7. import java.util.Map;
    8.  
    9. public interface ClazzBiz {
    10.     int deleteByPrimaryKey(Integer cid);
    11.  
    12.     int insert(Clazz record);
    13.  
    14.     int insertSelective(Clazz record);
    15.  
    16.     Clazz selectByPrimaryKey(Integer cid);
    17.  
    18.     int updateByPrimaryKeySelective(Clazz record);
    19.  
    20.     int updateByPrimaryKey(Clazz record);
    21.  
    22.     @Cacheable(value = "redis-cache-clzs-",key = "'clzid:'+#clazz.cid")
    23.     List<Clazz> listPager(Clazz clazz, PageBean pageBean);
    24.  
    25.     List<Map> listMapPager(Clazz clazz, PageBean pageBean);
    26. }

     

  • 相关阅读:
    k8s资源对象(一)
    13、Callable介绍（Thread如何启动Callable）
    Hive（12）：Hive的函数之自定义函数
    实用技能 | 推荐6款论文一键AI改写修改网站
    【日拱一卒行而不辍20220920】自制操作系统
    扬帆牧哲—跨境电商商标注册要注意的地方
    【爬虫】charles手机抓包环境设置（设置系统证书）
    代码随想录算法训练营day52||674. 最长连续递增序列||718. 最长重复子数组||1143.最长公共子序列
    CSS——图标字体
    puppeteer在mac和linux上表现不一致的问题记录
  • 原文地址：https://blog.csdn.net/weixin_66202611/article/details/127674257