springboot整合druid+mybatis

最新推荐文章于 2022-08-04 10:38:18 发布

戴夫爱吃胡萝卜

最新推荐文章于 2022-08-04 10:38:18 发布

阅读量246

点赞数

CC 4.0 BY-SA版权

分类专栏： Spring Boot

本文链接：https://blog.csdn.net/linbomm/article/details/113944996

Spring Boot 专栏收录该内容

12 篇文章

订阅专栏

本文档展示了如何在Spring Boot项目中集成MyBatis和Druid数据源，并配置Druid的监控功能。在pom.xml中引入了MyBatis和Druid的依赖，接着在yml配置文件中设置了数据源的相关参数，如URL、用户名、密码等。然后创建了DruidConfig配置类，定义了数据源和监控Servlet及Filter的配置。通过访问http://localhost:8080/druid/index.html可以查看Druid的监控页面。最后，可以通过sql命令`show full processlist`检查数据库状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、pom.xml

        <!-- MyBatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        
        <!-- druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.4</version>
        </dependency>

二、yml

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3307/mybatis?serverTimezone=Asia/Shanghai
    username: root
    password: 147250
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      db-type: mysql
      initial-size: 5
      min-idle: 5
      max-active: 200
      max-wait: 10000
      #test-while-idle: true
      #validation-query: SELECT 1 FROM DUAL
      test-on-borrow: false
      test-on-return: false
      # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
      time-between-eviction-runs-millis: 15000
      default-auto-commit: true
      # 配置一个连接在池中最小生存的时间，单位是毫秒
      min-evictable-idle-time-millis: 30000
      # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
      filters: stat,wall,slf4j
      #有多个数据源时，配置公用监控数据
      use-global-data-source-stat: true
mybatis:
  # 配置mapper
  mapper-locations: classpath:/com/lin/mybatis_test1/mapper/xml/*.xml
  # 配置实体类前缀
  type-aliases-package: com.lin.mybatis_test1.entity
  configuration:
    # 打印语句
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    # 自动转换驼峰
    map-underscore-to-camel-case: true

三、配置类

@Configuration

public class DruidConfig {

    @Bean
    public DataSource createDruidDataSource(){
        DataSource dataSource= DruidDataSourceBuilder.create().build();
        return dataSource;
    }

    @Bean
    public ServletRegistrationBean statViewServlet(){
        ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        Map<String,String> initParams = new HashMap<>();
        initParams.put("loginUsername","admin");
        initParams.put("loginPassword","123456");
        initParams.put("allow","");//默认就是允许所有访问
        initParams.put("deny","192.168.15.21");
        bean.setInitParameters(initParams);
        return bean;
    }

    //2、配置一个web监控的filter
    @Bean
    public FilterRegistrationBean webStatFilter(){
        FilterRegistrationBean bean = new FilterRegistrationBean();
        bean.setFilter(new WebStatFilter());
        Map<String,String> initParams = new HashMap<>();
        initParams.put("exclusions","*.js,*.css,/druid/*");
        bean.setInitParameters(initParams);
        bean.setUrlPatterns(Arrays.asList("/*"));
        return  bean;
    }
}