개발자를 위하여...

  xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"

  xmlns:p="http://www.springframework.org/schema/p"

  xsi:schemaLocation="

  http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

  http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

  <!-- context:annotation-config도 등록함 -->

  <context:component-scan base-package="kr.hibid.collector" />

  <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

  <bean id="hibidPum" class="org.springframework.orm.jpa.persistenceunit.DefaultPersistenceUnitManager">

    <property name="persistenceXmlLocations">

      <list>

        <value>/test-coll-persistence.xml</value>

        <value>/test-trans-persistence.xml</value>

      </list>

    </property>

    <property name="dataSources">

      <map>

        <entry key="hibidCollDS" value-ref="hibidCollDS" />

        <entry key="hibidTransDS" value-ref="hibidTransDS" />

      </map>

    </property>

    <property name="defaultDataSource" ref="hibidCollDS" />

  </bean>

  <!-- ===================================================================== -->

  <!-- Collection                                                            -->

  <!-- ===================================================================== -->

  <bean id="hibidCollDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />

    <property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=HibidCollDev" />

    <!-- <property name="connectionProperties" value="charset=eucksc;" /> -->

    <property name="username" value="hibid_coll_dev" />

    <property name="password" value="hibid_coll_dev" />

  </bean>

  <bean id="hibidCollEmf" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">

    <property name="persistenceUnitManager" ref="hibidPum" />

    <property name="persistenceUnitName" value="hibidCollUnit" />

    <property name="loadTimeWeaver">

      <bean class="org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver" />

    </property>

    <property name="jpaDialect">

      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />

    </property>

  </bean>

  <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">

    <property name="entityManagerFactory" ref="hibidCollEmf" />

    <property name="jpaDialect">

      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />

    </property>

  </bean>

  <tx:annotation-driven transaction-manager="transactionManager" />

  <!-- ===================================================================== -->

  <!-- Transference                                                          -->

  <!-- ===================================================================== -->

  <bean id="hibidTransDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />

    <property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=HibidTest" />

    <!-- <property name="connectionProperties" value="charset=eucksc;" /> -->

    <property name="username" value="hibid_test" />

    <property name="password" value="hibid_test" />

  </bean>

  <bean id="hibidTransEmf" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">

    <property name="persistenceUnitManager" ref="hibidPum" />

    <property name="persistenceUnitName" value="hibidTransUnit" />

    <property name="loadTimeWeaver">

      <bean class="org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver" />

    </property>

    <property name="jpaDialect">

      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />

    </property>

  </bean>

  <bean id="hibidTransTxManager" class="org.springframework.orm.jpa.JpaTransactionManager">

    <property name="entityManagerFactory" ref="hibidTransEmf" />

    <property name="jpaDialect">

      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />

    </property>

  </bean>

  <tx:annotation-driven transaction-manager="hibidTransTxManager" />

</beans>

@Transactional(propagation = Propagation.SUPPORTS)

public class PpsCollectionEao {

    @PersistenceContext(unitName = "hibidCollUnit")

    private EntityManager em;

    public List<PpsFacilityBiddingNotify> findFacilityBiddingNotifies(String baseDateTime) {

        // QL 작성

        StringBuilder qlString = new StringBuilder(200);

        qlString.append("SELECT pfbn FROM PpsFacilityBiddingNotify pfbn ");

        qlString.append("WHERE pfbn.collectDateTime is null ");

        qlString.append("  AND pfbn.transDateTime <= :baseDateTime ");

        // Query 실행 및 결과 반환

        TypedQuery<PpsFacilityBiddingNotify> query = this.em.createQuery(qlString.toString(), PpsFacilityBiddingNotify.class);

        query.setParameter("baseDateTime", baseDateTime);

        List<PpsFacilityBiddingNotify> results = query.getResultList();

        return results;

    }

    public List<PpsBiddingBasisAmount> findBiddingBasisAmounts(String baseDateTime) {

        // QL 작성

        StringBuilder qlString = new StringBuilder(200);

        qlString.append("select pbba from PpsBiddingBasisAmount pbba ");

        qlString.append("WHERE pbba.collectDateTime is null ");

        qlString.append("  AND pbba.transDateTime <= :baseDateTime ");

        // Query 실행 및 결과 반환

        TypedQuery<PpsBiddingBasisAmount> query = this.em.createQuery(qlString.toString(), PpsBiddingBasisAmount.class);

        query.setParameter("baseDateTime", baseDateTime);

        List<PpsBiddingBasisAmount> results = query.getResultList();

        return results;

    }

}