yml中
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://localhost:3306/car?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
initial-size: 7
#监控配置
stat-view-servlet:
enabled: true
login-username: root
login-password: 123546
url-pattern: /druid/*
检验是否配置成功
@SpringBootApplication
public class JdbcApplication implements ApplicationRunner {
@Autowired
private DataSource dataSource;
@Autowired
private JdbcTemplate jdbcTemplate;
public static void main(String[] args) {
SpringApplication.run(JdbcApplication.class, args);
}
@Override
public void run(ApplicationArguments args) throws Exception {
Connection connection = dataSource.getConnection();
System.out.println(connection);
}
}
结果显示 com.mysql.cj.jdbc.ConnectionImpl@9d7ccfe
OK正确了
可以登录监控页面