用springboot2.0执行sql脚本:
1.现将sql文件放在resources下的sql文件夹下
2.新建数据库mybatis
3.配置yml
spring: datasource: # 数据源基本配置 username: root password: 123 driver-class-name: com.mysql.cj.jdbc.driver url: jdbc:mysql://localhost:3306/mybatis?useunicode=true&usejdbccomplianttimezoneshift=true&uselegacydatetimecode=false&servertimezone=utc 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 schema: - classpath:sql/department.sql - classpath:sql/employee.sql initialization-mode: always
注意:
配置类:
package com.example.springbooy06datamybatis.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.arrays; import java.util.hashmap; import java.util.map; @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; } }
执行成功!:
到此这篇关于spring.datasource.schema配置详解的文章就介绍到这了,更多相关spring.datasource.schema配置内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持!