导入依赖
< dependency>
< groupId> org.springframework.boot</ groupId>
< artifactId> spring-boot-starter-jdbc</ artifactId>
< version> 2.4.0</ version>
</ dependency>
< dependency>
< groupId> com.alibaba</ groupId>
< artifactId> druid</ artifactId>
< version> 1.2.6</ version>
</ dependency>
< dependency>
< groupId> mysql</ groupId>
< artifactId> mysql-connector-java</ artifactId>
</ dependency>
yml文件参数配置
spring :
datasource :
password : 123456
username : root
driver-class-name : com.mysql.cj.jdbc.Driver
url : jdbc: mysql: //localhost: 3306/mybatis? serverTimezone=Asia/Shanghai&characterEncoding=utf-8&useSSL=false
type : com.alibaba.druid.pool.DruidDataSource
连接测试
@SpringBootTest
public class MainApplicationTests {
@Autowired
DataSource dataSource;
@Test
public void bootTest ( ) {
System . out. println ( dataSource. getClass ( ) ) ;
}
}
编写配置类 Config
package com. boot. config ;
import com. alibaba. druid. pool. DruidDataSource ;
import com. alibaba. druid. support. http. StatViewServlet ;
import org. springframework. boot. context. properties. ConfigurationProperties ;
import org. springframework. boot. web. servlet. ServletRegistrationBean ;
import org. springframework. context. annotation. Bean ;
import org. springframework. context. annotation. Configuration ;
import javax. sql. DataSource ;
import java. util. HashMap ;
@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties ( prefix = "spring.datasource" )
public DataSource druidDataSource ( ) {
return new DruidDataSource ( ) ;
}
@Bean
public ServletRegistrationBean statViewServlet ( ) {
ServletRegistrationBean < StatViewServlet > bean = new ServletRegistrationBean < > ( new StatViewServlet ( ) , "/druid/*" ) ;
HashMap < String , String > initParameters = new HashMap < > ( ) ;
initParameters. put ( "loginUsername" , "admine" ) ;
initParameters. put ( "loginUsername" , "123456" ) ;
initParameters. put ( "allow" , "localhost" ) ;
bean. setInitParameters ( initParameters) ;
return bean;
}
@Bean
public FilterRegistrationBean webStatFilter ( ) {
FilterRegistrationBean < Filter > bean = new FilterRegistrationBean < > ( ) ;
bean. setFilter ( new WebStatFilter ( ) ) ;
HashMap < String , String > initParameters = new HashMap < > ( ) ;
initParameters. put ( "exclusions" , "*.js,druid/*" ) ;
bean. setInitParameters ( initParameters) ;
return bean;
}
}
启动登录:http://localhost:8080/druid