項(xiàng)目技能培訓(xùn)數(shù)據(jù)庫連接池druid使用說明

Druid性能強(qiáng)大DBCPC3P0DBCPDruidStatFilterSQLWeb：除了數(shù)據(jù)庫還提供了Web功能易導(dǎo)致安全問題。DruidDruiver和DruidDataSource都支持SQL執(zhí)行日志：Druid提供了不同的LogFilter，能夠支持Common-Logging、Log4j和JdkLog，你可以按需要選擇相應(yīng)的LogFilter，你擴(kuò)展JDBC：如果你要對JDBC層有編程的需求，可以通過Druid提供的FilterJDBCDruid"DataSource-"+1.0.5版本中是不起作用的，強(qiáng)name會出錯。url，不同數(shù)據(jù)庫不一樣。例如：mysqljdbc:mysql://10.20.153.104:3306/druid2oracle: ConfigFilter。詳細(xì)看這里：url自動識druidurl自動dbTypedriverClassName0initgetConnection時(shí)88maxWaituseUnfairLocktruepreparedStatementPSCache。PSCache對支持游標(biāo)的數(shù)據(jù)庫性能提升巨大，比如說oraclemysqlPSCache00時(shí)，poolPreparedStatementstrue。在DruidOraclePSCache占用內(nèi)存過多validationQuerynull，testOnBorrow、testOnReturn、testWhileIdle都不會其作用。validationQuery檢測連接是否有效，validationQuery檢測連接是否有效，validationQuery1)Destroy線程會檢測連接的間隔時(shí)間testWhileIdletestWhileIdle屬性Destory線程中如果檢測到當(dāng)前連接的最后活躍時(shí)間和dbType自常用的插件有：統(tǒng)計(jì)用的filter:stat日志用的filter:log4jsql配置了filters和Filters，是組合關(guān)系，并非替removeAbandonedTimeout的連接MySQL<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"value="${jdbc_url}"<propertyname="username"value="${jdbc_user}"<propertyname="password"value="${jdbc_password}"初始化連接池大小,<propertyname="initialSize"value="50"連接池最大使用連接數(shù),需根據(jù)系統(tǒng)并發(fā)需求定義<propertyname="maxActive"value="200"<!---<propertyname="minIdle"value="50"獲取連接最大等待時(shí)間,單位毫秒<propertyname="maxWait"value="5000"<propertyname="validationQuery"value="SELECT'x'"-<propertyname="testOnBorrow"value="false"<propertyname="testOnReturn"value="false"true--><propertyname="testWhileIdle"value="true"<!--1)DestroyminIdle時(shí)，釋放空閑minEvictableIdleTimeMillis連接；2)申請連接時(shí)對空閑時(shí)間大于本值的連接<propertyname="timeBetweenEvictionRunsMillis"value="60000"<propertyname="minEvictableIdleTimeMillis"value="300000"<propertyname="poolPreparedStatements"value="false"<propertyname="maxPoolPreparedStatementPerConnectionSize"value="-removeAbandoned2<propertyname="removeAbandoned"value="true"180030<propertyname="removeAbandonedTimeout"value="1800"abanded<propertyname="logAbandoned"value="true"<propertyname="filters"value="stat"DruidFilterChain1、數(shù)據(jù)2、的配置文MySQLurl中指定編碼， DruidStatFilterSQL性能，MergeStatFilterStatFilterSQLSQLSQLOracleMySQL這里主要說明數(shù)據(jù)庫加密的方法，默認(rèn)采用RSA進(jìn)行加javajava-cpdruid-0.2.23.jarcom.alibaba.druid.filter.config.ConfigTools輸入你的數(shù)據(jù)庫，輸出的是加密后的結(jié)果<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><property<propertyname="url"value="${jdbc_url}"<propertyname="username"value="${jdbc_user}" qNyvpxJ2nceDFBbzVw=="/><!--使用配置過濾器--<propertyname="filters"value="config"<!—開啟功能，當(dāng)傳到數(shù)據(jù)庫前進(jìn)行--<propertyname="connectionProperties"value="config.decrypt=true"項(xiàng)目使用的編碼類型不一致。MySQLurl中指定編碼，不需要使用該過濾器，例如：<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><!--使用編過濾器--<propertyname="filters"value="encoding"<property<!--參數(shù)配置“Encoding”和“serverEncoding”，分別指定數(shù)據(jù)庫客EncodingFilter從這兩個(gè)參數(shù)獲取編碼--><value>Encoding=UTF-8;serverEncoding=ISO-8859-支持log4jslf4jcommonLogging三種，輸出的日志名稱druid.sql.DataSource<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><!--使用編和log4j日志過濾器--<propertyname="filters"<property<!--參數(shù)配置“ 端和服務(wù)器端的字符編碼EncodingFilter從這兩個(gè)參數(shù)獲取編碼--><value>Encoding=UTF-8;serverEncoding=ISO-8859-<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><!--使用編和log4j日志過濾器--<propertyname="filters"value="log4j,stat"<propertydruid.stat.logSlowSqlSQLfalse；druid.stat.slowSqlMillisSQL3000毫秒；druid.stat.mergeSqlSQLfalse；-->sql執(zhí)行時(shí)，sqlselectselect*fromtwhereid=1select*fromtwhereid=select*fromtwhereid=3sql，這不是我們希望要的效果。StatFilter提供合并的3SQLSQLselectselect*fromtwhereid=StatFiltermergeSql<bean<beanid="stat-filter"<propertyname="mergeSql"value="true"<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close">...<property <refbean="stat-filter"StatFilter<bean<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close">...<propertyname="filters"value="mergeStat"SQL對被認(rèn)為是的SQL進(jìn)行LOG.error輸對被認(rèn)為是的SQL拋出<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><!--使用編和log4j日志過濾器--<propertyname="filters"value="wall"<property詳細(xì)配置可 Filter<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"value="${jdbc_url}"<propertyname="username"value="${jdbc_user}"<propertyname="password"value="123456"<propertyname="filters"value="log4j,stat"<property<propertyname="filters"value="stat,encoding"filter中value <beanid="stat-filter"<beanid="stat-filter"<propertyname="mergeSql"value="true"<propertyname="slowSqlMillis"value="3000"<propertyname="logSlowSql"value="true"<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"value="${jdbc_url}"<propertyname="username"value="${jdbc_user}"<property<propertyname="password"value="123456"<property <refbean="stat-filter"SpringMethodInterceptorAOPSpringAOP檔：<bean<beanid="druid-stat-<beanid="druid-<!--所有ABCInterface的派生類 --<propertyname="targetBeanType"value="xxxx.ABCInterface"<property<beanid="druid-stat-interceptor"<beanid="druid-stat-interceptor"<beanid="druid-stat-pointcut"<property <aop:advisora