[Java] 기억모으기

@

return RedirectWebRoot.redirect(request, "page/client_login");
String sessionValues = EgovSessionCookieUtil.getSessionValuesString(request);
logger.debug("@@@@@ EgovSessionCookieUtil.getSessionValuesString : "+sessionValues);
 
COMTNBBSMASTER.BBS_ATTRB_CODE_NM
 
BBSA01    유효게시판
BBSA02    갤러리
BBSA03    일반게시판
BBSA04    링크게시판
 
cd /NCIS/WebApp/www
tar -xvf backup_was_20200928.tar
 
C:\dev\workspace\test\src\main\webapp\js\frt\open.min.js
 
 
 
@Override
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
    String requestURI = request.getRequestURI(); //요청 URI
    boolean isPermittedURL = false;
 
    if(requestURI.indexOf("/mhi") > -1){
        String ipChk = request.getRemoteAddr();
        List adminIpList = menuManageService.selectAdminIpList();
        String temp = "";
        boolean ipcheck = false;
        Map<Object, String> map = new HashMap<Object, String>();
        try{
            for(int i = 0 ; i < adminIpList.size() ; i++){
                map = (HashMap)adminIpList.get(i);
                temp = map.get("IP").toString();
                if(temp.equals(ipChk)){
                    ipcheck = true;
                }
            }
        }catch(Exception e){
            e.printStackTrace();
        }
 
        if(!ipcheck){
            response.sendRedirect("/code404.jsp");
            return false;
        }
    }
}
 
/**
 * 허용IP 조회
 * @param  List
 * @exception Exception
 */
List selectAdminIpList() throws Exception;
 
/**
 * 허용IP 조회
 * @param  List
 * @exception Exception
 */
public List selectAdminIpList() throws Exception {
      return menuManageDAO.selectAdminIpList();
}
 
/**
 * 허용IP 조회
 * @param  List
 * @exception Exception
 */
public List selectAdminIpList() throws Exception {
 return menuManageDAO.selectAdminIpList();
}
 
<select id="menuManageDAO.selectAdminIpList" resultClass="java.util.HashMap">
    <![CDATA[
        select IP from COMTNALLOWABLE where use_at = 'Y'
    ]]>
</select>
 
<a href="javascript:alert('test');">test</a>
 
// uid를 session 에서
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
uniqId = user.getUniqId();
UserManageVO userManageVO = new UserManageVO();
userManageVO = userManageService.selectUser(uniqId);
 
cd C:\Users\MOISDEV-01\Desktop\com2020
dir /b/s > list.txt
 
<%
    String referer = (String)request.getHeader("referer");
    System.out.println("#####        referer        #####" + referer );
%>
 
-Dlog4jdbc.drivers="com.tmax.tibero.jdbc.TbDriver"
-javaagent:C:\springloaded\springloaded-1.2.6.RELEASE.jar -noverify
 
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" trimDirectiveWhitespaces="true" %>
 
C:\Users\MOISDEV-01\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup
 
/*
 * 사용자IP 체크 인터셉터
 * @author 2020유지보수팀
 * @since 2020.01.01
 * @version 1.0
 *
 * <pre>
 * << 개정이력(Modification Information) >>
 *
 *   수정일     수정자          수정내용
 *  ----------  --------    ---------------------------
 *  2013.03.28    이기하          최초 생성
 *  </pre>
 */
 
<!-- ########################################################################################### -->
DB
Constraint            Type    Column    Position    Delete Rule    Ref Cons. Name    Constraint Text    Ref Owner
COMTNMENUINFO_N_PK    PRIMARY KEY        MENU_NO    0
 
ALTER TABLE COMTNBBSMASTER ADD (BACK_GROUND_COLOR_AT VARCHAR2(7) );
ALTER TABLE COMTNBBSMASTER DROP COLUMN BACK_GROUND_COLOR_AT;
ALTER TABLE COMTNBBSMASTER ADD (BG_COLOR_AT VARCHAR2(1) );
 
PK와 인덱스 한번에 지우기
ALTER TABLE COMTNMENUINFO DROP PRIMARY KEY MENU_NO;
 
