DruidSpringBootStarter从配置到简单运行解决zone不匹配解决dataSource加载失败

DruidSpringBootStarter中文|EnglishDruidSpringBootStarter用于帮助你在SpringBoot项目中轻松集成Druid数据库连接池和监

Druid Spring Boot Starter

中文 | EnglishDruid Spring Boot Starter 用于帮助你在Spring Boot项目中轻松集成Druid数据库连接池和监控。

官方文档:Druid Spring Boot Starter

---

application.yml

spring: datasource:# 数据源基本配置 username: root password: 123456 url: jdbc:mysql://localhost:3306/estore?useUnicode=truedruid.stat.slowSqlMillis=500# 端口server: port: 8080 servlet: context-path: /szs

导入Druid数据源

@Configurationpublic class DruidConfig { @ConfigurationProperties(prefix = "spring.datasource") @Bean public DataSource druid(){ return new DruidDataSource(); } //配置Druid的监控 /**1.配置一个管理后台的Servlet*/ @Bean public ServletRegistrationBean statViewServlet(){ ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*"); Map initParams = new HashMap(10); initParams.put("loginUsername", "admin"); initParams.put("loginPassword", "123456"); //默认允许所有的进行访问 initParams.put("allow", ""); bean.setInitParameters(initParams); return bean; } /** 2.配置一个web监控的filter */ @Bean public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean bean = new FilterRegistrationBean(); bean.setFilter(new WebStatFilter()); Map initParams = new HashMap(6); initParams.put("exclusions","*.js,*.css,/druid/*"); bean.setInitParameters(initParams); bean.setUrlPatterns(Arrays.asList("/*")); return bean; }}

进行登录,如图,我配置了context-path: /szs; 进入后输入 " public ServletRegistrationBean statViewServlet()"中的loginUsername和loginPassword即可进入.