목록Back-end (102)

이안의 평일코딩

Spring 16일차 - Transaction 게시판 만들기 / 쿠키

2020.11.18(수) SpringAOPProject3 기본설정 후 SQL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 CREATE TABLE spring_reply( no NUMBER PRIMARY KEY, name VARCHAR2(34) NOT NULL, subject VARCHAR2(1000) NOT NULL, content CLOB NOT NULL, pwd VARCHAR2(10) NOT NULL, regdate DATE DEFAULT SYSDATE, hit NUMBER DEFAULT 0, gi NUMBER, --답변 gs NUMBER DEFAULT 0, gt NUMBER DEFAULT 0, root NUMBER DEFAULT 0, depth NUMBER DEFAULT 0 ); Co..
Back-end/Spring 2020. 11. 18. 12:09
Spring 15일차 - AOP

2020.11.17(화) mvnrepository.com/artifact/javax.validation/validation-api/2.0.1.Final Maven Repository: javax.validation » validation-api » 2.0.1.Final javax.validation validation-api 2.0.1.Final // https://mvnrepository.com/artifact/javax.validation/validation-api compile group: 'javax.validation', name: 'validation-api', version: '2.0.1.Final' // https://mvnrepository.com/artifact/javax.validat..
Back-end/Spring 2020. 11. 17. 09:11
Oracle 21일차 - Trigger

2020.11.16(월) Trigger (하나가 되면 연쇄적으로) 1) 데이터베이스에 미리 정해놓는 조건에 만족하면 자동으로 이벤트 처리 (오라클에서 처리 => 자바에서는 처리 코드를 작성하지 않는다) 2) Trigger : DML(INSERT, UPDATE, DELETE) 3) 형식 CREATE (OR REPLACE) TRIGGER tri_name BEFORE|AFTER (INSERT,UPDATE,DELETE) ON table_name BEGIN TRIGGER 처리 (다른 테이블 처리) END; / 4) 삭제 DROP TRIGGER trigger_name 5) 수정 ALTER TRIGGER trigger_name => 수정과 동시에 생성 FUCNTION, PROCEDURE (AutoCommit(X)) ..
Back-end/Oracle 2020. 11. 16. 15:29
Spring 14일차 - Tiles

2020.11.16(월) startbootstrap.com/theme/sb-admin-2 SB Admin 2 - Free Bootstrap Admin Theme A free Bootstrap admin theme, dashboard, or web application UI. All Start Bootstrap templates are free to download and open source. startbootstrap.com SpringTilesProject jdk 1.8로 수정 pom.xml, web.xml 복붙 pom.xml에서 tiles최신버젼으로 변경해줘야 404오류가 안뜸! 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 org.apache..
Back-end/Spring 2020. 11. 16. 11:58
국비 Spring 프로젝트 DB설계 및 화면UI

#7 반려동물 산책코스 DB설계 app.diagrams.net/ Flowchart Maker & Online Diagram Software Flowchart Maker and Online Diagram Software diagrams.net (formerly draw.io) is free online diagram software. You can use it as a flowchart maker, network diagram software, to create UML online, as an ER diagram tool, to design database schema, to build BPM app.diagrams.net dog => 산책코스 리스트, 디테일 CREATE TABLE dog( no NUMB..
Back-end/Team Project 2020. 11. 15. 22:20
Spring 13일차 - Mybatis연동, JSON

2020.11.13(금) SpringMybatisProject pom.xml, WEB-INF/lib폴더에 ojdbc14.jar복붙 web.xml (4버전 xml사용 방식설정) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 dispatcher org.springframework.web.servlet.DispatcherServlet ContextConfigLocation /WEB-INF/config/application-*.xml dispatcher *.do encodingFilter org.springfram..
Back-end/Spring 2020. 11. 13. 16:08
Spring 12일차 - PL/SQL Procedure 게시판 만들기

2020.11.12(목) SpringProcedureProject1 pom.xml, web.xml 복붙 WEB-INF/에 config폴더 생성후 Bean으로 application-context.xml 생성(beans, context(component-scan), p) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Colored by Color Scripter cs pom.xml에 ojdbc14.jar 설치 (WEB-INF/lib폴더에 ojdbc14.jar 다운받아서 넣은 뒤에) 1 2 3 4 5 6 7 8 9 10 11 12 com.oracle ojdbc14 10.2.0.4.0 system ${project.basedir}/src/main/webapp/WEB-INF/lib/ojdb..
Back-end/Spring 2020. 11. 12. 10:57
Oracle 20일차 - Cursor, Function

2020.11.11~12(수, 목) -- cursor : 여러개 Row(Record)를 저장할 수 있는 공간 ==> ResultSet -- 처리 => CURSOR => 자바 (ResultSet) 1. 커서등록 cursor cur_name IS SELECT * FROM emp 2. open 3. fetch 4. close 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 SET SERVEROUTPUT ON; DECLARE vemp emp%ROWTYPE; CURSOR cur IS SELECT * FROM emp; BEGIN OPEN cur; DBMS_OUTPUT.PUT_LINE('====결과===='); LOOP FETCH cur INTO vemp; EXIT WHEN cu..
Back-end/Oracle 2020. 11. 11. 16:10
Prev 1 2 3 4 5 6 ··· 13 Next