develog

프로시저 소스information_schema.ROUTINES SELECT * FROM information_schema.ROUTINES ; SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' ; SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' ;

log4j.properties # Root logger log4j.rootLogger=DEBUG, stdout, fileout # stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=[%d] [%-5p] %m (%l)%n # fileout log4j.appender.fileout=org.apache.log4j.FileAppender log4j.appender.fileout.File=C:/..

import java.util.List; import org.aspectj.lang.JoinPoint;import org.aspectj.lang.Signature;import org.apache.commons.logging.Log;import org.apache.commons.logging.LogFactory; public class LoggingAdvice { private Log logger = LogFactory.getLog(getClass()); public void before(JoinPoint joinPoint) { if (!logger.isDebugEnabled()) return; StringBuffer sb = new StringBuffer(); sb.append(getMethodNm(jo..

SELECT NOW() AS DATE현재, DATE_ADD(NOW(), INTERVAL -1 DAY) AS DATE현재_1일전, DATE_ADD(NOW(), INTERVAL -1 WEEK) AS DATE현재_일주일전, DATE_ADD(NOW(), INTERVAL -1 MONTH) AS DATE현재_1달전, DATE_ADD(NOW(), INTERVAL -1 YEAR) AS DATE현재_1년전 ; SELECT DATE_FORMAT(NOW(), '%Y-%m-%d') AS DATE현재, DATE_ADD(DATE_FORMAT(NOW(), '%Y-%m-%d'), INTERVAL -1 DAY) AS DATE현재_1일전, DATE_ADD(DATE_FORMAT(NOW(), '%Y-%m-%d'), INTERVAL -1 W..

clsecho off set yyyy=%date:~0,4%set mm=%date:~5,2%set dd=%date:~8,2%set yyyymmdd=%yyyy%%mm%%dd% set hh=%time:~0,2%set mi=%time:~3,2%set ss=%time:~6,2%set hhmiss=%hh%%mi%%ss% set now=%hhmiss%.%yyyymmdd% echo %date%echo %time%echo %now%

경로 : /workspace/.metadata/.plugins/org.eclipse.core.resources/.history아래 경로에 모든 파일 및 폴더를 삭제