Hopefully this is more readable:
Code:
<?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.5.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd"
>
<jee:jndi-lookup id="dataSource"
jndi-name="com/uprr/app/tns/tns_PoolDS"
resource-ref="true"
default-ref="developmentDataSource"
/>
<bean id="developmentDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@dev091.oracle.uprr.com:1521:dev091" />
<property name="username" value="dtns999" />
<property name="password" value="xxx" />
</bean>
</beans>
Code:
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
"
default-autowire="byName"
>
<bean id="maintenanceTransactionTypeDao" class="com.uprr.db.dao.spring.stats.MaintenanceTransactionTypeDAO" />
<bean id="maintenanceItemTypeDao" class="com.uprr.db.dao.spring.stats.MaintenanceItemTypeDAO" />
<bean id="maintenanceTransactionDao" class="com.uprr.db.dao.spring.stats.MaintenanceTransactionDAO" />
<bean id="throwAdvice" class="com.uprr.aop.ThrowAdvice" />
<aop:config>
<aop:pointcut id="anyMethod" expression="execution(* *(..))" />
<aop:aspect ref="throwAdvice">
<aop:after-throwing throwing="error" pointcut-ref="anyMethod" method="afterThrowing" />
</aop:aspect>
</aop:config>
</beans>
Code:
import java.util.Iterator;
import org.apache.log4j.Logger;
import org.apache.log4j.xml.DOMConfigurator;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.uprr.db.dao.spring.stats.MaintenanceItemTypeDAO;
import com.uprr.db.dao.spring.stats.MaintenanceTransactionTypeDAO;
//----------------------------------------------------------------------------------------------
public class Test
{
public static final Logger logger = Logger.getLogger("com.uprr.tns.test");
//----------------------------------------------------------------------------------------------
public static void main(final String[] args) throws Exception
{
DOMConfigurator.configure("log4j-test.xml");
/**
* In production:
* getRootLogger().setLevel(Level.ERROR);
*/
final String configFiles[] = {"spring-test.xml", "spring-tns-api.xml"};
ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext(configFiles);
testTransactionTypes(context);
testItemTypes(context);
}
//----------------------------------------------------------------------------------------------
public static void testItemTypes(ClassPathXmlApplicationContext context) throws Exception
{
MaintenanceItemTypeDAO dao = MaintenanceItemTypeDAO.getBean(context);
Iterator iterator = dao.getAllTypes().iterator();
while (iterator.hasNext()) {
logger.info(iterator.next());
}
final Integer systemNumber = new Integer(3);
logger.info("Item type # " + systemNumber + " = " + dao.getDescription(systemNumber));
}
//----------------------------------------------------------------------------------------------
public static void testTransactionTypes(ClassPathXmlApplicationContext context) throws Exception
{
MaintenanceTransactionTypeDAO dao = MaintenanceTransactionTypeDAO.getBean(context);
Iterator iterator = dao.getAllTypes().iterator();
while (iterator.hasNext()) {
logger.info(iterator.next());
}
final Integer systemNumber = new Integer(3);
logger.info("Transaction type # " + systemNumber + " = " + dao.getDescription(systemNumber));
}
//----------------------------------------------------------------------------------------------
}