springtest-junit-jidi--测试接口

一，问题分析

假如在一个项目中要测试一个接口，但是这个项目没有对外开放url地址，话句话就是说浏览器访问不了里面的资源，自己造的数据不能测试接口，那么只能等别人来调用自己的接口，而且自己也不能测试，假如单纯的通过junit来测试的话，那么是无法加载IOC容器里面的东西，话句话就是说加载不了原来在tomcat启动的时候，加载xml的文件，applicationcontext容器里面的东西加载不了，所以用springtest，但是问题又来了，现在数据源是通过jidi来配置在tomcat里面的，怎么能加载到项目以外的东西呢？

二，代码分析

2.1，原来的/src/main/resources/context/init/context-ds.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
             http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
             http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
             http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

      <bean id="dataSource" class="com.bill99.boss.ds.util.DynamicDataSource" >
         <property name="targetDataSources">
             <map key-type="java.lang.String">
                 <entry key="appmobile" value-ref="mobileDS" ></entry>
                 <entry key="org" value-ref="bossDS" ></entry>
             </map>
         </property>
         <property name="defaultTargetDataSource" ref="defaultDataSource" >
         </property>
     </bean>   

     <bean id="defaultDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
25         <property name="jndiName" value="java:comp/env/BILL99/JDBC/SEASHELL" />
26     </bean>
27
28     <bean id="mobileDS" class="org.springframework.jndi.JndiObjectFactoryBean">
29         <property name="jndiName" value="java:comp/env/BILL99/JDBC/WX-PORTAL" />
30     </bean>
31
32     <bean id="bossDS" class="org.springframework.jndi.JndiObjectFactoryBean">
33         <property name="jndiName" value="java:comp/env/BILL99/JDBC/ORG" />
34     </bean>

     <bean id="orgjdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="bossDS" />
     </bean>

     <bean id="appmobilejdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="mobileDS" />
     </bean>

     <bean id="seashelljdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="defaultDataSource" />
     </bean>

     <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
         <constructor-arg ref="defaultDataSource"></constructor-arg>
     </bean>

     <alias name="dataSourceProxy" alias="seashellDS" />
     <alias name="dataSourceProxy" alias="authenticationDS" />
     <alias name="dataSourceProxy" alias="authorizationDS" />
     <alias name="dataSourceProxy" alias="logDS" />
     <alias name="dataSourceProxy" alias="accountingDS" />
     <alias name="dataSourceProxy" alias="cosDS" />
     <alias name="dataSourceProxy" alias="metadataDS" />
     <alias name="dataSourceProxy" alias="notificationDS" />
     <alias name="dataSourceProxy" alias="productDS" />
     <alias name="dataSourceProxy" alias="marketingDS" />
     <alias name="dataSourceProxy" alias="memberappDS" />
     <alias name="dataSourceProxy" alias="gatewayDS" />
     <alias name="dataSourceProxy" alias="pseDS" />
     <alias name="dataSourceProxy" alias="fundoutDS" />
     <alias name="dataSourceProxy" alias="memberinfoDS"/>

     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="dataSource" />
     </bean>

     <bean id="transactionManager"
         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
         <property name="dataSource" ref="bossDS" />
         <property name="globalRollbackOnParticipationFailure" value="false" />
     </bean>
     <aop:config>
         <aop:advisor
             pointcut="@within(org.springframework.transaction.annotation.Transactional)"
             advice-ref="txAdvice" order="1"/>
     </aop:config>

     <tx:advice id="txAdvice">
         <tx:attributes>
             <tx:method name="getToAuthList" propagation="REQUIRES_NEW"/>
             <tx:method name="*" rollback-for="java.lang.Exception"/>
         </tx:attributes>
     </tx:advice>

 </beans>

