환경설정필요파일ojdbc6.jarapache-tomcat-8.5.73 로컬서버 실행log4jdbc.log4j2.properties[workspace]인코딩 (enc): UTF-8[프로젝트 생성]프로젝트: Spring Legacy Project템플릿: Spring MVC Project[web.xml] encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 encodingFilter /* appServlet[pom.xml]java-version: 1.8springframework-version: 5.0.7Spring&MyBatis org.sp..
Backend/프로젝트
LISTAGG 예제SELECT DISTINCT job, LISTAGG( empno, '/' ) WITHIN GROUP( ORDER BY empno ) OVER( PARTITION BY job ) FROM emp;-- 예제 1)SELECT DISTINCT deptno, LISTAGG( empno, '/' ) WITHIN GROUP( ORDER BY empno ) OVER( PARTITION BY deptno ) empnosFROM empORDER BY deptno ASC;-- 예제 2)WITH FRU AS (SELECT 1 AS FID, '딸기' AS FNAME FROM DUALUNION ALLSELECT 2 AS FID, '사과' AS FNAME FROM DUALUNION ALLSELECT 3..
환경설정오라클 계정생성이클립스 프로젝트 생성DBCP 연결 CREATE USER ssdIDENTIFIED BY 1234;권한부여GRANT CONNECT, RESOURCE, DBA, UNLIMITED TABLESPACE TO ssd;CONNECT SQL Developer 에 접속권한을 준다.계정의 테이블 모두 삭제SELECT 'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'FROM user_objectsWHERE object_type = 'TABLE';DBCPemp 예시SELECT * FROM emp Hello world3 empno ${e.empno} ename ${e.ename} 경로수정아래서버..
테니스 점수판출력> 경기의 세트 수(3 or 5), 두 선수의 이름을 각각 입력해주세요 ? 3 라이언 어피치[0, 0]라이언 [15, 0, 0, 0, 0, 0]어피치 [0, 0, 0, 0, 0, 0][0, 0]라이언 [30, 0, 0, 0, 0, 0]어피치 [0, 0, 0, 0, 0, 0][0, 0]라이언 [30, 0, 0, 0, 0, 0]어피치 [15, 0, 0, 0, 0, 0][0, 0]라이언 [30, 0, 0, 0, 0, 0]어피치 [30, 0, 0, 0, 0, 0][0, 0]라이언 [30, 0, 0, 0, 0, 0]어피치 [40, 0, 0, 0, 0, 0][0, 0]라이언 [40, 0, 0, 0, 0, 0]어피치 [40, 0, 0, 0, 0, 0][0, 0]라이언 [40, 0, 0, 0, 0, 0..
