turtle

Posts

Showing posts from August, 2017

jstl sql

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <sql:setDataSource url="jdbc:mysql://127.0.0.1:1521/testdb?useUnicode=true&characterEncoding=UTF8" driver="org.gjt.mm.mysql.Driver" user="root&qu

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> <c:set var="array" value="${fn:split(str,' ')}"/> join : ${fn:join(array,"-")} <hr width="500" color=&qu

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> contains : ${fn:contains(str,"Library")} contains : ${fn:contains(str,"jstl")} containsIgnoreCase : &l

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> indexOf : ${fn:indexOf(str,"tag")} indexOf : ${fn:indexOf(str,"Tag")} startsWith : ${fn:starts

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> replace : ${fn:replace(str,"JSP","JAVA")} <hr width="500" color="red" align="left"> </body&

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> toUpperCase : ${fn:toUpperCase(str)} toLowerCase : ${fn:toLowerCase(str)} <hr width="500" color=&quo

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> substring: ${fn:substring(str,0,17)} substringAfter : ${fn:substringAfter(str,"JSP")} substringBefore :

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <hr width="500" color="red" align="left"> <c:set var="str" value="JSTL(JSP Standard Tag Library)"/> length : ${fn:length(str)} <hr width="500" color="red" align="left"> </body> </html> JSTL tag ex)

JSTL(JSP Standard Tag Library)

jstl jar download : https://ahnsk39.blogspot.com/2017/08/can-not-find-tag-library-descriptor-for.html 1. CORE 1) 변수 선언, 실행흐름의 제어 기능 2) JSP 페이지 제어 기능 - c:out, c:set : https://ahnsk39.blogspot.com/2017/08/jstl-cset-cout.html - c:if : https://ahnsk39.blogspot.com/2017/08/jstl-cif.html - c:choose : https://ahnsk39.blogspot.com/2017/08/jstl-cchoose.html - c:forEach : https://ahnsk39.blogspot.com/2017/08/jstl-foreach.html - c:forTokens : https://ahnsk39.blogspot.com/2017/08/jstl-fortokens.html 2. FORMAT 1) 숫자, 날짜, 시간을 포매팅하는 기능과 국제화, 다국어 지원 기능 - c:fmt : https://ahnsk39.blogspot.com/2017/09/jstl-function-fmt.html 3. SQL 1) 데이터베이스의데이터 입력/수정/삭제/조회하는 기능 - sql : https://ahnsk39.blogspot.com/2017/08/jstl-sql.html 4. XML 1) XML 문서 처리 기능 5. FUNCTIONS 1) 문자열을처리하는 함수 - fn:contains, containsIgnoreCase : https://ahnsk39.blogspot.com/2017/08/jstl-function-contains.html - fn:indexOf, startsWith, endsWith : https://ahn

<body> <c:set var="str" value="A|P|P|L|E"/> <c:forTokens var="item" items="${str}" delims="|" > ${item} </c:forTokens> </body> JSTL tag ex) : https://ahnsk39.blogspot.com/2017/08/jstljsp-standard-tag-library.html

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> <%@ page import="java.util.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <% List list = new ArrayList(); list.add("A"); list.add("P"); list.add("P"); list.add("L"); list.add("E"); %> collection <c:forEach var="item" items="<%=list%>"> <c:out value="${

<c:set var="num1" value="9"/> <c:set var="num2" value="2"/> <c:choose> <c:when test="${num1 == 2}"> 2 </c:when> <c:when test="${num1 eq 9}"> 9 </c:when> <c:otherwise> <c:out value="${num1}"/> </c:otherwise> </c:choose> <c:set var="num1" value="11"/> <c:choose> <c:when test="${num1 == 2}"> num1 2 </c:when> <c:when test="${num1 eq 9}"> num1 9 </c:when> <c:otherwise> <c:out value="${num1}"/> </c:otherwise> </c:choose> JSTL tag ex) : https://ahnsk39.blogspot.com/2017/08/jstljsp-standard-tag-library.html

