spring boot 数据访问1 JDBC使用druid数据源

﹏ヽ暗。殇╰゛Y 2022-02-17 15:18 213阅读 0赞

** 1、导入mysql**

<dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>

**2、使用jdbc**

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>

** 3、配置数据源**

spring:
       datasource:
          username: root
          password: 123456
          url: jdbc:mysql://192.168.1.16:3306/jdbc
          driver-class-name: com.mysql.jdbc.Driver

**4、通过jdbcTemplate查询**

@Controller
    public class HelloController {
    
        @Autowired
        JdbcTemplate jdbcTemplate;
    
        @ResponseBody
        @RequestMapping("/select")
        public String selectAll(){
            List<Map<String, Object>> demo = jdbcTemplate.queryForList("select * from test001");
            return new Gson().toJson(demo);
        }
    }

SpringBoot默认可以支持（在DataSourceConfiguration调用）

org.apache.tomcat.jdbc.pool.DataSource、HikariDataSource、BasicDataSource、自定义

### **整合druid数据源** ###

[https://help.aliyun.com/document\_detail/72987.html?spm=5176.10695662.1996646101.searchclickresult.152b3880SgHVEr][https_help.aliyun.com_document_detail_72987.html_spm_5176.10695662.1996646101.searchclickresult.152b3880SgHVEr]

DRUID是阿里巴巴开源平台上一个数据库连接池实现,它提供了非常优秀的监控功能

<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>

配置信息

spring:
       datasource:
          username: root
          password: 123456
          url: jdbc:mysql://192.168.1.16:3306/jdbc
          driver-class-name: com.mysql.jdbc.Driver
          type : com.alibaba.druid.pool.DruidDataSource
    
          platform: mysql
          # 下面为连接池的补充设置，应用到上面所有数据源中
          # 初始化大小，最小，最大
          initialSize: 1
          minIdle: 3
          maxActive: 20
          # 配置获取连接等待超时的时间
          maxWait: 60000
          # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
          timeBetweenEvictionRunsMillis: 60000
          # 配置一个连接在池中最小生存的时间，单位是毫秒
          minEvictableIdleTimeMillis: 30000
          validationQuery: select 'x'
          testWhileIdle: true
          testOnBorrow: false
          testOnReturn: false
          # 打开PSCache，并且指定每个连接上PSCache的大小
          poolPreparedStatements: true
          maxPoolPreparedStatementPerConnectionSize: 20
          # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
          filters: stat,wall,slf4j
          # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
          connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

@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;
        }
    
    }

登陆：localhost:8080/druid   输入你的账号：admin 密码：123456 进入监控界面

[https_help.aliyun.com_document_detail_72987.html_spm_5176.10695662.1996646101.searchclickresult.152b3880SgHVEr]: https://help.aliyun.com/document_detail/72987.html?spm=5176.10695662.1996646101.searchclickresult.152b3880SgHVEr