javaweb项目加入druid

拼搏现实的明天。 2022-05-31 02:39 295阅读 0赞

在javaweb项目中使用阿里的druid

1.加入jar包

1).maven下加入dependency到pom文件里面.

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>${druid-version}</version>
        </dependency>

2).直接导入druid的jar包,eg: druid-1.0.18.jar.

2.数据源配置

将spring配置文件中数据源配置替换成监控需要的配置，以下是一个参考的连接池配置：

通常来说，只需要修改initialSize、minIdle、maxActive。如果用Oracle，则把poolPreparedStatements配置为true，mysql可以配置为false。分库分表较多的数据库，建议配置为false。

3.配置web.xml

加入以下代码

<servlet>
    		<servlet-name>DruidStatView</servlet-name>
    		<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
    		<init-param>
    			
    			<param-name>loginUsername</param-name>
    			<param-value>druid</param-value>
    		</init-param>
    		<init-param>
    			
    			<param-name>loginPassword</param-name>
    			<param-value>dream</param-value>
    		</init-param>
    	</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>

ok.登录localhost:port/druid/index.html