2.2,tomcat下的xml文件context.xml

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

     <WatchedResource>WEB-INF/web.xml</WatchedResource>      

 <Resource acquireIncrement="2" auth="Container" driverClass="org.gjt.mm.mysql.Driver" factory="com.bill99.seashell.encrypt.C3p0BeanFactory" idleConnectionTestPeriod="3600" jdbcUrl="jdbc:mysql://192.168.126.147:3306/boss?useUnicode=true&amp;characterEncoding=UTF-8" maxIdleTime="3600" maxPoolSize="30" minPoolSize="3" name="BILL99/JDBC/ORG" password="111111" type="com.mchange.v2.c3p0.ComboPooledDataSource" user="root"/>

 <Resource acquireIncrement="2" auth="Container" driverClass="org.gjt.mm.mysql.Driver" factory="com.bill99.seashell.encrypt.C3p0BeanFactory" idleConnectionTestPeriod="3600" jdbcUrl="jdbc:mysql://192.168.126.147:3306/appmobile?useUnicode=true&amp;characterEncoding=UTF-8" maxIdleTime="3600" maxPoolSize="30" minPoolSize="3" name="BILL99/JDBC/WX-PORTAL" password="111111" type="com.mchange.v2.c3p0.ComboPooledDataSource" user="root"/>

  <Resource acquireIncrement="2" auth="Container" driverClass="oracle.jdbc.driver.OracleDriver" factory="com.bill99.seashell.encrypt.C3p0BeanFactory" jdbcUrl="jdbc:oracle:thin:@192.168.127.121:1530:billdb" maxPoolSize="5" minPoolSize="3" name="BILL99/JDBC/SEASHELL121" password="seashell" type="com.mchange.v2.c3p0.ComboPooledDataSource" user="seashell"/> 

 </Context>

三，解决思路

3.1，jar包

         <dependency org="junit" name="junit" rev="4.12" conf="zip->default"/>
         <dependency org="org.hamcrest" name="hamcrest-core" rev="1.3" conf="zip->default"/>
         <dependency org="org.hamcrest" name="hamcrest-library" rev="1.3" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-test" rev="3.2.13.RELEASE" conf="zip->default"/>

         <dependency org="org.springframework" name="spring-data-redis" rev="1.6.2.RELEASE" conf="zip->default"/>
        <dependency org="org.springframework" name="spring-aop" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-beans" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-context" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-context-support" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-core" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-expression" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-tx" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-aspects" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-jdbc" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-jms" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-orm" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-web" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="org.springframework" name="spring-webmvc" rev="3.2.13.RELEASE" conf="zip->default"/>
         <dependency org="mysql" name="mysql-connector-java" rev="5.1.12" conf="zip->default"/>
         <dependency org="org.apache" name="catalina" rev="6.0.39" conf="compile->default"/>

3.2，/src/test/java/MdpTest.java测试类

 import javax.annotation.Resource;

 import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.springframework.test.context.ContextConfiguration;
 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

 import com.bill99.boss.domain.external.message.builder.impl.SafetyBankUploadImpl;

 @RunWith(SpringJUnit4ClassRunner.class)  //使用junit4进行测试
 @ContextConfiguration(
         {
13             "classpath:context/init/envPropertyLoader.xml" ,
14             "classpath:context/init/context-ds.xml",
15             "classpath*:context/*.xml",
16             "classpath*:context/ibatis/*.xml",
17             "classpath*:context/service/*.xml",
18             "classpath:context/init/thunderClient.xml"

             }) //加载配置文件) //加载配置文件
 public class MdpTest {
     @Resource
     private SafetyBankUploadImpl SafetyBankUploadImpl;
     @Test
     public void test() {
         SafetyBankUploadImpl.buildPictureFile("812110058130012", "1");
         System.out.println("666");
     }
 }

classpath中的别乱了顺序，要严格按照原来的加载顺序来写。

