<dependency><groupId> org.springframework.boot </groupId><artifactId> spring‐boot‐starter‐jdbc </artifactId></dependency><dependency><groupId> mysql </groupId><artifactId> mysql‐connector‐java </artifactId><scope> runtime </scope></dependency>
spring :datasource :username : rootpassword : 123456url : jdbc : mysql : //192.168.15.22 : 3306/jdbc //jdbc指的是访问的是一个名字叫jdbc的数据库driver‐class‐name : com.mysql.jdbc.Driver
效果:
默认是用
org.apache.tomcat.jdbc.pool.DataSource
作为数据源;
数据源的相关配置都在
DataSourceProperties
里面;
自动配置原理:
org.springframework.boot.autoconfifigure.jdbc
:
1
、参考
DataSourceConfifiguration
,根据配置创建数据源,默认使用
Tomcat
连接池;可以使用
spring.datasource.type
指定自定义的数据源类型;
2
、
SpringBoot
默认可以支持;
org.apache.tomcat.jdbc.pool.DataSource 、 HikariDataSource 、 BasicDataSource 、
3、自定义数据源类型
/**
* Generic DataSource configuration.
*/
@ConditionalOnMissingBean(DataSource.class)
@ConditionalOnProperty(name = "spring.datasource.type")
static class Generic {
@Bean
public DataSource dataSource(DataSourceProperties properties) {
//使用DataSourceBuilder创建数据源,利用反射创建响应type的数据源,并且绑定相关属性
return properties.initializeDataSourceBuilder().build();
}
}
4
、
DataSourceInitializer启动springboot会自动执行sql文件
springboot2.0之后需要配置
initialization-mode: always
作用:
1
)、
runSchemaScripts();
运行建表语句;
2
)、
runDataScripts();
运行插入数据的
sql
语句;
默认只需要将文件命名为:
schema‐*.sql这个sql文件用于建表 、 data‐*.sql这个sql文件用于数据的添加默认规则: schema.sql , schema‐all.sql ;可以使用schema :‐ classpath : department.sql指定位置
5
、操作数据库:自动配置了
JdbcTemplate
操作数据库
@Controller
public class HelloController {
@Autowired
JdbcTemplate jdbcTemplate;
@ResponseBody
@GetMapping("/query")
public Map<String,Object> map(){
List<Map<String,Object>> list=jdbcTemplate.queryForList("select * from departments");
return list.get(0);
}
}
整合Druid数据源
引入druid数据源
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.8</version>
</dependency>
配置属性(配置阶段没有起作用)
spring: datasource: username: root password: 123456 url: jdbc:mysql://192.168.93.134:3306/myemployees driver-class-name: com.mysql.cj.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource # initialization-mode: always # schema: # - classpath:department.sql # type: com.alibaba.druid.pool.DruidDataSource 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,去掉后监控界面sql无法统计,'wall'用于防火墙 filters: stat,wall,log4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
因为监控使用了log4j所以应该导入log4j
dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency>
写配置类引入配置文件
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druid(){
return new DruidDataSource();
}
}
配置durid数据源后台管理servlet,通过此servlet可以访问durid的后台管理程序
@Configuration
public 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<String,String> initParams = new HashMap<>();
initParams.put("loginUsername","admin");
initParams.put("loginPassword","123456");
initParams.put("allow","");//默认就是允许所有访问
initParams.put("deny","192.168.15.21");//不允许这个地址访问
bean.setInitParameters(initParams);
return bean;
}
}
配置一个web监控的filter
@Configuration
public 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<String,String> initParams = new HashMap<>();
initParams.put("loginUsername","admin");
initParams.put("loginPassword","123456");
initParams.put("allow","");//默认就是允许所有访问
initParams.put("deny","192.168.15.21");
bean.setInitParameters(initParams);
return bean;
}
//2、配置一个web监控的filter
@Bean
public FilterRegistrationBean webStatFilter(){
FilterRegistrationBean bean = new FilterRegistrationBean();
bean.setFilter(new WebStatFilter());
Map<String,String> initParams = new HashMap<>();
initParams.put("exclusions","*.js,*.css,/druid/*");
bean.setInitParameters(initParams);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
}