spring初始化配置文件

忘是亡心i 2022-08-09 16:54 178阅读 0赞

import org.springframework.context.support.ClassPathXmlApplicationContext;  
  
public class SpringManager \{  
  
    private static ClassPathXmlApplicationContext context = null;  
      
    static\{  
        init();  
    \}  
    /\*\*  
     \*  
     \*/  
    public static synchronized void init()\{  
        if(context==null)\{  
          context = new ClassPathXmlApplicationContext("conf/SpringContext.xml");  
        \}  
    \}  
      
    public Object getBean(String beanName)\{  
        return context.getBean(beanName);  
    \}  
\}  
  
<?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:jee="http://www.springframework.org/schema/jee"  
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd  
           http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.0.xsd  
           http://activemq.apache.org/schema/core http://activemq.apache.org/schema/core/activemq-core-5.2.0.xsd">  
  
      
       
    <bean id="dataSource\_aaa" class="org.apache.commons.dbcp.BasicDataSource">  
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>  
        <property name="url" value="jdbc:oracle:thin:@172.21.11.142:1521:corac"/>  
        <property name="username" value="gd\_aaa"/>  
        <property name="password" value="cxxx"/>  
        <property name="initialSize" value="5" />  
        <property name="maxActive" value="100"/>  
        <property name="maxIdle" value="30" />  
        <property name="maxWait" value="1000" />  
        <property name="poolPreparedStatements" value="true"/>  
        <property name="defaultAutoCommit" value="true" />  
        <property name="removeAbandoned" value="true" />  
        <property name="removeAbandonedTimeout" value="5" />  
    </bean>  
    <bean id="transactionManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
        <property name="dataSource">  
          <ref bean="dataSource\_aaa"/>  
        </property>  
    </bean>  
    <bean id="sqlMapClient\_aaa"  
        class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">  
        <property name="configLocation" value="classpath:conf/sql-map-config.xml" />  
        <property name="dataSource" ref="dataSource\_aaa" />  
    </bean>  
    <bean id="baseTransactionProxy" abstract="true"  
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">  
        <property name="transactionManager">  
            <ref local="transactionManager" />  
        </property>  
        <property name="transactionAttributes">  
            <props>  
                <prop key="get\*">PROPAGATION\_REQUIRED,readOnly</prop>  
                <prop key="find\*">PROPAGATION\_REQUIRED,readOnly</prop>  
                <prop key="load\*">PROPAGATION\_REQUIRED,readOnly</prop>  
                <prop key="search\*">PROPAGATION\_REQUIRED,readOnly</prop>  
                <prop key="count\*">PROPAGATION\_REQUIRED,readOnly</prop>  
                <prop key="save\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="add\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="create\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="insert\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="update\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="modify\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="delete\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="shift\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="del\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="remove\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="upload\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="purchase\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="cancel\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="do\*">PROPAGATION\_REQUIRED</prop>  
                <prop key="\*Delete">PROPAGATION\_REQUIRED</prop>  
                <prop key="\*">PROPAGATION\_REQUIRED,readOnly</prop>  
            </props>  
        </property>  
    </bean>  
   <import resource="SpringTask.xml" />  
     
   <import resource="SpringJob.xml" />    
   <import resource="SpringTimer.xml" />    
   <import resource="SpringTriger.xml" />    
</beans>  
  
