연계기관관리

CREATE TABLE COMTECOPSEQ ( table_name varchar(16) NOT NULL, 
                               next_id DECIMAL(30) NOT NULL,
                               PRIMARY KEY (table_name)
    );
 
    INSERT INTO COMTECOPSEQ VALUES ('INSTT_ID','0');
    INSERT INTO COMTECOPSEQ VALUES ('SYS_ID','0');
    INSERT INTO COMTECOPSEQ VALUES ('SVC_ID','0');

<!-- 연계기관 -->
    <bean name="egovCntcInsttIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="egovCntcInsttIdMsgtrategy" />
        <property name="blockSize"  value="10" />
        <property name="table"      value="COMTECOPSEQ" />
        <property name="tableName"  value="INSTT_ID" />
    </bean>
    <bean name="egovCntcInsttIdMsgtrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix"     value="INS" />
        <property name="cipers"     value="5" />
        <property name="fillChar"   value="0" />
    </bean>
 
    <!-- 연계시스템 -->
    <bean name="egovCntcSystemIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="egovCntcSystemIdMsgtrategy" />
        <property name="blockSize"  value="10" />
        <property name="table"      value="COMTECOPSEQ" />
        <property name="tableName"  value="SYS_ID" />
    </bean>
    <bean name="egovCntcSystemIdMsgtrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix"     value="SYS" />
        <property name="cipers"     value="5" />
        <property name="fillChar"   value="0" />
    </bean>
 
    <!-- 연계서비스 -->
    <bean name="egovCntcServiceIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="egovCntcServiceIdMsgtrategy" />
        <property name="blockSize"  value="10" />
        <property name="table"      value="COMTECOPSEQ" />
        <property name="tableName"  value="SVC_ID" />
    </bean>
    <bean name="egovCntcServiceIdMsgtrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix"     value="SVC" />
        <property name="cipers"     value="5" />
        <property name="fillChar"   value="0" />
    </bean>