1、创建druid.druid.properties填写连接属性
jdbc.driverClass=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mp?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
jdbc.username=root
jdbc.password=123456
2、更改applicationContext.xml的数据源,使用druid数据源
<context:property-placeholder location="classpath:db-conf/druid.properties"></context:property-placeholder>
<!--Spring用来控制业务逻辑。数据源、事务控制、aop-->
<!--使用druid数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init">
<!--注入连接属性-->
<property name="driverClassName" value="${jdbc.driverClass}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<!--初始化连接池大小-->
<property name="initialSize" value="5"></property>
<!--设置最大连接数-->
<property name="maxActive" value="10"></property>
<!--设置等待时间-->
<property name="maxWait" value="5000"/>
<!--配置数据源监控的filter-->
<property name="filters" value="stat"></property>
</bean>
3、修改web.xml添加下列配置
<!-- druid的监控配置 -->
<servlet>
<servlet-name>StatViewServlet</servlet-name>
<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
<!--登陆名-->
<init-param>
<param-name>loginUsername</param-name>
<param-value>root</param-value>
</init-param>
<!-- 登录密码-->
<init-param>
<param-name>loginPassword</param-name>
<param-value>root</param-value>
</init-param>
<!--白名单-->
<init-param>
<param-name>allow</param-name>
<param-value></param-value>
</init-param>
<!--黑名单-->
<init-param>
<param-name>deny</param-name>
<param-value></param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>StatViewServlet</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>
<filter>
<filter-name>WebStatFilter</filter-name>
<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
<!--过滤的样式-->
<init-param>
<param-name>exclusions</param-name>
<param-value>*.js,*.gif,*.css,*.ico,*.jpg,*.png,/druid/*</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>WebStatFilter</filter-name>
<servlet-name>StatViewServlet</servlet-name>
</filter-mapping>
<!--druid监控配置结束-->
4、测试是否成功
访问http://localhost:8080/druid/