접속로그관리

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

<bean name="egovLoginLogIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="loginLogStrategy" />
        <property name="blockSize"  value="10"/>
        <property name="table"      value="COMTECOPSEQ"/>
        <property name="tableName"  value="LOGINLOG_ID"/>
    </bean>
    <bean name="loginLogStrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix"   value="LOGIN_" />
        <property name="cipers"   value="14" />
        <property name="fillChar" value="0" />
    </bean>

<bean id="loginlog" class="egovframework.com.sym.log.clg.service.EgovLoginLogAspect" />
 
	<aop:config>
		<aop:aspect id="loginLogAspect" ref="loginlog">
			<!--  로그인 Method -->
			<aop:before pointcut="execution(public * egovframework.com.uat.uia.web.EgovLoginController.actionMain(..)) " method="logLogin" />
			<!--  로그아웃 Method -->
			<aop:before pointcut="execution(public * egovframework.com.uat.uia.web.EgovLoginController.actionLogout(..))" method="logLogout" />
		</aop:aspect>
	</aop:config>

package egovframework.com.sym.log.clg.service;
import egovframework.com.cmm.LoginVO;
import egovframework.com.cmm.util.EgovUserDetailsHelper;
import javax.annotation.Resource;
public class EgovLoginLogAspect {
@Resource(name="EgovLoginLogService")
private EgovLoginLogService loginLogService;
/**
* 로그인 로그정보를 생성한다.
* EgovLoginController.actionMain Method
*
* @param
* @return void
* @throws Exception
*/
public void logLogin() throws Throwable {
String uniqId = "";
String ip = "";
/* Authenticated  */
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(isAuthenticated.booleanValue()) {
LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
uniqId = user.getUniqId();
ip = user.getIp();
}
LoginLog loginLog = new LoginLog();
loginLog.setLoginId(uniqId);
loginLog.setLoginIp(ip);
loginLog.setLoginMthd("I"); // 로그인:I, 로그아웃:O
loginLog.setErrOccrrAt("N");
loginLog.setErrorCode(");
loginLogService.logInsertLoginLog(loginLog);
}
/**
* 로그아웃 로그정보를 생성한다.
* EgovLoginController.actionLogout Method
*
* @param
* @return void
* @throws Exception
*/
public void logLogout() throws Throwable {
String uniqId = "";
String ip = "";
/* Authenticated  */
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(isAuthenticated.booleanValue()) {
LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
uniqId = user.getUniqId();
ip = user.getIp();
}
LoginLog loginLog = new LoginLog();
loginLog.setLoginId(uniqId);
loginLog.setLoginIp(ip);
loginLog.setLoginMthd("O"); // 로그인:I, 로그아웃:O
loginLog.setErrOccrrAt("N");
loginLog.setErrorCode(");
loginLogService.logInsertLoginLog(loginLog);
}
}