spring中H2数据库的使用

spring-mybatis.xml中的配置

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:task="http://www.springframework.org/schema/task" 
xsi:schemaLocation="http://www.springframework.org/schema/beans  
  http://www.springframework.org/schema/beans/spring-beans-4.1.xsd  
  http://www.springframework.org/schema/context  
  http://www.springframework.org/schema/context/spring-context-4.1.xsd  
  http://www.springframework.org/schema/mvc  
  http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
  http://www.springframework.org/schema/jms
  http://www.springframework.org/schema/jms/spring-jms-4.1.xsd
   http://www.springframework.org/schema/task  
  http://www.springframework.org/schema/task/spring-task-3.1.xsd">






 <!--    <task:annotation-driven/> 

<context:annotation-config/>  
    <bean class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor"/>  
    <context:component-scan base-package="com.test"/>  --> 
 




<mvc:annotation-driven />
<!-- 对静态资源文件的访问 不支持访问WEB-INF目录 -->
<!-- <mvc:default-servlet-handler /> -->




    <context:component-scan base-package="com.STNCP.Tracker">  
    <!-- 将Service注解给去掉  -->  
        <!-- <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>   -->
        <!-- <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>  --> 
    </context:component-scan>  


<mvc:resources mapping="/img/**" location="/WEB-INF/img/" />
<mvc:resources mapping="/js/**" location="/WEB-INF/js/" />


<!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
<!-- <context:component-scan base-package="com.STNCP.Tracker.Controller" />
<context:component-scan base-package="com.STNCP.Tracker" /> -->





<!--避免IE执行AJAX时，返回JSON出现下载文件 -->
<!-- <bean id="mappingJacksonHttpMessageConverter"
class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>-->


<!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
<!-- <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 
<property name="messageConverters"> <list> <ref bean="mappingJacksonHttpMessageConverter" 
/> </list> </property> </bean> -->


<!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="order" value="2" />
<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>

<mvc:interceptors> 
 <!-- 使用bean定义一个interceptor,直接定义在<mvc:interceptors>根目录下的拦截器，拦截所有请求 -->
<!-- <bean class="com.STNCP.web.interceptors.TokenValidateInterceptor2"/>  -->
<!-- 拦截特定请求的拦截器 -->
     <mvc:interceptor>
<mvc:mapping path="/1.0/**"/>
<bean class="com.STNCP.Tracker.Interceptors.TokenValidateInterceptor2"/>
</mvc:interceptor>
</mvc:interceptors> 
 
 
<bean id="connectionFactory" class="org.apache.activemq.pool.PooledConnectionFactory" destroy-method="stop">  
    <property name="connectionFactory">  
        <bean class="org.apache.activemq.ActiveMQConnectionFactory">  
            <property name="brokerURL"  
                value="tcp://localhost:61616" />  
                <!-- failover:(tcp://10.51.181.5:61616,tcp://10.51.176.208:61616) -->
               <!--  tcp://localhost:61616 -->
        </bean>  
    </property>  
    <!-- <property name="maxConnections" value="1"></property> -->  
</bean>   

<bean id="targetConnectionFactory" class="org.springframework.jms.connection.SingleConnectionFactory">
<property name="targetConnectionFactory" ref="connectionFactory"/>
</bean>

<bean id="jmsTemplate" class="org.springframework.jms.core.JmsTemplate">
<property name="connectionFactory" ref="connectionFactory" />
<property name="defaultDestination" ref="queueDestination1" />
<property name="receiveTimeout" value="10000" />
<property name="deliveryMode" value="2" />
<property name="sessionAcknowledgeMode" value="1" />
<property name="sessionTransacted" value="false" />
</bean>


<bean id="queueDestination1" class="org.apache.activemq.command.ActiveMQQueue">
<constructor-arg>
<value>cmdQueue</value>
</constructor-arg>
</bean>


<bean id="sender" class="com.STNCP.Tracker.JMS.Sender">
<property name="jmsTemplate" ref="jmsTemplate"></property>
</bean>


<bean id="messageListener" class="com.STNCP.Tracker.JMS.Reciever" />
<bean id="jmsContainer"
class="org.springframework.jms.listener.DefaultMessageListenerContainer">
<property name="connectionFactory" ref="connectionFactory" />
<!-- <property name="destination" ref="queueDestination1" /> -->
<property name="destination" ref="replyQueue" /> 
<property name="messageListener" ref="messageListener" />
<property name="sessionTransacted" value="false"/>
<property name="concurrency" value="4-8"/>
</bean>




<bean id="replyQueue" class="org.apache.activemq.command.ActiveMQQueue">
<constructor-arg>
<value>replyQueue</value>
</constructor-arg>
</bean>

</beans>

再配置数据库的时候配置两个数据源，dataSourceA和dataSourceB

在java代码中去使用的时候，创建类

public class DataSourceContextHolder {

       private static final ThreadLocal contextHolder = new ThreadLocal(); 
         public static final String DATA_SOURCE_A = "dataSourceA";

       public static final String DATA_SOURCE_B = "dataSourceB";

       public static void setDbType(String dbType) { 
                 contextHolder.set(dbType); 
         } 

         public static String getDbType() { 
                 return ((String) contextHolder.get()); 
         }

         public static void clearDbType() { 
                 contextHolder.remove(); 
         }

}

在每次使用的时候调用DataSourceContextHolder.setDbType("dataSourceA");或者

DataSourceContextHolder.setDbType("dataSourceB");就可以切换Mysql和H2数据库了