<c:set var="num1" value="9"/> <c:set var="num2" value="2"/> <c:if test="${num1 == 9}"> ok </c:if> <c:if test="${num1 == 8}"> no </c:if> JSTL tag ex) : https://ahnsk39.blogspot.com/2017/08/jstljsp-standard-tag-library.html

<c:set var="num1" value="9"/> <c:set var="num2" value="2"/> <c:out value="${num1}"/> <c:out value="${num2}"/> <c:out value="${num1+num2}"/> JSTL tag ex) : https://ahnsk39.blogspot.com/2017/08/jstljsp-standard-tag-library.html

tomcat index.jsp /WebContent/WEB-INF/web.xml 수정 (Eclipse 단추키 Ctrl+R 후 web.xml입력)

Can not find the tag library descriptor for "http://java.sun.com/jsp/jstl/core" jstl jar download : http://archive.apache.org/dist/jakarta/taglibs/standard/binaries/ 1. jakarta-taglibs-standard-1.1.2.zip 2. 압축을 해제 하고 \jakarta-taglibs-standard-1.1.2\jakarta-taglibs-standard-1.1.2\lib 폴터에 가보면 jstl.jar, standard.jar가 있다. 3. 프로젝트의 WEB-INF/lib/ 밑에 파일을 복사 4. JSP에서 확인

nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2

nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2 2개 이상의 결과가 나와 에러

ORA-01775 : 동의어가 순환 고리 유형으로 정의되어 있습니다 ORA-01775 - Looping chain of synonyms 삭제한 테이블인데 조회 하면 ora-01775 에러가 나온다. SELECT * FROM DBA_SYNONYMS WHERE TABLE_NAME LIKE '%TH_USE_LOG%' 삭제한 테이블에 시노님이 있어 발생했다.

1. 톰켓 설치 후 실행하면 위와 같이 주소에 프로젝트 명이 포함되어 있음.(testWeb) 2. Servers 탭에서 프로젝트가 속한 서버를 더블 클릭 - Modules 탭 클릭 - 우측에 Edit 클릭 -> 3. Path 프로젝트 명을 삭제 4. Server Start 후 URL 주소에 프로젝트명을 빼고 입력 JSP Dynamic Web Project 설정 : https://ahnsk39.blogspot.com/2017/08/jsp-dynamic-web-project.html URL주소 부분에 8080 포트 없애기: https://ahnsk39.blogspot.com/2017/08/tomcat-server-8080-80.html

1. 제어판>프로그램 및 기능 > windows 기능 켜기/끄기 선택 2. 인터넷 정보 서비스 체크 해제

1. Servers 탭 클릭 하면 프로젝트가 속해 있는 서버를 찾아서 더블 클릭하면 위와같은 서버 설정 화면 2.HTTP/1.1 부분에 8080을 80으로 변경후 저장 3. URL에 8080을 빼고 접속되면 정상(80포트의 경우 생략이 가능함.) windows10 80포트가 안될경우 : https://ahnsk39.blogspot.com/2017/08/windows10-port-80.html

1. File > New >Dynamic Web Project 2.프로젝트 이름 입력, Finnish 클릭 3. WebContent 우측 클릭> New > JSP File 4. 파일 이름 입력후 Finish 5. main.jsp > Hello world 입력 후 저장(Ctrl+s) 6. 프로젝트에서 우측클릭 > Run As > Run on Server 7. Manually define a new server 선택 > Apache tomcat 선택 > Finish 8. 7에서 Finish 하면 좀 지나면 위와 같은 에러 페이지 발생 9. url 부분 끝에 생성한 파일이름.jsp 입력 엔터 하면 아래와 같이 정상페이지 출력 1. URL주소 부분에 8080 포트 없애기: https://ahnsk39.blogspot.com/2017/08/tomcat-server-8080-80.html 2. URL주소 부분에 프로젝트명 포함되지 않도록 변경: http://ahnsk39.blogspot.com/2017/08/tomcat-project-root.html 3. JSTL 라이브러리 설치 : https://ahnsk39.blogspot.com/2017/08/can-not-find-tag-library-descriptor-for.html 4. tomcat index 페이지 설정 : https://ahnsk39.blogspot.com/2017/08/tomcat-index.html