PK해제하기
ALTER TABLE COMTNMENUINFO DROP CONSTRAINT MENU_NO;
 
DATE업데이트
UPDATE POLL_LIST SET MOD_DT = TO_DATE('2009/06/01 11:00:00', 'YYYY/MM/DD HH:MI:SS') WHERE PL_IDX = 'PL00000000' ;
 
VARCHAR업데이트
UPDATE POLL_LIST SET PL_END_DATE = '2020-05-30 18:00:00' WHERE PL_IDX = 'PL00000000';
 
SELECT * FROM v$version;
 
COMMENT ON COLUMN COMTCADMINISTCODE.USE_AT IS '사용여부';
 
SELECT ROWNUM ROWNM, AA.*
FROM
(
  SELECT A.OWNER,
         A.TABLE_NAME,
         A.COLUMN_ID,
         A.COLUMN_NAME,
         B.COMMENTS,
         A.DATA_TYPE,
         A.DATA_LENGTH,
         A.NULLABLE
    FROM ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B
   WHERE A.TABLE_NAME = B.TABLE_NAME
     AND A.COLUMN_NAME = B.COLUMN_NAME
     AND A.OWNER = 'MOSPA'             /*owner name*/
--   AND A.TABLE_NAME = 'EMPLOY'       /*table name*/
-- AND B.COMMENTS LIKE '%소관%'
-- AND A.DATA_TYPE = 'CLOB'
   ORDER BY A.TABLE_NAME, A.COLUMN_ID
) AA
WHERE COLUMN_NAME LIKE '%USE%'
;
 
캐릭터타입 > 날짜형식으로 전환
WHERE TO_DATE(TO_CHAR(CREATED,'YYYY-MM-DD'),'YYYY-MM-DD') >= '2017-01-01'
  AND TO_DATE(TO_CHAR(CREATED,'YYYY-MM-DD'),'YYYY-MM-DD') < '2018-01-01'
 
SELECT ROWID, A.ORDER_NO, A.* FROM TB_EDU_EDUSNT_M A
 WHERE A.EDU_PLAN_CD = '20180103EP0006'
   AND (A.EDUSNT_NM, A.CTTPC) IN(
       ('홍길동','010-1234-5678')
      ,('김꽃님','010-1234-5678')
);
 
<!-- ########################################################################################### -->
JAVA
request.setCharacterEncoding("utf-8");
 
//IP
InetAddress inet = InetAddress.getLocalHost();
String chkIp = inet.getHostAddress();
//IP허용여부
boolean isPass = IpFilterUtil.isPass();
 
//시간
long time = System.currentTimeMillis();
SimpleDateFormat dayTime = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss");
String chkCurrentTime = dayTime.format(new Date(time));
 
//URL
String URL = request.getRequestURL().toString();
String Scheme = request.getScheme().toString();    //HTTP
String URI = request.getRequestURI();            ///hrm/index.do
int serverPort = request.getServerPort();        //80
String domainNm = request.getServerName();        //localhost OR www.agriedu.net
 
String retUrl = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + URI;
<!-- ########################################################################################### -->
자바 ParamUtil 현재메소드명 파라미터로 같이 보내기
/* ######################################################################################################################################## */
String nowMethod = new Object() {}.getClass().getEnclosingMethod().getName();
Map<String, Object> reqGetParameterToMap = ComParamLogger.requestGetParameterToMap(this.getClass().getName().toString(), nowMethod, request);
ComParamLogger.paramToVO(OrgController.class.getClass().getName().toString(), nowMethod, orgVO);
/* ######################################################################################################################################## */
 
