Druid使用

最新推荐文章于 2024-08-08 20:57:24 发布

转世重生之我是Java虚拟机

最新推荐文章于 2024-08-08 20:57:24 发布

阅读量926

点赞数

分类专栏： Druid 文章标签： java

本文链接：https://blog.csdn.net/weixin_58862969/article/details/123544346

版权

Druid 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

首先创建一个springboot项目添加maven依赖

  <!--Druid启动器-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
        </dependency>
        <!--Druid-->
        <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.8</version>
        </dependency>

在yaml中配置数据源

spring:
datasource:
username: root
password: admin
#时区报错添加时区配置：serverTimezone=UTC
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#SpringBoot默认是不注入这些的，需要自己绑定
#druid数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
#配置监控统计拦截的filters，stat：监控统计、log4j：日志记录、wall：防御sql注入
#如果允许报错，java.lang.ClassNotFoundException: org.apache.Log4j.Properity
#则导入log4j 依赖就行
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

创建config包下的DruidConfig(自己随意起名字)

@Configuration

public class DruidConfig {
    //更改Druid配置
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druidDataSource(){
        return new DruidDataSource();

    }
    //后台监控功能 ==web.xml
    //springboot内置了servlet容器，所以没有web.xml，替换方法：ServletRegistrationBean
    @Bean
    public ServletRegistrationBean statViewServlet(){
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        //后台要有人登录
        HashMap<String, String> initParameters = new HashMap<>();
        //增加配置
        initParameters.put("loginUsername","root"); //登录key是固定的 loginUsername
        initParameters.put("loginPassword","admin"); //登录key是固定的 loginPassword
        //允许谁可以访问
        initParameters.put("allow","");  //v 空为所有人

        //禁止谁访问initParameters.put("bieren","192.168.11.123");

        bean.setInitParameters(initParameters);//设置初始化参数
        return bean;
    }

    //filter 过滤器
    @Bean
    public FilterRegistrationBean webStatFilter(){
        FilterRegistrationBean bean = new FilterRegistrationBean();
        bean.setFilter(new WebStatFilter());
        //可以过滤那么些东西
        HashMap<String, String> initParameters = new HashMap<>();

        bean.setInitParameters(initParameters);
        //这些不进行统计
        initParameters.put("exclusions","*.js,*.css,/druid/*");

        return bean;
    }

}

不要忘了添加@Configuration

随便编写几个请求

@RestController
public class JDBCController {
    @Autowired
    JdbcTemplate jdbcTemplate;
    //查询数据库所有信息显示在网页上
    @GetMapping("/userList")
    public List<Map<String,Object>> userList(){
        String sql="select * from user";
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
        return maps;

    }

网页进入druid监控页面