druid和log4j学习笔记

1.Druid

1.配置

1.applicationContext-dao.xml

 

!-- 数据源 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">     <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 开发环境数据最大链接数据设置为你够用就行了 --> <property name="maxActive" value="${jdbc.maxActive}" /> <property name="maxIdle" value="${jdbc.maxIdle}" />     <!-- 配置获取连接等待超时的时间 -->         <property name="maxWait" value="60000" />           <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->         <property name="timeBetweenEvictionRunsMillis" value="60000" />           <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->         <property name="minEvictableIdleTimeMillis" value="300000" />           <property name="validationQuery" value="SELECT 'x'" />         <property name="testWhileIdle" value="true" />         <property name="testOnBorrow" value="false" />         <property name="testOnReturn" value="false" />           <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->         <property name="poolPreparedStatements" value="true" />         <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />         <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计加入log4j是为了和log4f集成，如不需要可不加-->         <property name="filters" value="stat,log4j" /> </bean>

2.Web.xml

<!--druid配置-->     <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>/static/*,*.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>     <!--druid监控 -->     <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>

配置完成之后可以通过 localhost:端口/项目名/druid/index.html查看。

这是简单使用

2.动态切换数据源

第一种方法，先在spring文件中声明多个数据源，然后再运行中切换。

<!-- 数据源配置1 --> <beanid="testDataSource1"class="com.alibaba.druid.pool.DruidDataSource"init-       method="init"destroy-method="close">     <propertyname="driverClassName"value="${db.driver}"/>     <propertyname="url"value="${unity.db.jdbc.url}"/>     <propertyname="username"value="${db.login.name}"></property>     <propertyname="password"value="${db.login.password}"/>     <propertyname="filters"  value="${db.filters}"></property>     <propertyname="maxActive"value="${db.pool.maxActive}"></property>     <propertyname="initialSize"value="${db.pool.initialSize}"></property>     <propertyname="minIdle"value="${db.pool.minIdle}"></property>     <propertyname="maxWait"value="${db.maxWait}"></property>     <propertyname="timeBetweenEvictionRunsMillis"               value="${db.timeBetweenEvictionRunsMillis}"></property>     <propertyname="minEvictableIdleTimeMillis"               value="${db.minEvictableIdleTimeMillis}"></property>     <propertyname="validationQuery"value="${db.validationQuery}"></property>     <propertyname="testWhileIdle"value="${db.testWhileIdle}"></property>     <propertyname="testOnBorrow"value="${db.testOnBorrow}"></property>     <propertyname="testOnReturn"value="${db.testOnReturn}"></property>     <propertyname="poolPreparedStatements"               value="${db.poolPreparedStatements}"></property>     <propertyname="maxOpenPreparedStatements"               value="${db.maxOpenPreparedStatements}"></property>     <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计加入log4j是为了和log4f集成，如不需要可不加-->         <property name="filters" value="stat,log4j" /> </bean> <!-- 数据源配置2--> <beanid="testDataSource2"class="com.alibaba.druid.pool.DruidDataSource"init-       method="init"destroy-method="close">     <propertyname="driverClassName"value="${db.driver}"/>     <propertyname="url"value="${unity.db.jdbc.url2}"/>     <propertyname="username"value="${db.login.name}"></property>     <propertyname="password"value="${db.login.password}"/>     <propertyname="filters"  value="${db.filters}"></property>     <propertyname="maxActive"value="${db.pool.maxActive}"></property>     <propertyname="initialSize"value="${db.pool.initialSize}"></property>     <propertyname="minIdle"value="${db.pool.minIdle}"></property>     <propertyname="maxWait"value="${db.maxWait}"></property>     <propertyname="timeBetweenEvictionRunsMillis"               value="${db.timeBetweenEvictionRunsMillis}"></property>     <propertyname="minEvictableIdleTimeMillis"               value="${db.minEvictableIdleTimeMillis}"></property>     <propertyname="validationQuery"value="${db.validationQuery}"></property>     <propertyname="testWhileIdle"value="${db.testWhileIdle}"></property>     <propertyname="testOnBorrow"value="${db.testOnBorrow}"></property>     <propertyname="testOnReturn"value="${db.testOnReturn}"></property>     <propertyname="poolPreparedStatements"               value="${db.poolPreparedStatements}"></property>     <propertyname="maxOpenPreparedStatements"               value="${db.maxOpenPreparedStatements}"></property>      <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计加入log4j是为了和log4f集成，如不需要可不加-->         <property name="filters" value="stat,log4j" /> </bean>  <!-- 编写spring 配置文件的配置多数源映射关系 -->     <beanclass="com.sino.access.database.DynamicDataSource"id="dataSource">         <propertyname="targetDataSources">             <mapkey-type="java.lang.String">                 <entryvalue-ref="testDataSource1"key="testDataSource1"></entry>         <entryvalue-ref="testDataSource2"key="testDataSource2"></entry>     </map> </property> <propertyname="defaultTargetDataSource"ref="testDataSource1"> </property>     </bean>

注意这个testDataSource1和testDataSource2，他就是我们数据源的标识，在AbstractRoutingDataSource路由determineCurrentLookupKey()这个方法中返回哪个，就是用其对应的数据源。如返回testDataSource1就是用testDataSource1数据源。

然后定义一个类继承AbstractRoutingDataSource实现determineCurrentLookupKey方法，该方法可以实现数据库的动态切换，如下

public class DynamicDataSourceextends AbstractRoutingDataSource {     @Override     protectedObject determineCurrentLookupKey() {         return DataSourceContextHolder.getDataSourceType();     }   public class DataSourceContextHolder {     private static final ThreadLocal<String>contextHolder =new ThreadLocal<String>();     /**      * @Description:设置数据源类型      * @paramdataSourceType  数据库类型      * @returnvoid      * @throws      */     public static voidsetDataSourceType(String dataSourceType) {         contextHolder.set(dataSourceType);     }     /**      * @Description:获取数据源类型      * @param      *@return String      * @throws      */     public staticString getDataSourceType() {         return contextHolder.get();     }     /**      * @Description:清除数据源类型      * @param      *@return void      * @throws      */     public static voidclearDataSourceType() {         contextHolder.remove();     } }

完成以上步骤后，如果没有数据库的事务管理，已经可以实现数据库的动态切换了。但是如果涉及到数据库的事务管理，需要在数据库事务开启切换数据库；

2.log4j配合druid

Log4j的各个名称的意义网上都有就不多写了直接上配置

log4j.rootLogger = DEBUG, stdout log4j.logger.org.apache.ibatis=warn log4j.logger.java.sql=warn log4j.logger.org.springframework=warn # Druid log4j.logger.druid.sql=DEBUG log4j.logger.druid.sql.DataSource=warn log4j.logger.druid.sql.Connection=warn log4j.logger.druid.sql.Statement=DEBUG log4j.logger.druid.sql.ResultSet=warn log4j.appender.stdout           =org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target    =System.out log4j.appender.stdout.Threshold =DEBUG log4j.appender.stdout.layout    =org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=  %-d{yyyy-MM-dd HH:mm:ss}  [ %p ]  %m%n