SpringBoot中Mybatis + Druid 數(shù)據(jù)訪問(wèn)的詳細(xì)過(guò)程

第SpringBoot中Mybatis+Druid數(shù)據(jù)訪問(wèn)的詳細(xì)過(guò)程查看項(xiàng)目依賴，導(dǎo)入成功！

切換數(shù)據(jù)源；

之前已經(jīng)說(shuō)過(guò)SpringBoot2.0以上默認(rèn)使用com.zaxxer.hikari.HikariDataSource數(shù)據(jù)源，可以通過(guò)spring.datasource.type指定數(shù)據(jù)源。

type:com.alibaba.druid.pool.DruidDataSource

設(shè)置數(shù)據(jù)源連接初始化大小、最大連接數(shù)、等待時(shí)間、最小連接數(shù)等設(shè)置項(xiàng)；

#SpringBoot默認(rèn)是不注入這些屬性值的，需要自己綁定

#druid數(shù)據(jù)源專有配置

initialSize:5

minIdle:5

maxActive:20

maxWait:60000

timeBetweenEvictionRunsMillis:60000

minEvictableIdleTimeMillis:300000

validationQuery:SELECT1FROMDUAL

testWhileIdle:true

testOnBorrow:false

testOnReturn:false

poolPreparedStatements:true

#配置監(jiān)控統(tǒng)計(jì)攔截的filters，stat:監(jiān)控統(tǒng)計(jì)、log4j：日志記錄、wall：防御sql注入

#如果允許時(shí)報(bào)錯(cuò)java.lang.ClassNotFoundException:org.apache.log4j.Priority

#則導(dǎo)入log4j依賴即可，Maven地址：/artifact/log4j/log4j

filters:stat,wall,log4j

maxPoolPreparedStatementPerConnectionSize:20

useGlobalDataSourceStat:true

connectionProperties:druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

log4****日志依賴

!--/artifact/log4j/log4j--

dependency

groupIdlog4j/groupId

artifactIdlog4j/artifactId

version1.2.17/version

/dependency

測(cè)試

publicclassSpringbootDemoDataApplicationTests{

//注入數(shù)據(jù)源

@Autowired

DataSourcedataSource;

@Test

publicvoidcontextLoads()throwsSQLException{

//看一下默認(rèn)數(shù)據(jù)源

System.out.println(dataSource.getClass());

//獲得連接

Connectionconnection=dataSource.getConnection();

System.out.println(connection);

DruidDataSourcedruidDataSource=(DruidDataSource)dataSource;

System.out.println("druidDataSource數(shù)據(jù)源最大連接數(shù)："+druidDataSource.getMaxActive());

System.out.println("druidDataSource數(shù)據(jù)源初始化連接數(shù)："+druidDataSource.getInitialSize());

//關(guān)閉連接

connection.close();

測(cè)試成功！

1、配置Druid數(shù)據(jù)源監(jiān)控

Druid數(shù)據(jù)源具有監(jiān)控的功能，并提供了一個(gè)web界面方便用戶查看，類似安裝路由器時(shí)，它也提供了一個(gè)默認(rèn)的web頁(yè)面。

所以第一步需要設(shè)置Druid的后臺(tái)管理頁(yè)面，比如登錄賬號(hào)、密碼等配置后臺(tái)管理；

packagecom.kk.config;

importcom.alibaba.druid.pool.DruidDataSource;

importcom.alibaba.druid.support.http.StatViewServlet;

importcom.alibaba.druid.support.http.WebStatFilter;

importperties.ConfigurationProperties;

importorg.springframework.boot.web.servlet.FilterRegistrationBean;

importorg.springframework.boot.web.servlet.ServletRegistrationBean;

importorg.springframework.context.annotation.Bean;

importorg.springframework.context.annotation.Configuration;

importjavax.servlet.Filter;

importjavax.sql.DataSource;

importjava.util.HashMap;

importjava.util.Map;

@Configuration

publicclassDruidConfig{

@ConfigurationProperties(prefix="spring.datasource")//關(guān)聯(lián)application.yaml中的spring.datasource

@Bean

publicDataSourcedruidDataSource(){

returnnewDruidDataSource();

//配置Druid監(jiān)控管理后臺(tái)的Servlet；

//內(nèi)置Servler容器時(shí)沒(méi)有web.xml文件，所以使用SpringBoot的注冊(cè)Servlet方式

@Bean

publicServletRegistrationBeanstatViewServlet(){

ServletRegistrationBeanbean=newServletRegistrationBean(newStatViewServlet(),"/druid/*");

MapString,StringinitParams=newHashMap();

initParams.put("loginUsername","admin");//后臺(tái)管理界面的登錄賬號(hào)

initParams.put("loginPassword","123456");//后臺(tái)管理界面的登錄密碼

//后臺(tái)允許誰(shuí)可以訪問(wèn)

//initParams.put("allow","localhost")：表示只有本機(jī)可以訪問(wèn)

//initParams.put("allow","")：為空或者為null時(shí)，表示允許所有訪問(wèn)

initParams.put("allow","");

//deny：Druid后臺(tái)拒絕誰(shuí)訪問(wèn)

//initParams.put("kuangshen","0");表示禁止此ip訪問(wèn)

//設(shè)置初