본문 바로가기

나 어제 배웠다

 (108)
Oracle 계층형 Query SELECT MENU_NO AS "menuNo" , MENU_ORDR AS "menuOrdr" , MENU_NM AS "menuNm" , UPPER_MENU_NO AS "upperMenuId" , MENU_DC AS "menuDc" , RELATE_IMAGE_PATH AS "relateImagePath" , RELATE_IMAGE_NM AS "relateImageNm" , PROGRM_FILE_NM AS "progrmFileNm" , 'HOME' || SYS_CONNECT_BY_PATH(MENU_NM, ' > ') AS "menuNmPath" /* 상위부터 하위까지 경로 명 표시 */ , CONNECT_BY_ROOT M..
리눅스 날짜별 백업파일 생성 및 복사 스크립트 리눅스 날짜별 백업파일 생성 및 복사 스크립트 nowtime=`date +%Y%m%d` rm -r /volume1/backup/$nowtime mkdir /volume1/backup/$nowtime cp -r /volume1/SIMS/ /volume1/backup/$nowtime cp -r /volume1/사업관리/ /volume1/backup/$nowtime =========================================== - 백업 스크립트 backup.sh 파일을 아래 내용으로 생성 #!/bin/sh timesys..
신규 패키지(Package) 추가 방법 패키지 추가 1. context-common.xml <!-- component-scan 설정--> <context:component-scan base-package="egovframework, sims"/> 2. egov-com-servlet.xml <!-- 패키지 내 Controller, Service, Repository 클래스의 auto detect를 위한 mvc 설정 --> <context:component-scan base-package="egovframework, sims">
메이븐(maven) 빌드시 tools.jar 못찾는 오류 SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. [INFO] Scanning for projects... [WARNING] [WARNING] Some problems were encountered while building the effective model for egov:sims:war:1.0.0 [WARNING] 'build.plugins.pl..
Can not find the tag library descriptor for "http://java.sun.com/jsp/jstl/core" 1. The container Maven Dependencies references non existing library 'C:\Users\<userName>\.m2\repository\<package path>.jar' => Project Context Menu > Maven > Update Dependencies 2. Can not find the tag library descriptor for "http://java.sun.com/jsp/jstl/core" => Project Context Menu > Properties > Targeted Runtimes Check Apache Tomcat v7.0
DB2 날짜 변환 참고 SELECT CURRENT DATE , VARCHAR_FORMAT(CURRENT DATE + 1 DAY,'YYYYMMDD') , VARCHAR_FORMAT(CURRENT DATE + 15 DAYS,'YYYYMMDD') , CAST('2013-08-26' AS DATE) + 1 DAYS , SUBSTR('20130826130000', 1, 8) , TO_DATE('20130826', 'YYYY-MM-DD') , VARCHAR_FORMAT(TO_DATE('20130826', 'YYYY-MM-DD') + 1 DAYS, 'YYYYMMDD') FROM SYSIBM.SYSDUMMY1;
taglib bean:define 사용법 <logic:iterate id="list" property="pointViewList" name="pointForm"> <bean:define id="point_date" property="point_date" name="list"/> <bean:define id="amt" property="amt" name="list"/> <bean:define id="add_point" property="add_point" name="list"/> <bean:define id="use_point" property="use_point" name="list"/> <bean:define id="total_point" proper..
jQuery 단일건 조회/저장 - Struts JSP <script language="javascript" src="jquery.blockUI.js"></script> 1. Script $(document).ready(function() { $('.register').click(function() { var $register = $(this); var tenderNum = $register.attr('id'); $.blockUI({ message: $('#ttmu103Form') , css: {top: '25%', cursor: '', border: '1px solid #aaa', textAlign: 'center', width: '400px'} , overlayCSS: {backgroundCo..

티스토리툴바