SpringBoot整合JDBC
程序员文章站
2022-03-26 19:27:34
使用默认数据源一、引入spring-boot-starter-data-jdbcorg.springframework.boot spring-boot-starter-data-jdbc 二、配置数据源application.ymlspring: #mysql数...
构建项目
使用默认数据源
一、引入spring-boot-starter-data-jdbc
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
二、配置数据源
application.yml
spring:
#mysql数据源配置
datasource:
# 强烈注意:Spring Boot 2.X 版本不再支持配置继承,多数据源的话每个数据源的所有配置都需要单独配置,否则配置不会生效
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8
username: edu
password: 123456
schema:
- classPath:nickname.sql
三、测试
package com.example.demo;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
@SpringBootTest
class DemoApplicationTests {
@Autowired
DataSource dataSource;
@Test
void contextLoads() throws SQLException {
System.out.println(dataSource.getClass());
Connection connection = dataSource.getConnection();
System.out.println(connection);
connection.close();
}
}
运行结果:
我用的SpringBoot版本是2.4.0,它默认的数据源是HikariDataSource
四、操作数据库
@Controller
public class HelloController {
@Autowired
JdbcTemplate jdbcTemplate;
@ResponseBody
@GetMapping("/query")
public Map<String,Object> map(){
List<Map<String,Object>> list = jdbcTemplate.queryForList("select * from person");
return list.get(0);
}
}
运行结果:
配置druid数据源
一、引入依赖
<!-- 阿里巴巴druid数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.18</version>
</dependency>
指定数据源类型
spring:
#mysql数据源配置
datasource:
# 强烈注意:Spring Boot 2.X 版本不再支持配置继承,多数据源的话每个数据源的所有配置都需要单独配置,否则配置不会生效
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8
username: edu
password: 123456
type: com.alibaba.druid.pool.DruidDataSource
initialSize: 5
maxActive: 20
# schema:
# - classpath:nickname.sql
写一个配置类,绑定配置参数
package com.example.demo.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druid(){
return new DruidDataSource();
}
}
Debug 看看有没有生效
配置Druid监控
package com.example.demo.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewFilter;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletListenerRegistrationBean;
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.Arrays;
import java.util.HashMap;
import java.util.Map;
/**
* @author *cruder
* @version 1.0
* @since 2020/12/10 19:46
*/
@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","admin");
initParams.put("allow","localhost");
initParams.put("deny","192.168.1.36");
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;
}
}
浏览器输入http://localhost:8080/druid
本文地址:https://blog.csdn.net/AnalogElectronic/article/details/110956721
推荐阅读
-
Win10 19H1新版18290更新大全:日历整合To-Do
-
JSP 开发SSH整合异常解决办法
-
java(jsp)整合discuz同步登录功能详解
-
springboot介绍项目(springboot自动配置原理)
-
详解mall整合SpringBoot+MyBatis搭建基本骨架
-
Springboot之自定义全局异常处理的实现
-
品Spring:SpringBoot轻松取胜bean定义注册的“第一阶段”
-
SpringBoot整合Redis、ApachSolr和SpringSession的示例
-
springboot 使用Spring Boot Actuator监控应用小结
-
Sprigmvc项目转为springboot的方法