3.3，/src/test/resources/context/init/context-ds.xml下的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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
             http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
             http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
             http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

      <bean id="dataSource" class="com.bill99.boss.ds.util.DynamicDataSource" >
         <property name="targetDataSources">
             <map key-type="java.lang.String">
                 <entry key="appmobile" value-ref="mobileDS" ></entry>
                 <entry key="org" value-ref="bossDS" ></entry>
             </map>
         </property>
         <property name="defaultTargetDataSource" ref="defaultDataSource" >
         </property>
     </bean>
23
24     <bean id="defaultDataSource"
25             class="org.springframework.jdbc.datasource.DriverManagerDataSource"
26             p:driverClassName="oracle.jdbc.driver.OracleDriver"
27             p:url="jdbc:oracle:thin:@192.168.5.100:1530:billdb"
28             p:username="seashell" p:password="seashell" />
29
30     <bean id="mobileDS"
31             class="org.springframework.jdbc.datasource.DriverManagerDataSource"
32             p:driverClassName="org.gjt.mm.mysql.Driver"
33             p:url="jdbc:mysql://192.168.126.147:3306/appmobile?useUnicode=true&amp;characterEncoding=UTF-8"
34             p:username="root" p:password="111111" />
35
36     <bean id="bossDS"
37             class="org.springframework.jdbc.datasource.DriverManagerDataSource"
38             p:driverClassName="org.gjt.mm.mysql.Driver"
39             p:url="jdbc:mysql://192.168.126.147:3306/boss?useUnicode=true&amp;characterEncoding=UTF-8"
40             p:username="root" p:password="111111" />

     <bean id="orgjdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="bossDS" />
     </bean>

     <bean id="appmobilejdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="mobileDS" />
     </bean>

     <bean id="seashelljdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="defaultDataSource" />
     </bean>

     <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
         <constructor-arg ref="defaultDataSource"></constructor-arg>
     </bean>

     <alias name="dataSourceProxy" alias="seashellDS" />
     <alias name="dataSourceProxy" alias="authenticationDS" />
     <alias name="dataSourceProxy" alias="authorizationDS" />
     <alias name="dataSourceProxy" alias="logDS" />
     <alias name="dataSourceProxy" alias="accountingDS" />
     <alias name="dataSourceProxy" alias="cosDS" />
     <alias name="dataSourceProxy" alias="metadataDS" />
     <alias name="dataSourceProxy" alias="notificationDS" />
     <alias name="dataSourceProxy" alias="productDS" />
     <alias name="dataSourceProxy" alias="marketingDS" />
     <alias name="dataSourceProxy" alias="memberappDS" />
     <alias name="dataSourceProxy" alias="gatewayDS" />
     <alias name="dataSourceProxy" alias="pseDS" />
     <alias name="dataSourceProxy" alias="fundoutDS" />
     <alias name="dataSourceProxy" alias="memberinfoDS"/>

     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
         <constructor-arg ref="dataSource" />
     </bean>

     <bean id="transactionManager"
         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
         <property name="dataSource" ref="bossDS" />
         <property name="globalRollbackOnParticipationFailure" value="false" />
     </bean>
     <aop:config>
         <aop:advisor
             pointcut="@within(org.springframework.transaction.annotation.Transactional)"
             advice-ref="txAdvice" order="1"/>
     </aop:config>

     <tx:advice id="txAdvice">
         <tx:attributes>
             <tx:method name="getToAuthList" propagation="REQUIRES_NEW"/>
             <tx:method name="*" rollback-for="java.lang.Exception"/>
         </tx:attributes>
     </tx:advice>

 </beans>

3.4，图示

/src/test/resources/context/init/context-ds.xml下的xml文件级别要高于

/src/main/resources/context/init/context-ds.xml下的jar包，名称一样的话包括包名，test中的会把main下的替换掉的。

3.5，如果还报错的话把/src/main/resources/context/init/context-ds.xml下的context-ds.xml文件也替换掉

3.6，添加数据库驱动jar包

3.7,假如有内存溢出的话，则这样配置一下。

-Xms512m -Xmx512m -XX:MaxNewSize=512m -XX:MaxPermSize=512m