===숫자관련
1. CEILING(숫자) : 올림
2. FLOOR(숫자) : 버림
3. ROUND(숫자, 자릿수) : 소수점이하자릿수에서 반올림(자릿수는 양수, 0, 음수 값을 가질 수 있음)

===문자관련
1. CONCAT('문자열','문자열','문자열'..) : 문자열들을 이어줌
2. REPLACE('문자열','기존문자열','바뀔문자열') : 문자열 중 기존문자열을 바뀔 문자열로 바꾼다
3. INSTR('문자열','찾는문자열') : 문자열 중 찾는 문자열의 위치값을 출력
4. LEFT('문자열', 갯수) : 문자열 중 왼쪽에서 갯수만큼 추출
5. RIGHT('문자열', 갯수) : 문자열 중 오른쪽에서 갯수만큼 추출
6. MID('문자열', 시작위치, 갯수) : 문자열 중 시작위치부터 갯수만큼 추출
6. SUBSTRING('문자열',시작위치,갯수) : 문자열 중 시작위치부터 갯수만큼 출력
7.LTRIM('문자열') : 문자열 중 왼쪽의 공백을 없앤다.
8.RTRIM('문자열') : 문자열 중 오른쪽의 공백을 없앤다.
9. TRIM('문자열') : 양쪽 모두의 공백을 없앤다
10. LCASE('문자열') or LOWER('문자열') : 소문자로 바꾼다
11. UCASE('문자열') or UPPER('문자열') : 대문자로 바꾼다.

===논리관련
1. IF(논리식, 참일때 값, 거짓일때 값) : 논리식이 참이면 참일때 값을 출력 논리식이 거짓이면 거짓일때 출력
2. IFNULL(값1, 값2) : 값1이 NULL이면 값2로 대치하고 그렇지 않으면 값1을 출력

===집계함수
1. COUNT(필드명) : NULL이 아닌 레코드 수를 센다(카운팅한다)
2. SUM(필드명) : 필드명의 함계를 구한다
3. AVG(필드명) : 필드명의 평균값을 구한다
4. MAX(필드명) : 최대값을 구한다
5. MIN(필드명) : 최소값을 구한다

===날짜관련
1. NOW() or SYSDATE() or CURRENT_TIMESTAMP() : 현재 날짜와 시간 출력
2. CURDATE() or CURRENT_DATE() : 현재날짜 출력
3. CURTIME() or CURRENT_TIME() : 현재시간 출력
4. DATE_ADD(날짜, INTERVAL 기준값) : 날짜에서 기준값 만큼 더한다
***기준값종류: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
5. YEAR(날짜) : 날짜 연도 출력
6. MONTH(날짜) : 날짜 월 출력
7. MONTHNAME(날짜) : 날짜의 월을 영어로 출력
8. DAYNAME(날짜) : 날짜의 요일을 영어로 출력
9. DAYOFMONTH(날짜) : 날짜의 월별 일자 출력
10. DAYOFWEEK(날짜) : 날짜의 주별 일자 출력(월요일:0, 화요일:1 ...일요일:6)
10. WEEKDAY(날짜) : 날짜의 주별 일자 출력(월요일:0, 화요일:1....일요일:6)
11.DAYOFYEAR(날짜) : 일년을 기준으로 한 날짜까지의 날수
12.WEEK(날짜) : 일년 중 몇번째 주
13. FROM_DAYS(날수) : 00년 00월 00일부터 날수 경과만큼 경과한 날의 날짜 출력
14. TO_DAYS(날짜) : 00년 00월 00일부터 날짜까지의 일자 수 출력
15. DATE_FORMAT(날짜, '형식') : 날짜를 형식에 맞게 출력

