웹로그관리

CREATE TABLE COMTECOPSEQ(TABLE_NAME VARCHAR(20) NOT NULL,
	                    NEXT_ID NUMERIC(30) NULL,
	                    PRIMARY KEY (TABLE_NAME));
 
  INSERT INTO COMTECOPSEQ VALUES('WEBLOG_ID','1');

<bean name="egovWebLogIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="webLogStrategy" />
        <property name="blockSize"  value="10"/>
        <property name="table"      value="COMTECOPSEQ"/>
        <property name="tableName"  value="WEBLOG_ID"/>
    </bean>
    <bean name="webLogStrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix"   value="WEBLOG_" />
        <property name="cipers"   value="13" />
        <property name="fillChar" value="0" />
    </bean>

<bean id="egovWebLogInterceptor" class="egovframework.com.sym.log.wlg.web.EgovWebLogInterceptor" />
 
  <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping">
    <property name="interceptors">
      <list>
        <ref bean="egovWebLogInterceptor" />
      </list>
    </property> 
  </bean>

package egovframework.com.sym.log.wlg.web;
import egovframework.com.cmm.LoginVO;
import egovframework.com.cmm.util.EgovUserDetailsHelper;
import egovframework.com.sym.log.wlg.service.EgovWebLogService;
import egovframework.com.sym.log.wlg.service.WebLog;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;
public class EgovWebLogInterceptor extends HandlerInterceptorAdapter {
@Resource(name="EgovWebLogService")
private EgovWebLogService webLogService;
/**
* 웹 로그정보를 생성한다.
*
* @param HttpServletRequest request, HttpServletResponse response, Object handler
* @return
* @throws Exception
*/
@Override
public void postHandle(HttpServletRequest request,
HttpServletResponse response, Object handler, ModelAndView modeAndView) throws Exception {
WebLog webLog = new WebLog();
String reqURL = request.getRequestURI();
String uniqId = "";
/* Authenticated  */
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(isAuthenticated.booleanValue()) {
LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
uniqId = user.getUniqId();
}
webLog.setUrl(reqURL);
webLog.setRqesterId(uniqId);
webLog.setRqesterIp(request.getRemoteAddr());
webLogService.logInsertWebLog(webLog);
}
}

<!-- 웹 로그 요약  -->
	<bean id="webLogging" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="egovWebLogScheduling" />
		<property name="targetMethod" value="webLogSummary" />
		<property name="concurrent" value="false" />
	</bean>
 
	<!-- 웹 로그 요약  트리거-->
	<bean id="webLogTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<property name="jobDetail" ref="webLogging" />
		<property name="startDelay" value="60000" />
		<property name="repeatInterval" value="3600000" />
	</bean>
 
	<!-- 웹 로그 요약 스케줄러 -->
	<bean id="webLogScheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
		<property name="triggers">
			<list>
				<ref bean="webLogTrigger" />				
			</list>
		</property>
	</bean>

@Service("egovWebLogScheduling")
public class EgovWebLogScheduling extends EgovAbstractServiceImpl {
@Resource(name="EgovWebLogService")
private EgovWebLogService webLogService;
/**
* 웹 로그정보를 요약한다.
* 전날의 로그를 요약하여 입력하고, 6개월전의 로그를 삭제한다.
*
* @param
* @return
* @throws Exception
*/
public void webLogSummary() throws Exception {
webLogService.logInsertWebLogSummary();
}
}