/* ####################################################################################### */
public static List requestToMap(List requestList) {
log.debug("### ListUtil 시작---------------------------------------------------------------");
List rtnList = new ArrayList();
try { Iterator resultIterator = requestList.iterator(); int i = 0; while (resultIterator.hasNext()) {
ListOrderedMap oderKeyMap = (ListOrderedMap) resultIterator.next();
log.debug("### ListUtil 1for문 ###" + "Row["+i+"]의 모든 값 oderKeyMap ==" + oderKeyMap); // String idRd = String.valueOf(oderKeyMap.get("id"));
// int id = Integer.parseInt(idRd); // log.debug("### ListUtil 1for문 ### id == " + id);
EgovMap colMap = new EgovMap(); int j = 0; Set key = oderKeyMap.keySet();
for (Iterator iterator = key.iterator(); iterator.hasNext();) {
String keyName = (String) iterator.next(); Object valueName = (Object) oderKeyMap.get(keyName);
log.debug("### ListUtil 2for문 ###" + "Row["+i+"]의 colMap["+j+"] ###" + keyName + " = " + valueName); colMap.put(keyName, valueName); j++; }
rtnList.add((EgovMap) colMap); i++; } } catch (Exception e) { log.debug("### ListUtil Exception : \n" + e); }
log.debug("### ListUtil 끝---------------------------------------------------------------");
return rtnList;
 
<!-- ######################################################################################## -->
 
<!-- ########################################################################################### -->
자바 null 처리
String searchAreaCityId = paramMap.get("searchAreaCityId")           /* 검색>지역센터아이디 */
String fileNameArrayRd = request.getParameter("fileNameArrayRd") == null ? "" : request.getParameter("fileNameArrayRd");        /* 검색>정렬속성선택+오름차순내림차순 */
 
<!-- ########################################################################################### -->
로그1
import org.apache.log4j.Logger;
private Logger logger = Logger.getLogger(this.getClass());
 
<!-- ########################################################################################### -->
로그2
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
 
public class ComReqToMap {
private static final Logger logger = LoggerFactory.getLogger(ComReqToMap.class);
 
protected Logger logger = LogFactory.getLog(this.getClass());
protected Logger logger = LoggerFactory.getLogger(this.getClass());
 
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
protected Logger logger = LoggerFactory.getLogger(this.getClass());
<!-- ########################################################################################### -->
import egovframework.com.cmm.util.EgovBasicLogger;
import egovframework.com.cmm.util.EgovResourceCloseHelper;
 
try {
    putOpt(name, c.getField(name).get(object));
} catch (Exception e) {
    /* forget about it */
    EgovBasicLogger.ignore("To JSON error", e);
}
 
try {
    SMEConfig.configSet(args[0]);
    receiver.readPropertyFile();
 
} catch (Exception ex) {
    LOGGER.error("DEBUG: {}", ex.getMessage());
    return;
}
<!-- ########################################################################################### -->
 
<!-- ########################################################################################### -->
스크립트
if (strVal == "" || strVal == "null" || strVal == null || strVal == "undefined" || strVal == undefined) {
}
 
<script type="text/javascript">
//<![CDATA[
$(document).ready(function() {
    $(document)
    .on("change", "#onChange_Search", function() {
            $("#pageIndex").val("1");
            $("#frm").attr("action", "<c:url value='/hrmadm/longedu/longeduCourseList.do'/>");
            $("#frm").submit();
    });
});
//]]>
</script>
 
function fn_onChange_pastPrsdCd(){
 
    var searchPastPrsdCd = $('#pastPrsdCombo').val();
    $('#searchPastPrsdCd').val($('#pastPrsdCombo').val());
    $('#prdcInttSeqNoCombo').html('');
 
    $.ajax({
          method: 'POST',
          url: '/red/redInttCombo-data.do',
          data: {searchPastPrsdCd:searchPastPrsdCd},
          dataType: 'json',
          cache: false
        })
 
        .done(function(res) {
            var devList = res.resultList;
 
            if(devList == null){
                alert('데이터 조회를 실패하였습니다.');
                //$('#clt_cmm_snsTy').val('');
                //$('.snsSelect li').removeClass('active');
                return false;
 
            }else{
 
                var html='', cssChecked='';
                html+= "<option value=''>전체 생산기관</option>\n";
                $.each(devList, function(index, dev) {
                    cssChecked='';
                    html+= "<option value="+dev.prdcInttSeqNo+">"+dev.prdcInttNm+"</option>\n";
                });
                $('#prdcInttSeqNoCombo').html(html);
                getDataList();
            }
        });
}
<!-- ########################################################################################### -->
JSP
 
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no">
 
<style>
    @charset "UTF-8";
</style>
 
<%@ page trimDirectiveWhitespaces="true" %>
<c:set var="ctxRt" value="${pageContext.request.contextPath }" />
<c:out value="${fn:replace(result.nttCn, crlf, '<br/>')}" escapeXml="false" /> 
<%@ page import="org.apache.log4j.*" %>
<% Logger logger = Logger.getLogger("header.jsp"); %>
<input type="hidden" name="pageIndex" value="<c:if test="${empty deptManageVO.pageIndex }">1</c:if>
<c:if test="${!empty deptManageVO.pageIndex }"><c:out value='${deptManageVO.pageIndex}'/></c:if>">
 
${(empty deptManageVO.pageIndex)?1:deptManageVO.pageIndex }
 
<input type="hidden" name="pageIndex" value="<c:if test="${empty deptManageVO.pageIndex }">1</c:if>
<c:if test="${!empty deptManageVO.pageIndex }"><c:out value='${deptManageVO.pageIndex}'/></c:if>">
 
$('#SELECTOR').css('color','red');
var test =$('.tab_type1 ul li.on a').attr("href");
 
Log찍기
Logger.debug.println(
<!-- ########################################################################################### -->
 
 
<!-- ########################################################################################### -->
 
$(document).ready(function(e){
    $(document)
    .on("change", "#searchCompanyId", function(e) {
        $("#pageIndex").val("1");
        var tmpTypeCds = "";
        $("input:checkbox[name='targetDivCodeList']").each(function() {
            if (this.checked) {
                tmpTypeCds += this.value + ",";
            }
        });
        tmpTypeCds = tmpTypeCds.substring(0, tmpTypeCds.lastIndexOf(','));
        $("#searchTargetDivCd").val(tmpTypeCds);
        $("#frm").attr("action", "<c:url value='/testList.do'/>");
        $("#frm").submit();
    })
});
$("#frm").submit().removeAttr("action");
document.listForm.action = "<c:url value='/service/edu/eduPlan/eduIntgPlanList.do'/>";
document.listForm.submit();
 
<form id="listForm" name="listForm" method="post">
    <input type="text" name="searchTargetDivCd" id="searchTargetDivCd" value="${eduPlanMVo.searchTargetDivCd}" />
    <input type="text" name="searchTargetDivCdArrayRd" id="searchTargetDivCdArrayRd" size="200px;" value="${eduPlanMVo.searchTargetDivCdArrayRd}" />
    <c:forEach items="${targetDivCoeList}" var="targetDivCodeList"  varStatus="status">
        <input type="checkbox" name="targetDivCodeList" id="targetDivCodeList" value="${targetDivCodeList.classCd}" />${targetDivCodeList.className}&nbsp;
    </c:forEach>
</form>
<!-- ########################################################################################### -->
메소드주석
shift + alt + j
 
<!-- ########################################################################################### -->
TEAM > SVN > Performance 에 들어가보니
Enable SVN statuses cache (disabling this will save lots of memory) Checked 상태
메모리도 많이 차지함
 
기본으로
Compute deep outgoing state 랑
Enable SVN statuses cache 가 설정되어 있음
Enable SVN statuses cache 를 빼려면
Compute deep outgoing state 을 먼저 해제해야함
여튼 두개다 해제
 
<!-- ########################################################################################### -->
 
<select name="udtAuthorGrpCd" id="udtAuthorGrpCd" class="sselect250" onchange="fn_text();">
    <option value="">권한그룹</option>
    <c:forEach var="detail" items="${authorGrpList}">
        <option value="<c:out value="${detail.authorGrpCd}" /><c:if test="${detail.authorGrpCd == dataVO.authorGrpCd}"> selected</c:if>><c:out value="${detail.authorGrpNm}" /></option>
    </c:forEach>
</select>
<!-- ########################################################################################### -->
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
 
private Log log = LogFactory.getLog(this.getClass());
protected static final Logger loggerFactory = LoggerFactory.getLogger(AdminLoginController.class);
protected static final Log logFactory = LogFactory.getLog(AdminLoginController.class);
 
web.xml
<filter>
    <filter-name>SetCharacterEncodingFilter</filter-name>
    <filter-class>filters.SetCharacterEncodingFilter</filter-class>
    <init-param>
        <param-name>encoding</param-name>
        <param-value>UTF-8</param-value>
    </init-param>
  </filter>
  <filter-mapping>
     <filter-name>SetCharacterEncodingFilter</filter-name>
     <url-pattern>/*</url-pattern>
  </filter-mapping>
<!-- ########################################################################################### -->
 
    <system-properties>
        <property name="java.net.preferIPv4Stack" value="true"/>
        <property name="org.apache.catalina.connector.URI_ENCODING" value="UTF-8"/>
        <property name="org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING" value="true"/>
    </system-properties>
<!-- ########################################################################################### -->
-Dlog4jdbc.drivers=com.tmax.tibero.jdbc.TbDriver
<!-- ########################################################################################### -->
COMTCCMMNDETAILCODE
공통상세코드
 
코드명
코드설명
사용여부
최초등록시점
최초등록자id
최초수정시점
최소수정자 id
순서
 
 
COMTCCMMNCODE
공통코드
 
코드id
코드id명
코드id설명
사용여부
분류코드
최초등록시점
최초등록자ID
최초수정시점
최소수정자ID
 
COMMENT ON TABLE COMTNPAGEPOPUPMANAGE IS '페이지별 팝업';
COMMENT ON COLUMN COMTNMENUINFO.MENU_NM IS '메뉴명';
 
 
그로 이클립스를 종료한 후에 워크스페이스 디렉토리에 있는 두개의 파일을 삭제하면 된다.
워크스페이스/.metadata/.plugins/org.eclipse.core.runtime/.settings 디렉토리
(1) org.eclipse.wst.server.core.prefs
(2) org.eclipse.jst.server.tomcat.core.prefs
 
 
<%--             <c:import url="/decorators/mns/footer_conversation.jsp"></c:import> --%>
 
-Dhttps.protocols=TLSv1.2
-Djdk.tls.client.protocols=TLSv1.2
 
-Dlog4jdbc.drivers="oracle.jdbc.driver.OracleDriver"
-Dlog4jdbc.drivers="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"
 
-XX:MaxPermSize=512m -Xms2048m -Xmx3072m
-javaagent:D:\eGovFrameDev-3.6.0-64bit_hrm\springloaded\springloaded-1.2.7.RELEASE.jar -noverify
 
[root@agriedu1 ~]# java -version
java version "1.7.0_181"
OpenJDK Runtime Environment (rhel-2.6.14.10.el6-x86_64 u181-b00)
OpenJDK 64-Bit Server VM (build 24.181-b00, mixed mode)
 
[root@agriedu1 ~]# uname -a
Linux agriedu1 2.6.32-754.10.1.el6.x86_64 #1 SMP Tue Jan 15 17:07:28 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
 
[root@agriedu1 ~]# uname -r
2.6.32-754.10.1.el6.x86_64
 
[root@agrieduweb1 ~]# uname -a
Linux agrieduweb1 2.6.32-754.el6.x86_64 #1 SMP Tue Jun 19 21:26:04 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
 
[root@agrieduweb1 ~]# uname -r
2.6.32-754.el6.x86_64
 
CORE    10.2.0.3.0    Production
 
<Context crossContext="true" docBase="hrmAgri" path="/hrm" reloadable="false" sessionCookiePath="/" source="org.eclipse.jst.jee.server:hrmAgri"/>
<Context crossContext="true" docBase="newAgri" path="/"    reloadable="false" sessionCookiePath="/" source="org.eclipse.jst.jee.server:newAgri"/>
 
<script type="text/javascript">
//<![CDATA[
$(document).ready(function(){
    $(document)
    .on("click", "#click_search", function(e) {
        $("#pageIndex").val(1);
        $("#frm").attr("action", "<c:url value='/hrmadm/longedu/longeduCourseList.do'/>");
        $("#frm").submit();
    });
});
//]]>
</script>
 
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE' ORDER BY CREATED DESC;
/usr/local/tomcat7/bin
</body>
</html>

@