@H_404_3@
<?@H_404_3@ xml version= "1.0" encoding= "UTF-8" ?>
<@H_404_3@ beans xmlns= "http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"@H_404_3@
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"@H_404_3@
xsi:schemaLocation="http://www.springframework.org/schema/beans@H_404_3@
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd@H_404_3@
FROM FARE_BY_RULE_SEG@H_404_3@
FROM FARE_BY_RULE_SEG@H_404_3@
WHERE RULE_BTCH_SG IN (:batchSGs)@H_404_3@
AND SEG_EFF_DT < :effectiveDate@H_404_3@
WHERE RULE_BTCH_SG IN (:batchSGs)@H_404_3@
AND SEG_EFF_DT < :effectiveDate@H_404_3@
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd@H_404_3@
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd@H_404_3@
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">@H_404_3@
@H_404_3@
<import resource="classpath:/spring/FilingTextHistoryQueries.xml" />@H_404_3@
@H_404_3@
@H_404_3@
<bean id="sqlFareByRuleIndexCnt" class="java.lang.String">@H_404_3@
<constructor-arg index="0">@H_404_3@
<value>@H_404_3@
SELECT COUNT(*)@H_404_3@
FROM FARE_BY_RULE_SEG@H_404_3@
WHERE RULE_BTCH_SG IN (:batchSGs)@H_404_3@
</value>@H_404_3@
</constructor-arg>@H_404_3@
</bean>@H_404_3@
<bean id="ruleFBRILt" class="java.lang.String">@H_404_3@
<constructor-arg index="0" value="#{sqlFareByRuleIndexCnt+' AND SEG_EFF_DT < :effectiveDate'}"/>@H_404_3@
</bean>@H_404_3@
@H_404_3@
@H_404_3@
@H_404_3@
</@H_404_3@ beans >
@H_404_3@
结果为：ruleFBRILt=@H_404_3@
SELECT COUNT(*) FROM FARE_BY_RULE_SEG WHERE RULE_BTCH_SG IN (:batchSGs) AND SEG_EFF_DT < :effectiveDate@H_404_3@
