配置Druid数据源
1.导入maven依赖
<!-- /artifact/com.alibaba/druid --><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.1.10</version></dependency>
2.更改数据源:applicationContext.xml
<!--2. 配置数据源 c3p0 --><!-- 数据库基本信息配置 --><property name = "url" value = "${url}"/> <property name = "username" value = "${username}"/> <property name = "password" value = "${password}"/> <property name = "driverClassName" value = "${driverClassName}"/> <property name = "filters" value = "${filters}"/> <!-- 最大并发连接数 --><property name = "maxActive" value = "${maxActive}"/><!-- 初始化连接数量 -->< property name = "initialSize" value = "${initialSize}"/><!-- 配置获取连接等待超时的时间 --><property name = "maxWait" value = "${maxWait}"/><!-- 最小空闲连接数 --<property name = "minIdle" value = "${minIdle}"/> <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->< property name = "timeBetweenEvictionRunsMillis" value ="${timeBetweenEvictionRunsMillis}"/><!-- 配置一个连接在池中最小生存的时间，单位是毫秒 --><property name = "minEvictableIdleTimeMillis" value ="${minEvictableIdleTimeMillis}"/> <property name = "validationQuery" value = "${validationQuery}"/> <property name = "testWhileIdle" value = "${testWhileIdle}"/> <property name = "testOnBorrow" value = "${testOnBorrow}"/> <property name = "testOnReturn" value = "${testOnReturn}"/> <property name = "maxOpenPreparedStatements" value ="${maxOpenPreparedStatements}" /><!-- 打开 removeAbandoned 功能 --><property name = "removeAbandoned" value = "${removeAbandoned}"/><!-- 1800 秒，也就是 30 分钟 --><property name = "removeAbandonedTimeout" value ="${removeAbandonedTimeout}" /><!-- 关闭 abanded 连接时输出错误日志 --> <property name = "logAbandoned" value = "${logAbandoned}"/></ bean >
3.配置db.properties
url:jdbc:mysql:///myproject(你的项目的地址)driverClassName: com.MySQL.jdbc.Driverusername: root(项目数据库名称)password: root(项目数据库密码)filters: statmaxActive: 20initialSize: 1maxWait: 60000minIdle: 10maxIdle: 15timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 'x'testWhileIdle: truetestOnBorrow: falsetestOnReturn: falsemaxOpenPreparedStatements: 20removeAbandoned: trueremoveAbandonedTimeout: 1800logAbandoned: true
4.配置web.xml
<filter> <filter-name>DruidWebStatFilter</filter-name> <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class> <init-param> <param-name>exclusions</param-name> <param-value> *. js ,*. gif ,*. jpg ,*. png ,*. css ,*. ico ,/ druid /* </param-value> </init-param> </filter> <filter-mapping> <filter-name>DruidWebStatFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <servlet> <servlet-name>DruidStatView</servlet-name> <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class> </servlet><servlet-mapping> <servlet-name>DruidStatView</servlet-name> <url-pattern>/druid/*</url-pattern> </servlet-mapping>
