공지사항과, 공지사항 첨부 파일 (1:n)#
테이블 생성#
CREATE TABLE TBL_NOTICE ( NOTICE_NO NUMBER NOT NULL , TITLE VARCHAR2(200) NOT NULL , CONTENT VARCHAR2(4000) NOT NULL , REGISTER VARCHAR2(90) NOT NULL , REG_DATE DATE NOT NULL , PRIMARY KEY (NOTICE_NO) ) ;
CREATE TABLE TBL_NOTICE_FILE ( NOTICE_FILE_NO NUMBER NOT NULL , NOTICE_FILE_NAME VARCHAR2(300) NOT NULL , NOTICE_NO NUMBER NOT NULL , PRIMARY KEY (NOTICE_FILE_NO) );
CREATE SEQUENCE SEQ_NOTICE INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_NOTICE_FILE INCREMENT BY 1 START WITH 1;
//FK설정
ALTER TABLE TBL_NOTICE_FILE
ADD CONSTRAINT NOTICE_FILE_NOTICE_NO FOREGIN KEY (NOTICE_NO) REFERENCE TBL_NOTICE(NOTICE_NO)pom.xml 설정#
<!-- START multi file upload --> <dependency> <groupId>org.imgscalr</groupId> <artifactId>imgscalr-lib</artifactId> <version>4.2</version> </dependency>
<dependency> <groupId>commons-fileupload</groupId> <artifactId>commons-fileupload</artifactId> <version>1.3.2</version> </dependency> <!-- END multi file upload -->
<!-- https://mvnrepository.com/artifact/org.webjars/jquery --> <dependency> <groupId>org.webjars</groupId> <artifactId>jquery</artifactId> <version>3.3.1</version> </dependency>root-context.xml 설정 (파일 최대크기)#
<!-- file upload로 들어오는 data를 처리하는 객체 --> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="maxUploadSize" value="10485760"></property> </bean>servlet-context.xml bean 등록 설정#
<!--파일 업로드 관련 Beans 설정 --> <beans:bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <beans:property name="maxUploadSize" value="10485760"></beans:property> </beans:bean>
<!-- 서버의 파일 저장 경로 설정 --> <beans:bean id="uploadPath" class="java.lang.String"> <beans:constructor-arg value="C:\\resources\\upload"></beans:constructor-arg> </beans:bean>이후#
이전과 같이, NoticeDAO (persistence) => noticeMapper => NoticeEDAOImpl => Service 순으로 코딩해 나간다