SpringTask.xml  
<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">  
<beans>  
  
    <bean id="orderTaskRun" class="com.coship.report.task.BaseReportRunTask">  
        <property name="sqlMapClient">  
            <ref bean="sqlMapClient\_aaa" />  
        </property>  
          
        <property name="ftpIp">  
            <value>10.9.216.3</value>  
        </property>  
        <property name="ftpPort">  
            <value>21</value>  
        </property>  
        <property name="ftpUser">  
            <value>root</value>  
        </property>  
        <property name="ftpPassword">  
            <value>coship</value>  
        </property>  
        <property name="ftpPath">  
            <value>/home/report</value>  
        </property>  
        <property name="sqlId">  
            <value>orderTask</value>  
        </property>  
        <property name="perPagerRows">  
            <value>10000</value>  
        </property>  
        <property name="localTmpFilePath">  
            <value>/tmp/</value>  
        </property>  
        <property name="writeColumns">  
            <value>SUB\_ID,USER\_CODE,SMARTCARD\_ID,SUBSCRIBE\_TIME,SUBSCRIBE\_DATE,SERVICE\_CODE,REAL\_PRICE,ORDER\_TYPE,RESOURCE\_ID,GOODS\_CODE,PRODOFFERING\_CODE,ENABLE\_TIME,DISABLE\_TIME,validTime,UNSUBSCRIBE\_TIME</value>  
        </property>  
        <property name="fileMaxRows">  
            <value>50000</value>  
        </property>  
        <property name="moduleName">  
            <value>orderTask</value>  
        </property>  
        <property name="applicationName">  
            <value>dhm</value>  
        </property>  
        <property name="beforePrefix">  
            <value></value>  
        </property>  
        <property name="afterPrefix">  
            <value></value>  
        </property>  
        <property name="columnPrefix">  
            <value>\],\[</value>  
        </property>  
    </bean>  
  
      
</beans>  
  
SpringJob.xml  
<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">  
<beans>      
        
      <bean id="orderJob"  
        class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">  
        <property name="targetObject">  
          <ref bean="orderTask" />  
        </property>  
        <property name="targetMethod">  
          <value>run</value>  
        </property>  
      </bean>  
  
</beans>  
  
SpringTimer.xml  
<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">  
<beans>      
  
   
          
   
      <bean id="orderTrigger" class="org.springframework.scheduling.quartz.CronTriggerBean">  
        <property name="jobDetail">  
          <ref bean="orderJob"></ref>  
        </property>  
        <property name="cronExpression">  
            <value>0 10 23 \* \* ?</value>  
        </property>  
      </bean>  
      
    <bean id="EpgByColumnCountTrigger" class="org.springframework.scheduling.quartz.CronTriggerBean">  
        <property name="jobDetail" ref="EpgByColumnCountJob"/>  
        <property name="cronExpression" value="0 30 0 \* \* ?"/>  
    </bean>  
              
</beans>  
  
SpringTriger.xml  
  <bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">  
    <property name="triggers">  
      <list>  
        <ref bean="orderTrigger"></ref>  
      </list>  
    </property>  
  </bean>    
   
 sql-map-config.xml  
 <?xml version="1.0" encoding="UTF-8"?>        
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"  
     "http://www.ibatis.com/dtd/sql-map-config-2.dtd">                                                                                                                                                                                   
<sqlMapConfig>       
        <sqlMap resource="/conf/reportForIEPG.xml"/>  
</sqlMapConfig>  
  
reportForIEPG.xml  
<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">  
  
<sqlMap namespace="report">  
      
    <resultMap id="resultOrderInfoMap" class="java.util.HashMap">  
        <result property="SUB\_ID" column="SUB\_ID" />  
        <result property="USER\_CODE" column="USER\_CODE" />  
        <result property="SMARTCARD\_ID" column="SMARTCARD\_ID" />  
        <result property="SUBSCRIBE\_TIME" column="SUBSCRIBE\_TIME" />  
        <result property="SUBSCRIBE\_DATE" column="SUBSCRIBE\_DATE" />  
        <result property="SERVICE\_CODE" column="SERVICE\_CODE" />  
        <result property="REAL\_PRICE" column="REAL\_PRICE" />  
        <result property="ORDER\_TYPE" column="ORDER\_TYPE" />  
        <result property="RESOURCE\_ID" column="RESOURCE\_ID" />  
        <result property="GOODS\_CODE" column="GOODS\_CODE" />  
        <result property="PRODOFFERING\_CODE" column="PRODOFFERING\_CODE" />  
        <result property="ENABLE\_TIME" column="ENABLE\_TIME" />  
        <result property="DISABLE\_TIME" column="DISABLE\_TIME" />  
        <result property="validTime" column="VALID\_TIME" />  
        <result property="UNSUBSCRIBE\_TIME" column="UNSUBSCRIBE\_TIME" />  
    </resultMap>  
    <select id="orderTask" resultMap="resultOrderInfoMap">  
           <!\[CDATA\[            
              select a.SUB\_ID,  
              u.USER\_CODE,  
              u.SMARTCARD\_ID,  
              a.SUBSCRIBE\_TIME,  
              to\_char(a.SUBSCRIBE\_TIME,'YYYY-MM-DD') as SUBSCRIBE\_DATE,    
              '' SERVICE\_CODE,  
              b.REAL\_PRICE,  
              a.ORDER\_TYPE,  
              a.RESOURCE\_ID,  
              g.GOODS\_CODE,  
              a.PRODOFFERING\_CODE,  
              to\_char(a.ENABLE\_TIME,'yyyy-mm-dd hh24:mi:ss') as ENABLE\_TIME,  
              to\_char(a.DISABLE\_TIME,'yyyy-mm-dd hh24:mi:ss') as DISABLE\_TIME,  
            (a.disable\_time-a.enable\_time)\*24\*60 as VALID\_TIME,  
              a.UNSUBSCRIBE\_TIME           
         from t\_subscription a  
         left join t\_billing b on a.sub\_id = b.sub\_id  
         left join  t\_user u   on   a.USER\_ID = u.USER\_ID  
         left join T\_AAA\_GOODS g on a.goods\_id=g.goods\_id  
         where                  
          a.status='1'  
          and a.SUBSCRIBE\_TIME < trunc(sysdate)  
    \]\]>  
    </select>  
</sqlMap>