<table class="table_tp1">
            <caption class="hide-caption">list</caption>
            <colgroup>
                     <col width="15%">
                     <col width="15%">
                     <col width="15%">
                     <col width="*">
           </colgroup>
           <thead>
                   <tr>
                          <th scope="col"><span>AAAA</span></th>
                          <th scope="col"><span>AAAA</span></th>
                          <th scope="col"><span>AAAA</span></th>
                          <th scope="col"><span>AAAA</span></th>
                 </tr>
             </thead>
             <tbody>
                   <c:choose>
                        <c:when test="${null != list && !empty list}">
                                 <c:forEach var="list" items="${list}" varStatus="lineIndex">
                       <tr<c:if test="${lineIndex.count % 2 == 0}">class="line_c"</c:if>>
                              <td class="al_c2">${list.kkk}</td>
                                <td class="al_c"><a href="#" onclick="detail('${list.kkk}')">kkkk</a></td>
                                 <td class="al_c">${list.kkk}</td>
                                 <td class="al_c">${list.kkk}</td>
                       </tr>
                                 </c:forEach>
                        </c:when>
                        <c:otherwise>
                              <tr>
                                     <td colspan="4" class="al_c2">No results were found for your search.</td>
                              </tr>
                         </c:otherwise>
                   </c:choose>
            </tbody>
        </table>                       

===URL관련
location.href="<c:url value='/xxx/aaaa.do' />";
url : "<c:url value='/xxx/aaaa.do' />",
<span><a href="<c:url value='/aaaa/ggg.do' />" targe='_blank'>dkfkdkj</a>
document.searchForm.action ="<c:url value='/xxx/aaaa.do' />"

<c:url value="/ttet/tete.do">
   <c:param name="keyword" value="${searchTerm}" />
   <c:param name="keyword2" value="${searchTerm2}" />
</c:url>

===조건문관련
<c:if test="${null != xxxx && !empty xxxx}">
       <c:forEach var="xxxx" items="${xxxx}">
            ${xxxx.kkkk}
       </c:forEach>
</c:if>
<option value="kkk" <c:if test="${type} eq 'kkkok'}">selected</c:if>>History</option>


===조건문관련2
<c:choose>
    <c:when test="${null != pppp && !empty pppp}">
     </c:when>
     <c:when test="${null != pppp && !empty pppp}">
     </c:when>
     <c:when test="${null != pppp && !empty pppp}">
     </c:when>
     <c:otherwise>
     </c:otherwise>
</c:choose>

===반복문
<c:forEach var="xxxx" items="${xxxx}" varStatus="lineIndex">
     <!--반복할 내용 -->
</c:forEach>

lineIndex.current:현재 순환중인 아이템을 가져옵니다
lineIndex.index:현재 순환중인 아이템의 인덱스(0베이스)를 가져옵니다
lineIndex.count:현재 순환중인 아이템의 인덱스(1베이스)를 가져옵니다
lineIndex.first:현재 순환중인 아이템이 첫번째 아이템인지 여부를 확인합니다(booelan)
lineIndex.last:현재 순환중인 아이템이 마지막 아이템인지 여부를 확인합니다(boolean)
lineIndex.begin:forEach에서 지정할 수 있는 begin값을 가져옵니다
lineIndex.end:forEach에서 지정할 수 있는 end값을 가져옵니다
lineIndex.step:forEach에서 지정할 수 있는 step값을 가져옵니다

===세팅관련
<c:set var="sum" value="0" /><!-- sum변수에 0을 세팅 -->
<c:set var="sum" value="${sum+statisticsList.totalCount}" /><!--sum에 totalCount값을 더한후 sum변수에 세팅 -->


===출력관련
<c:out value="${now}" />
<c:out value="${fn:replace(list.userID, '||', '-')}" />


===문자열관련
<c:if test="${fn:contains(name, "searchString")}">
<c:if test="${fn:endWith(filename, ".txt")}">
<c:if test="${fn:indexOf(name, "-")}">
<c:if test="${fn:length(name)}">
<c:if test="${fn:startWith(filename, ".txt")}">
<c:if test="${fn:subString(filename, 6, 0)}">
<c:if test="${fn:subStringAfter(filename, "-")}">
<c:if test="${fn:subStringBefore(filename, "-")}">


===import관련
<c:import url="ftp://ftp.example.com/pacakge/index.html" />

<c:import url="/tkkdj/ted.do">
   <c:param name="keyword" value="${searchTerm}" />
</c:import>


===리다이렉트
<c:redirect>
URL이 변경되면서 페이지 이동

