springboot-data学习（含Druid数据源）

springboot-data学习（含Druid数据源）

1.引入相关依赖

<dependency>
            <groupId>com.lmaye</groupId>
            <artifactId>spring-boot-starter-data-encryption</artifactId>
            <version>1.0.4-RELEASE</version>
        </dependency>

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

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>

2.自定义DruidConfig

package com.cai.config;

import com.alibaba.druid.pool.DruidDataSource;
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.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;
import java.util.HashMap;

/**
 * @BelongsProject:IntelliJ IDEA
 * @Package:com.cai.config
 * @Author:superman
 * @CreateTime:2021--01--16 15:55
 * @Description:
 */
@Configuration
public class DruidConfig {
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DruidDataSource druidDataSource(){
        return new DruidDataSource();
    }

    //后台监控,相当于web.xml
    //应为springboot内置了servlet容器，所以没有web.xml，替代方法：ServletRegistrationBean
    @Bean
    public ServletRegistrationBean statViewServlet(){
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");

        //后台需要有人登录，账号密码配置
        HashMap<String,String> initParameters = new HashMap<>();
        //增加配置
        initParameters.put("loginUsername","admin");//登录的key是固定的，loginUsername,loginPassword
        initParameters.put("loginPassword","123456");

        //允许谁可以访问
        initParameters.put("allows","localhost");

        //禁止谁能访问initParameters.put("caiji","192.168.11.123");

        bean.setInitParameters(initParameters);//设置初始化参数
        return bean;

    }


    //filter
    @Bean
    public FilterRegistrationBean webStatFilter(){
        FilterRegistrationBean bean = new FilterRegistrationBean();

        bean.setFilter(new WebStatFilter());

        //可以过滤哪些请求

        HashMap<String, String> initParameters = new HashMap<>();

        //这些东西不进行统计
        initParameters.put("exclusions","*.js,*.css,/druid/*");

        bean.setInitParameters(initParameters);

        return bean;
    }

}

3.编写jdbcController

package com.cai.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;
import java.util.Map;

/**
 * @BelongsProject:IntelliJ IDEA
 * @Package:com.cai.controller
 * @Author:superman
 * @CreateTime:2021--01--15 20:50
 * @Description:
 */
@RestController
public class JDBCController {

    @Autowired
    JdbcTemplate jdbcTemplate;

    //查询数据库的所有信息
    //没有实体类，数据库中的东西，怎么获取？Map
    @GetMapping("/userList")
    public List<Map<String,Object>> userList(){
        System.out.println("进来了");
        String sql="select * from user";
        List<Map<String, Object>> list_maps = jdbcTemplate.queryForList(sql);
        System.out.println("=============>"+list_maps);
        return list_maps;
    }

    @GetMapping("/addUser")
    public String addUser(){
        String sql="insert into mybatis.user (id,name,pwd) value(6,'e','456456')";
        jdbcTemplate.update(sql);
        return "update-ok";
    }

    @GetMapping("/updateUser/{id}")
    public String updateUser(@PathVariable("id")int id){
        String sql="update mybatis.user set name=?,pwd=? where id="+id;

        //封装
        Object[] objects=new Object[2];
        objects[0]= "小明";
        objects[1]= "789798";
        jdbcTemplate.update(sql,objects);
        return "updateUser-ok";
    }

    @GetMapping("/deleteUser/{id}")
    public String deleteUser(@PathVariable("id")int id){
        String sql="delete from mybatis.user where id=?";
        jdbcTemplate.update(sql,id);
        return "deleteUser-ok";
    }
}

4.对druid以及jdbc连接进行配置

spring:
  datasource:
    username: root
    password: 123456
    #高版本的数据库需要使用时区
    url: 'jdbc:mysql://localhost:3306/mybatis?&serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8'
    driver-class-name: com.mysql.cj.jdbc.Driver
    #配置druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

5.总结

druid是一个数据源，需要使用的话只需要完成配置即可。springdata的jdbctemplate的使用对于我而言是一种新的数据操作方式，不需要写mapper等文件，相对来说还是比较方便的。