springboot项目使用druid
appriapplication.properties一部分配置
配置类
@Configuration
//@Slf4j
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource dataSource() {
return new DruidDataSource();
}
@Bean
public ServletRegistrationBean statViewServlet() {
ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
Map<String, String> initMap = new HashMap<>();
initMap.put("loginUsername", "admin");
initMap.put("loginPassword", "123456");
initMap.put("allow", "");
//initMap.put("deny","");
//initMap.put("remoteAddress","");
bean.setInitParameters(initMap);
return bean;
}
@Bean
public FilterRegistrationBean webStatFilter() {
FilterRegistrationBean bean = new FilterRegistrationBean();
//bean.setFilter(new WebStatFilter());
bean.setFilter(new WebStatFilter());
Map<String, String> initParams = new HashMap<>();
initParams.put("exclusions", "*.js,*.css,/druid/*");
initParams.put("sessionStatEnable", "false");
bean.setInitParameters(initParams);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
//使用@value注入配置文件中信息
@Value("${spring.datasource.url}")
private String dbUrl;
@Value("${spring.datasource.username}")
private String username;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.driver-class-name}")
private String driverClassName;
@Value("${spring.datasource.filters}")
private String filters;
private static final Logger logger = LoggerFactory.getLogger(DruidConfig.class);
@Bean
public DataSource druidDataSource() throws Exception {
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(dbUrl);
datasource.setUsername(username);
datasource.setPassword(password);
datasource.setDriverClassName(driverClassName);
try {
datasource.setFilters(filters);
} catch (SQLException e) {
// log.error("druid configuration initialization filter:{}",e);
logger.error("druid configuration initialization filter:{}",e);
}
return datasource;
}
}
登录 ip:port/druid 查看监控信息