springboot 集成 spring date 加 druid

第一步引包

  <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- springdata jpa依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <!-- druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.25</version>
        </dependency>

第二步配置config类 配置druid页面

@Configuration  //标识该类被纳入spring容器中实例化并管理
public class DruidConfig {
    @Bean
    public ServletRegistrationBean statViewServlet() {
        // 创建servlet注册实体
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),
                "/druid/*");
        // 设置ip白名单
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // 设置ip黑名单,如果allow与deny共同存在时,deny优先于allow
        servletRegistrationBean.addInitParameter("deny", "192.168.0.1");
        // 设置控制台管理用户
        servletRegistrationBean.addInitParameter("admin", "admin");
        servletRegistrationBean.addInitParameter("user", "123456");
        // 是否可以重置数据
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

    @Bean
    public FilterRegistrationBean statFilter() {
        // 创建过滤器
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        // 设置过滤器过滤路径
        filterRegistrationBean.addUrlPatterns("/*");
        // 忽略过滤的形式
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
        return filterRegistrationBean;
    }
}

第三步 配置文件

spring:
  # 数据源配置
    datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://192.168.106.17:3306/springboot_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false
      username: root
      password: cheyipai

      # Druid连接池配置
      type: com.alibaba.druid.pool.DruidDataSource
      # 初始化
      initialSize: 3
      # 最大
      maxActive: 20
      # 最小
      minIdle: 3
      # 最大连接等待超时时间
      maxWait: 60000
      # 打开PSCache,并且指定每个连接PSCache的大小
      poolPreparedStatements: true
      maxPoolPreparedStatementPerConnectionSize: 20
      validationQuery: select 'x'
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
      timeBetweenEvictionRunsMillis: 60000
      # 配置一个连接在池中最小生存的时间,单位是毫秒
      minEvictableIdleTimeMillis: 300000
      # 配置监控统计拦截的filters,去掉后监控界面sql将无法统计,'wall'用于防火墙
      filters: stat, wall, log4j
    # spring data jpa配置
    jpa:
      hibernate:
        # 实体类有更新时，数据库表更新
        ddl-auto: update
      show-sql: true
      format_sql: true
      database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

运行加可以访问 http://localhost:8080/druid

测试spring date

书写关系类

@Entity
@Table(name = "student")
public class StudentDao {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;
    private String name;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

书写 配置repository

public interface StudentRepository extends PagingAndSortingRepository<StudentDao, Integer> {

    StudentDao getById(Integer id);

}

测试springdate

 @Autowired
    private StudentRepository studentRepository;

    @ApiOperation("测试springDateJpa添加")
    @ResponseBody
    @GetMapping("/addJpa/{data}")
    public StudentDao addJpa(@PathVariable String data){
        logger.info("进入接口参数为："+data);
        StudentDao studentDao = new StudentDao();
        studentDao.setName(data);
        studentRepository.save(studentDao);
        return studentDao;
    }



    @ApiOperation("测试springDateJpa获取")
    @ResponseBody
    @GetMapping("/getJpa/{id}")
    public StudentDao getJpa(@PathVariable Integer id){
        logger.info("进入接口参数为："+id);
        StudentDao byId = studentRepository.getById(id);
        return byId;
    }

完事