파일명에 공백이 포함된 경우, 파일명 변경 또는 파일삭제

공백이 포함된 경우 - 공백이 있는 경우는 파일명 앞뒤에 큰 따옴표 붙이면 됨. ex) mv "HA apdap guide .doc" ./a.doc or rm "HA apdap guide .doc"

-------------------------------------------------------------------------------- SELECT LV, SUM(LV) OVER(PARTITION BY FLAG ORDER BY RN) SUMOVER FROM (SELECT ROWNUM RN, '99' AS FLAG, LEVEL LV FROM DUAL CONNECT BY LEVEL < 100 ORDER BY 3)

SELECT SUBSTR(a.tablespace_name,1,30) TABLESPACE, ROUND(SUM(a.total1) /1024/1024,1) "TotalMB", ROUND(SUM(a.total1) /1024/1024,1)-ROUND(SUM(a.sum1)/1024/1024,1) "UsedMB", ROUND(SUM(a.sum1) /1024/1024,1) "FreeMB", ROUND((ROUND(SUM(a.total1)/1024/1024,1)-ROUND(SUM(a.sum1)/1024/1024,1))/ROUND(SUM(a.total1)/1024/1024,1)*100,2) "Used%" FROM ( SELECT tablespace_name, 0 total1, SUM(bytes) sum1, MAX(bytes) MAXB, COUNT(bytes) cnt FROM dba_free_space GROUP BY tablespace_name UNION SELECT tablespace_name, SUM(bytes) total1, 0, 0, 0 FROM dba_data_files GROUP BY tablespace_name ) a GROUP BY a.tablespace_name ORDER BY TABLESPACE;

oracle dbms job

DECLARE JOBNO NUMBER; BEGIN DBMS_JOB.SUBMIT (JOB => JOBNO ,WHAT => 'BEGIN PROCEDURE_NAME; END;' ,NEXT_DATE => SYSDATE ,INTERVAL => 'SYSDATE+365'); COMMIT; END; DBMS_JOB.submit: 등록 DBMS_JOB.remove: 삭제 DBMS_JOB.change: 변경 DBMS_JOB.next_date: 다음 JOB 실행시간 DBMS_JOB.interval: 실행 Cycle DBMS_JOB.what: 프로시저 변경 DBMS_JOB.run: 수동 실행

Alternative quote (q) Operator Specify your own quotation mark delimiter- Choose any delimiter- Increase readability and usability-

The content of elements must consist of well-formed character data or markup. <![CDATA[ ]]> 부등호 사용하고 깜박했네.

NVL SELECT NVL(NULL,'want') from dual; NVL2 SELECT NVL2('not','one','two') from dual UNION ALL SELECT NVL2(NULL,'one','two') from dual;

권력 쿠폰입니다 YSTHAWUJBGTEXRL YSTQHKMDHQHXTJP YSTQHCXBGQMRBVJ

Search This Blog

turtle

Posts

jstl sql

jstl function trim

jstl function join

jstl function contains, containsIgnoreCase

jstl function indexOf, startsWith, endsWith

jstl function replace

jstl function toUpperCase toLowerCase

jstl function substring

jstl function length

JSTL(JSP Standard Tag Library)

jstl forTokens

jstl forEach

jstl choose

jstl if

jstl set out

tomcat index 설정

Can not find the tag library descriptor for "http://java.sun.com/jsp/jstl/core" jstl

nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2

ORA-01775 - Looping chain of synonyms

tomcat project root 설정

windows10 port 80 안될 경우

tomcat Server 8080 -> 80

JSP Dynamic Web Project

파일명에 공백이 포함된 경우, 파일명 변경 또는 파일삭제

ORACLE SUM OVER PARTITION (WITH CONDITION)

oracle tablespace Total free space

oracle dbms job

oracle Alternative quote (q) Operator

The content of elements must consist of well-formed character data or markup.

NVL, NVL2 function

Game 권력 The Rulers 쿠폰