Shop [ Setting ]

MYDBCP Setting

• was 폴더 -> conf -> context.xml

<!-- ======= MyDBCP Setting Start ======= -->
<Resource name="jdbc/myoracle" auth="Container"
          type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
          url="jdbc:oracle:thin:@127.0.0.1:1521:xe"
          username="@@user" password="@@" maxTotal="20" maxIdle="20"
          maxWaitMillis="10000"/>
<!-- ======= MyDBCP Setting End ======= -->

• xml

<!-- ========= MyDBCP Setting Start  ===========  -->
<resource-ref>
 	<description>Oracle Datasource example</description>
 	<res-ref-name>jdbc/myoracle</res-ref-name>
 	<res-type>javax.sql.DataSource</res-type>
 	<res-auth>Container</res-auth>
</resource-ref>
<!-- ========= MyDBCP Setting End  ===========  -->

---

Library

• ojdbc8.jar

• Tomcat 10
  -> jakarta.servlet.jsp.jstl-2.0.0.jar
  -> jakarta.servlet.jsp.jstl-api-2.0.0.jar

• Tomcat 9
  다운 : https://tomcat.apache.org/download-taglibs.cgi
  -> taglib-standard-impl-1.2.5.jar
  -> taglib-standard-jstlel-1.2.5.jar
  -> taglib-standard-spec-1.2.5.jar

• AES256 ( 암호화 - 복호화 )
  다운 : https://mvnrepository.com/artifact/commons-codec/commons-codec
  1.15 -> jar 다운
  -> commons-codec-1.15.jar

• JSON
  다운 : https://mvnrepository.com -> json 검색
  json in java -> 20231013 - bundle 다운
  json.simple -> 1.1.1 - bundle 다운
  -> json-20231013.jar
  -> json-simple-1.1.1.jar

---

Bootstrap

• webapp 에 다운받은 폴더 넣기
  -> bootstrap-4.6.2-dist

jQuery

• webapp -> js -> 압축한 min 파일 넣기
  -> jquery-3.7.1.min.js

jQuery UI

• webapp -> js 에 다운받은 폴더 넣기
  -> jquery-ui-1.13.1.custom

---

Filter

• Encoding 방법

@WebFilter("/*")
public class 클래스명 extends HttpFilter implements Filter{
	...
}

• xml 선언 방법
  -> xml

<filter>
    <display-name>filter</display-name>
    <filter-name>filter</filter-name>
    <filter-class>filter</filter-class>
</filter>
<filter-mapping>
    <filter-name>filter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

-> Java Resources -> class

public class 클래스명 extends HttpFilter implements Filter{
	...
    // Tomcat9의 경우 한글 깨지지 않게하기
    request.setCharacterEncoding("UTF-8");
}

진행중..