<a href="#" class="com_s_excel" onclick="exportExcel();"><span>Export to Excel</span></a>

function exportExcel(){
        $("searchForm").attr("action","<c:url value='/exportExcel.do' />").submit();
}

@RequestMapping(value="/exportExcel", method= RequestMethod.POST)
public ModelAndView exportExcel(HttpServletRequest request, HttpServletResponse response, @ModelAttribute SearchVo searchVo){
        ModelAndView view = new ModelAndView();
        
         view.addObject("contents", ServiceObj.getExportExcel(searchVo);
          view.setViewName("/exportExcel");

        return view;
}




====exportExcel.jsp
<%@ page language="java" contentType="application/vnd.ms-excel; charset=utf-8" pageEncoding="utf-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<%
       response.setHeader("Content-Type", "application/vnd.ms-xls");
       response.setHeader("Content-Disposition", "inline; filename=ExportList.xls");
%>

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
         <head>
                  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
                    <style>td { mso-number-format:\@; } </style>
          </head>
<body>
         <table style="text-align:center; font-weight:normal; background:#fafafa; color:#333; font-size:12px; border:1px solid #CCC;">
           <caption class="hide-caption">List</caption>
           <thead>
                  <tr style="border:1px solid #CCC; color:#555">
                          <th scope="col"><span class="sort" id="id">ID</span></th>
                           <th scope="col"><span class="sort" id="id">ID</span></th>
                    </tr>
              </thead>
              <tbody>
                      <c:choose>
                               <c:when test="${null != contents && !empty contents}">
                      <c:forEach var="contents" items="${contents}" varStatus="lineIndex">
                           <tr style="padding:8px; line-height:16px; border:1px solid #CCC; color:#555; font-size:12px; vertical-align:middle; word-break:break-all;">
                              <td class="al_c">${contents.code}</td>
<td class="al_c">${contents.name}</td>
<td class="al_c">${contents.desc}</td>
<td class="al_c">${contents.code1}</td>
<td class="al_c">${contents.code2}</td>
<td class="al_c">${contents.code2}</td>
                                  <tr>
                               </c:forEach>
                           </c:when>
                       <c:otherwise>
                       </c:otherwise>
                     </c:choose>
                   </tbody>
                 </table>
            </body>
         </html>

<%@ language="java" page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="string" uri="http://jakarta.apache.org/taglibs/string-1.1" %>

<%@ page import="java.util.Locale" %>
<%@ page import="javax.servlet.jsp.jstl.core.Config" %>

<script>

$(function(){
         $(document).ready(function(){
         
         });

});


function XXX(){
}

</script>

<!DOCTYPE html>
<html lang="en">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
       <meta name="viewport" content="width=device-width, initial-scale=1">
      
       <title>html5</title>
      
       <link rel="stylesheet" type="text/css" href="css/style.css?v=1.0">
       <link rel="shortcut icon" type="image/x-icon" href="images/favicon.png" />
        
       

</head>


<body>
       <header>
            <nav>
                 <ul>
                     <li></li>
                     <li></li>
                 </ul>
            </nav>
      <header>

       <!--contents1-->
       <section>
            <article>
                 <header>
                       <h2></h2>
                       <p></p>
                 </header>
                  <p>
              </article>
       </section>

       <aside>
                <h2></h2>
                <p>
       </aside>

       <footer>
               <p>
       </footer>


      <script type="text/javascript" src="js/scripts.js"></script>
</body>
</html>




https://www.webcodegeeks.com/html5/html5-page-structure-example/

<form name="searchForm" id="searchForm" method="post">

<select name="statusCode" id="statusCode" style="width:208px;" class="select">
         <option value="">ALL</option>
         <option value="R">R</option>
         <option value="R">R</option>
         <option value="R">R</option>
         <option value="R">R</option>
</select>


<select name="status" id="status">
              <option value="">ALL</option>
              <c:if test="${null != stsCdList && !empty stsCdList}">
                     <c:forEach var="stsCdList" items="${stsCdList}">
                           <option value="${stsCdList.code}">${stsCdList.codeName}</option>
                     </c:forEach>
              </c:if>
</select>



<select id="useType" name="useType" style="width:200px;">
      <c:if test="${null != useTpCdList && !empty useTpCdList}">
             <c:forEach var="useTpCdList" items="${useTpCdList}">
                     <c:if test="${useTpCdList.code != 'M' && useTpCdList.code != 'P'}">
                             <option value="${useTpCdList.code}">${useTpCdList.codeName}</option>
                      </c:if>
             </c:forEach>
</select>

<select class="select" name="historySelect" id="historySelect" onchange="showView()" style="width:150px;height:23px;">
           <option value="kkkk" <c:if test="${historyType eq 'kkkk'}">selected</c:if>>History</option>
           <option value="pppp" <c:if test="${historyType eq 'pppp'}">selected</c:if>>History</option>
</select>


</form>


function showView(){
      var selectVal = $('#historySelect').val();
      if(selectVal == "kkkk") {
                $.ajax({
                         url : "<c:url value='/showView.do' />",
                         type: 'post',
                         beforSend : function(xhr) {
                        xhr.setRequestHeader("AJAX","true");
                        },
                        data : {
                             key : "${}",
                             key2 : "D"
                        },
                        contentType : "application/x-www-form-urlencoded; charset=UTF-8",
                        success : function(data) {
                           $('#dkfkjf').val();
                           $('#dfkjfk').html(data);
                          },
                         error : function(xhr, status, err){
                  if(xhr.status==403) {
                            location.href="<c:url value='/login/intro.do' />";
                         }
                   }

             });
      }
}

@RequestMapping(value = "/showView", method = {RequestMethod.POST})
public ModelAndView showView(HttpServletRequest request, HttpServletResponse response){
           ModelAndView view = new ModelAndView();

           int pageNo = ParamUtil.param(request,"pageNo",null) == null? 1: Integer.parseInt(ParamUtil.param(request,"pageNo", null));

view.addObject("key", keyObject);
view.setViewName("kkkk/kkkk");

return view;

}

  LoggerContext context = (LoggerContext) LoggerFactory.getILoggerFactory();
      JoranConfigurator jc = new JoranConfigurator();
       jc.setContext(context);
  context.reset ();//우리가 설정한 logback 설정만 적용된다
      
          jc.doConfigure(new ClassPathResource("logback"+System.getProperty("server.type")+".xml").getInputStream());

<dependency>
<groupId>com.amazonaws</groupId>
<artifactId>aws-java-sdk-s3</artifactId>
<version>1.11.0</version>
</dependency>


@Configuration
public class AWSS3Util{

        @Value("${s3.accessKey}")
        private String accessKey;
   
        @Value("${s3.secretKey}")
        private String secretKey;

        @Value("${s3.region}")
        private String region;


        @Bean
         public AmazonS3 amazonS3Client(){
                String tmpAccessKey = "";
                String tmpSecretKey="";

                 if("Local".equals(System.getProperty("server.type"))){
                       tmpAccessKey = accessKey;
                       tmpSecretKey = secretKey;
                 }else{
                      tmpAccessKey = AESCipherUtil.decrypt(accessKey);
                     tmpSecretKey = AESCipherUtil.decrypt(secretKey);
                  }
         
                  AWSCredentials credentials = new BasicAWSCredentials(tmpAccessKey, tmpSecretKey);

                AmazonS3 s3Client = null;
 
                if("Local".equals(System.getProperty("server.type"))){
                     ClientConfiguration clientCfg = new ClientConfiguration();
                     clientCfg.setProtocol(Protocol.HTTP);
                      clientCfg.setProxyHost("");
                     clientCfg.setProxyPort();
                     s3Client = new AmazonS3Client(credentials, clientCfg);

                 }else{
                        s3Client = new AmazonS3Client(credentials);
                  }

                  Region regionCode = null;
      
                  switch (region) {
                        case="EU_WEST_1":
                                   regionCode = Region.getRegion(Regions.EU_WEST_1);
                                   break;
                       case="AP_NORTHEAST_1":
                         regionCode = Region.getRegion(Regions.AP_NORTHEST_1);
                        break;
                  }

                  s3Client.setRegion(regionCode);

               return s3Client;

       }

}