java, c# , linux, program devloper: JSP, JAVA 카테고리 글 목록
http://blog1.phps.kr/
blog.visualp.com
2021-05-29T01:03:41+09:00
Textcube 1.10.7 : Tempo primo
intelij svn 느림
java, tomcat, c#
http://blog1.phps.kr/762
2020-08-04T16:22:07+09:00
2020-08-04T16:22:03+09:00
[원문] <a href="https://atoz-develop.tistory.com/entry/IntelliJ-VCSGit-%EC%82%AC%EC%9A%A9-%EC%8B%9C-%EB%8A%90%EB%A6%BC-%EB%A9%88%EC%B6%A4-%ED%98%84%EC%83%81-%EC%A1%B0%EC%B9%98-%EB%B0%A9%EB%B2%95">https://atoz-develop.tistory.com/entry/IntelliJ-VCSGit-%EC%82%AC%EC%9A%A9-%EC%8B%9C-%EB%8A%90%EB%A6%BC-%EB%A9%88%EC%B6%A4-%ED%98%84%EC%83%81-%EC%A1%B0%EC%B9%98-%EB%B0%A9%EB%B2%95<br /><br /></a>
<h2 style="margin: 29px 0px 22px; padding: 0px; clear: both; line-height: 1.5; color: #000000; font-weight: normal; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif;" data-ke-size="size26">1. Invalidate Caches and Restart</h2>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<figure class="imageblock alignCenter" style="margin: 0px auto 20px; max-width: 100%; clear: both; padding: 0px; display: table; position: relative; text-align: center; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; font-size: 16px;" data-origin-width="0" data-origin-height="0"><span style="cursor: pointer;" data-url="https://blog.kakaocdn.net/dn/bztbgp/btqCLcJttA3/GvssjzovmoXEZU51enNsN1/img.png" data-lightbox="lightbox" data-alt=""><img src="https://blog.kakaocdn.net/dn/bztbgp/btqCLcJttA3/GvssjzovmoXEZU51enNsN1/img.png" style="border: none; vertical-align: top; display: inline-block; width: 437px; margin: 0px;" data-origin-width="0" data-origin-height="0" /></span></figure>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;">File - Invalidate Caches / Restart... 클릭</p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<figure class="imageblock alignCenter" style="margin: 0px auto 20px; max-width: 100%; clear: both; padding: 0px; display: table; position: relative; text-align: center; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; font-size: 16px;" data-origin-width="0" data-origin-height="0"><span style="cursor: pointer;" data-url="https://blog.kakaocdn.net/dn/w3Pez/btqCLeN4dzf/e2vGd3p3ZTmZytXdCngro1/img.png" data-lightbox="lightbox" data-alt=""><img src="https://blog.kakaocdn.net/dn/w3Pez/btqCLeN4dzf/e2vGd3p3ZTmZytXdCngro1/img.png" style="border: none; vertical-align: top; display: inline-block; width: 686px; margin: 0px;" data-origin-width="0" data-origin-height="0" /></span></figure>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;">Invalidate and Restart 클릭</p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<h2 style="margin: 29px 0px 22px; padding: 0px; clear: both; line-height: 1.5; color: #000000; font-weight: normal; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif;" data-ke-size="size26">2. VCS - Refresh File Status</h2>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<figure class="imageblock alignCenter" style="margin: 0px auto 20px; max-width: 100%; clear: both; padding: 0px; display: table; position: relative; text-align: center; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; font-size: 16px;" data-origin-width="0" data-origin-height="0"><span style="cursor: pointer;" data-url="https://blog.kakaocdn.net/dn/JZwFB/btqCKBbD7EU/cARFsaaB8e1pbuO3tfhXGk/img.png" data-lightbox="lightbox" data-alt=""><img src="https://blog.kakaocdn.net/dn/JZwFB/btqCKBbD7EU/cARFsaaB8e1pbuO3tfhXGk/img.png" style="border: none; vertical-align: top; display: inline-block; width: 363px; margin: 0px;" data-origin-width="0" data-origin-height="0" /></span></figure>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;">프로젝트 루트를 선택한 상태에서 VCS - Refresh File Status를 클릭한다.</p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<h2 style="margin: 29px 0px 22px; padding: 0px; clear: both; line-height: 1.5; color: #000000; font-weight: normal; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif;" data-ke-size="size26">3. IntelliJ VCS Log 삭제</h2>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;">아래 디렉토리 하위의 파일들을 삭제한다.</p>
<blockquote style="font-size: 16px; line-height: 18pt; color: #666666; margin: 0px 0px 40px; padding: 21px 25px 20px; border: 1px solid #dddddd; background: #fcfcfc; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif;" data-ke-style="style3">C:\Users\{사용자이름}\.IntelliJIdea2019.3(버전에 따라 상이함)\system\vcs-log</blockquote>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p>
<h2 style="margin: 29px 0px 22px; padding: 0px; clear: both; line-height: 1.5; color: #000000; font-weight: normal; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif;" data-ke-size="size26">4. [추가] Disable Show Unversioned Files</h2>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;">커밋 창에서 unversioned 파일을 굳이 보이지 않게 함으로써 인텔리J에서 커밋 속도를 향상시킬 수 있다.</p>
<p style="word-break: break-all; font-size: 0.9375em; line-height: 2; color: #555555; font-family: AppleSDGothicNeo, 'Noto Sans KR', sans-serif; padding: 0px !important 0px 0px !important 0px; margin: 0px !important 0px 32px 0px;"> </p><p><strong><a href="http://blog1.phps.kr/762?commentInput=true#entry762WriteComment">댓글 쓰기</a></strong></p>
tomcat8 cookie 관련
java, tomcat, c#
http://blog1.phps.kr/759
2020-04-06T10:02:22+09:00
2020-04-06T10:02:20+09:00
[참고]https://jistol.github.io/java/2017/08/30/tomcat8-invalid-domain/<br />--------------------------<br /><span class="go">java.lang.IllegalArgumentException: An invalid domain [.<a class="vglnk" href="http://xxxx.com/" rel="nofollow">xxxx.com</a>] was specified for this cookie<br /></span>과 같이 서브도메인 쿠키 생성시 아래와 같이 처리 해줘야 함.<br /><br />tomcat context.xml에 다음과 같이 추가<br /><span class="nt"><CookieProcessor</span> <span class="na">className=</span><span class="s">"org.apache.tomcat.util.http.LegacyCookieProcessor"</span><span class="nt">/><br /><br /></span>spring boot embead 일경우<br /><span class="nd">@Bean</span><br /><span class="kd">public</span> <span class="nc">EmbeddedServletContainerCustomizer</span> <span class="nf">tomcatCustomizer</span><span class="o">()</span> <span class="o">{</span><br /> <span class="k">return</span> <span class="n">container</span> <span class="o">-></span> <span class="o">{</span><br /> <span class="k">if</span> <span class="o">(</span><span class="n">container</span> <span class="k">instanceof</span> <span class="nc">TomcatEmbeddedServletContainerFactory</span><span class="o">)</span> <span class="o">{</span><br /> <span class="nc">TomcatEmbeddedServletContainerFactory</span> <span class="n">tomcat</span> <span class="o">=</span> <span class="o">(</span><span class="nc">TomcatEmbeddedServletContainerFactory</span><span class="o">)</span> <span class="n">container</span><span class="o">;</span><br /> <span class="n">tomcat</span><span class="o">.</span><span class="na">addContextCustomizers</span><span class="o">(</span><span class="n">context</span> <span class="o">-></span> <span class="n">context</span><span class="o">.</span><span class="na">setCookieProcessor</span><span class="o">(</span><span class="k">new</span> <span class="nc">LegacyCookieProcessor</span><span class="o">()));</span><br /> <span class="o">}</span><br /> <span class="o">};</span><br /><span class="o">}</span><br /><br /><p><strong><a href="http://blog1.phps.kr/759?commentInput=true#entry759WriteComment">댓글 쓰기</a></strong></p>
lucy XSS filter , spring xss filter 적용 XSS필터 적용
java, tomcat, c#
http://blog1.phps.kr/753
2019-01-30T18:55:03+09:00
2019-01-30T18:55:00+09:00
[참고]https://github.com/naver/lucy-xss-servlet-filter<br />pom.xml 추가<br />
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #e8bf6a;"><dependency><br /></span><span style="color: #e8bf6a;"> <groupId></span>com.navercorp.lucy<span style="color: #e8bf6a;"></groupId><br /></span><span style="color: #e8bf6a;"> <artifactId></span>lucy-xss-servlet<span style="color: #e8bf6a;"></artifactId><br /></span><span style="color: #e8bf6a;"> <version></span>2.0.0<span style="color: #e8bf6a;"></version><br /></span><span style="color: #e8bf6a;"></dependency> <br /></span></pre>
<p> </p>
<p><span style="color: #000000;">[web.xml]</span><br /><span style="color: #000000;">filter 순서 UTF-8 인코딩 필터가 있다면 그 다음으로</span><br /><span style="color: #000000;">multipartFilter 추가 후 XSS filter 추가 한다.</span><br /><span style="color: #000000;">이유) 게시판 파일 업로드 enctype="multipart/form-data" </span><br /><span style="color: #000000;">일떄 multipartFilter 필터 타지 않을 수 있음 그래서 필터 순서를 맞춰줘야 함</span><br /><br /></p>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #808080;"><!-- multipartFilter --><br /></span><span style="color: #e8bf6a;"><filter><br /></span><span style="color: #e8bf6a;"> <filter-name></span>multipartFilter<span style="color: #e8bf6a;"></filter-name><br /></span><span style="color: #e8bf6a;"> <filter-class><br /></span> org.springframework.web.multipart.support.MultipartFilter<br /> <span style="color: #e8bf6a;"></filter-class><br /></span><span style="color: #e8bf6a;"></filter><br /></span><span style="color: #e8bf6a;"><br /></span><span style="color: #e8bf6a;"><filter-mapping><br /></span><span style="color: #e8bf6a;"> <filter-name></span>multipartFilter<span style="color: #e8bf6a;"></filter-name><br /></span><span style="color: #e8bf6a;"> <url-pattern></span>/*<span style="color: #e8bf6a;"></url-pattern><br /></span><span style="color: #e8bf6a;"></filter-mapping><br /></span><span style="color: #e8bf6a;"><br /></span><span style="color: #808080;"><!-- xss filter --><br /></span><span style="color: #e8bf6a;"><filter><br /></span><span style="color: #e8bf6a;"> <filter-name></span>xssEscapeServletFilter<span style="color: #e8bf6a;"></filter-name><br /></span><span style="color: #e8bf6a;"> <filter-class></span>com.navercorp.lucy.security.xss.servletfilter.XssEscapeServletFilter<span style="color: #e8bf6a;"></filter-class><br /></span><span style="color: #e8bf6a;"></filter><br /></span><span style="color: #e8bf6a;"><filter-mapping><br /></span><span style="color: #e8bf6a;"> <filter-name></span>xssEscapeServletFilter<span style="color: #e8bf6a;"></filter-name><br /></span><span style="color: #e8bf6a;"> <url-pattern></span>/*<span style="color: #e8bf6a;"></url-pattern><br /></span><span style="color: #e8bf6a;"></filter-mapping></span></pre>
<p><span style="color: #000000;">[root-context.xml]에 </span><span style="color: #808080;"><span style="color: #000000;">multipartResolver bean설정시 아이디를</span> <br />multipartResolver --> <span style="color: #6a8759;">filterMultipartResolver 변경 해줌<br />그래야 xss 필터가 정상적으로 동작</span></span></p>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #808080;"><!-- multipartResolver --><br /></span><span style="color: #808080;"><!--<beans:bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" />--><br /></span><span style="color: #e8bf6a;"><</span><span style="color: #9876aa;">beans</span><span style="color: #e8bf6a;">:bean </span><span style="color: #bababa;">id</span><span style="color: #6a8759;">="filterMultipartResolver" </span><span style="color: #bababa;">class</span><span style="color: #6a8759;">="org.springframework.web.multipart.commons.CommonsMultipartResolver" </span><span style="color: #e8bf6a;">/><br /><br /></span></pre><p><strong><a href="http://blog1.phps.kr/753?commentInput=true#entry753WriteComment">댓글 쓰기</a></strong></p>
spring4 - 스케줄러 @Scheduled schedule configuration
java, tomcat, c#
http://blog1.phps.kr/752
2019-01-28T11:21:26+09:00
2019-01-28T11:17:05+09:00
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;">xml설정</pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #bababa;">xmlns:</span><span style="color: #9876aa;">task</span><span style="color: #6a8759;">="http://www.springframework.org/schema/task"</span></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #9876aa;">xsi</span><span style="color: #bababa;">:</span><span style="color: #bababa; background-color: #344134;">schemaLocation 부분에 <br /></span></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #6a8759;">http://www.springframework.org/schema/task<br /></span><span style="color: #6a8759; background-color: #344134;">http://www.springframework.org/schema/task/spring-task-4.0.xsd<br /><br />추가<br /></span></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #e8bf6a;"><</span><span style="color: #9876aa;">task</span><span style="color: #e8bf6a;">:annotation-driven /> 추가<br /><br /></span></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"></pre>
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><br />==================================================<br /><br />1초마다 한번식 실행<br /><br /><span style="color: #bbb529;">@Service<br /></span><span style="color: #cc7832;">public class </span>VisitorConfig {<br /> <span style="color: #bbb529;">@Scheduled</span>(<span style="color: #d0d0ff;">fixedDelay </span>= <span style="color: #6897bb;">1000</span>)<br /> <span style="color: #cc7832;">public void </span><span style="color: #ffc66d;">visitor</span>(){<br /> System.<span style="color: #9876aa; font-style: italic;">out</span>.println(<span style="color: #6a8759;">"test:"</span>)<span style="color: #cc7832;">;<br /></span> }<br />}</pre><p><strong><a href="http://blog1.phps.kr/752?commentInput=true#entry752WriteComment">댓글 쓰기</a></strong></p>
spring security 현제 접속한 회원 구하기 listing access member now
java, tomcat, c#
http://blog1.phps.kr/751
2019-01-14T12:09:34+09:00
2019-01-14T12:08:17+09:00
[원문]<br />http://krams915.blogspot.com/2010/12/spring-security-mvc-querying.html
@Resource(name="sessionRegistry")
private SessionRegistryImpl sessionRegistry;
for (Object username: sessionRegistry.getAllPrincipals()) {
logger.debug(username);
}
<p><strong><a href="http://blog1.phps.kr/751?commentInput=true#entry751WriteComment">댓글 쓰기</a></strong></p>
tomcat manager 설정
java, tomcat, c#
http://blog1.phps.kr/743
2018-04-09T14:28:12+09:00
2018-04-09T14:28:11+09:00
<span style="font-family: Courier New;"><br />tomcat8</span><code class="shell plain">/webapp/manager/META-INF/context</code><code class="shell plain">.xml<br /><br /></code>
<div class="line number19 index18 alt2"><code class="xml comments"><!--Valve className="org.apache.catalina.valves.RemoteAddrValve"</code></div>
<div class="line number20 index19 alt1"><code class="xml spaces"> </code><code class="xml comments">allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1" /--></code></div>
<span style="font-family: Courier New;">주석 처리가 되어 있다면 <br />주석을 해제하여 외부에서 접근 하는 것을 막을 수 있다.<br /><br /><br /></span><p><strong><a href="http://blog1.phps.kr/743?commentInput=true#entry743WriteComment">댓글 쓰기</a></strong></p>
mariadb 월중 주차 구하기, mariadb week of month
java, tomcat, c#
http://blog1.phps.kr/737
2018-02-23T15:17:25+09:00
2018-02-23T15:17:23+09:00
select FLOOR((DayOfMonth(20180221)-1)/7)+1<br />or<br /><br />select FLOOR((DayOfMonth(now())-1)/7)+1<p><strong><a href="http://blog1.phps.kr/737?commentInput=true#entry737WriteComment">댓글 쓰기</a></strong></p>
oracle 날짜 형식체크 , oracle vaildate date function
java, tomcat, c#
http://blog1.phps.kr/736
2018-02-21T10:58:18+09:00
2018-02-21T10:58:15+09:00
<div style="padding: 10px; background-color: #e4e4e4;">
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">CREATE OR REPLACE FUNCTION <strong>is_number</strong>(v_str_number IN varchar2) </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">RETURN NUMBER </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">IS<span style="mso-spacerun: yes;"> </span>/* </span><span style="font-family: 굴림체; font-size: 9pt;">데이터가<span lang="EN-US"> number </span>형인지 검사하는 함수임<span lang="EN-US">. 1 </span>이 나오면<span lang="EN-US"> NUMBER </span>형임<span lang="EN-US"> */ </span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>V_NUM NUMBER;</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">BEGIN</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>V_NUM := TO_NUMBER(v_str_number);</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>RETURN 1;</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">EXCEPTION</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>WHEN OTHERS THEN <strong>RETURN 0</strong><span style="mso-spacerun: yes;"> </span>;</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">END;</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"> </p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><br />CREATE OR REPLACE FUNCTION <strong>is_date</strong>(v_str_date IN varchar2, V_FORMAT IN VARCHAR2 <strong>DEFAULT 'YYYYMMDD'</strong>) </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">RETURN NUMBER </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">IS<span style="mso-spacerun: yes;"> </span>/* </span><span style="font-family: 굴림체; font-size: 9pt;">데이터가<span lang="EN-US"> DATE </span>형인지 검사하는 함수임<span lang="EN-US">. 1 </span>이 나오면<span lang="EN-US"> DATE </span>형임<span lang="EN-US"> */ </span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>V_DATE DATE; </span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">BEGIN</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>V_DATE := TO_DATE(v_str_date, V_FORMAT);</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>RETURN 1;<span style="mso-spacerun: yes;"> </span></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">EXCEPTION</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US"><span style="mso-spacerun: yes;"> </span>WHEN OTHERS THEN <strong>RETURN 0</strong><span style="mso-spacerun: yes;"> </span>;</span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 굴림체; font-size: 9pt;" lang="EN-US">END;<span style="mso-spacerun: yes;"> </span></span></p>
</div>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"> </p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: 돋움; mso-bidi-font-size: 10.0pt;" lang="EN-US"><br /></span><br /><br />출처: <a href="http://scidb.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4%EC%97%90%EC%84%9C-isnumber-isdate-%ED%95%A8%EC%88%98-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0">http://scidb.tistory.com/entry/오라클에서-isnumber-isdate-함수-사용하기</a> [Science of Database]</p><p><strong><a href="http://blog1.phps.kr/736?commentInput=true#entry736WriteComment">댓글 쓰기</a></strong></p>
maven build including mybatis xml , 메이븐 빌드시 xml 추가하기
java, tomcat, c#
http://blog1.phps.kr/735
2018-02-20T10:11:32+09:00
2018-02-20T10:11:29+09:00
<pre style="color: #a9b7c6; font-family: '굴림체'; font-size: 9pt; background-color: #2b2b2b;"><span style="color: #e8bf6a;"><build><br /></span><span style="color: #e8bf6a;"> <resources><br /></span><span style="color: #e8bf6a;"> <resource><br /></span><span style="color: #e8bf6a;"> <directory></span>src/main/java<span style="color: #e8bf6a;"></directory><br /></span><span style="color: #e8bf6a;"> <includes><br /></span><span style="color: #e8bf6a;"> <include></span>**/maps/*.xml<span style="color: #e8bf6a;"></include><br /></span><span style="color: #e8bf6a;"> </includes><br /></span><span style="color: #e8bf6a;"> </resource><br /></span><span style="color: #e8bf6a;"> </resources></span></pre>
<br />pom.xml 파일에 빌드 요소 하단에 다음과 같이 추가 한다.<p><strong><a href="http://blog1.phps.kr/735?commentInput=true#entry735WriteComment">댓글 쓰기</a></strong></p>
tomcat7 이상 iframe 사용 하려면
java, tomcat, c#
http://blog1.phps.kr/734
2018-01-26T17:41:01+09:00
2018-01-26T17:40:58+09:00
tomcat 의 web.xml 또는 <br />프로젝트의 web.xml에 다음과 같이 추가 한다<br /><br /><br /><filter><br /> <filter-name>httpHeaderSecurity</filter-name><br /> <filter-class>org.apache.catalina.filters.HttpHeaderSecurityFilter</filter-class><br /> <init-param><br /> <param-name>antiClickJackingOption</param-name><br /> <param-value>SAMEORIGIN</param-value><br /> </init-param><br /></filter><br /><filter-mapping><br /> <filter-name>httpHeaderSecurity</filter-name><br /> <url-pattern>/*</url-pattern><br /></filter-mapping><p><strong><a href="http://blog1.phps.kr/734?commentInput=true#entry734WriteComment">댓글 쓰기</a></strong></p>