项目：加入druid连接池-简单粗暴

悠悠 2022-03-20 13:09 138阅读 0赞

1、首先maven引入jar

<dependency>  
    		    <groupId>mysql</groupId>  
    		    <artifactId>mysql-connector-java</artifactId>  
    		    <version>5.1.25</version>  
    		</dependency>  
    		<dependency>  
    		    <groupId>com.alibaba</groupId>  
    		    <artifactId>druid</artifactId>  
    		    <version>0.2.23</version>  
    		</dependency>

2、spring配置文件加入配置  
spring-mybatis.xml内如下：

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    		
    		<property name="driverClassName" value="${driverClassName}" />
    		<property name="url" value="${url}" />
    		<property name="username" value="${username}" />
    		<property name="password" value="${password}" />
    	</bean>

jdbc.properties内如下：

driverClassName=com.mysql.jdbc.Driver
    url=jdbc:mysql://127.0.0.1:3306/han
    username=root
    password=root

3、web.xml加入如下内容：（实际上就是配servlet）

<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>
    	<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>/public/*,*.js,*.css,/druid*,*.jsp,*.swf</param-value>
    		</init-param>
    		<init-param>
    			<param-name>principalSessionName</param-name>
    			<param-value>sessionInfo</param-value>
    		</init-param>
    		<init-param>
    			<param-name>profileEnable</param-name>
    			<param-value>true</param-value>
    		</init-param>
    	</filter>
    	<filter-mapping>
    		<filter-name>druidWebStatFilter</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>

4、访问  
[http://localhost:8080/mad-web/druid/index.html][http_localhost_8080_mad-web_druid_index.html]

5、效果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIwNzQxMTMz_size_16_color_FFFFFF_t_70]

[http_localhost_8080_mad-web_druid_index.html]: http://localhost:8080/mad-web/druid/index.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIwNzQxMTMz_size_16_color_FFFFFF_t_70]: /images/20220320/1660c606b61241e18ffdd9e4b4912f6c.png