spring 실습1-1(게시판)

프로젝트 명 : spring

계정생성
sqlplus system/oracle

create user spring identified by spring123;
grant connect, resource to spring;

테이블명 : myboard
create table myboard(
no number primary key,
writer varchar2(20),
passwd varchar2(20),
subject varchar2(50),
content varchar2(100),
readcount number,
register date );

시퀀스 : myboard_seq
create sequence myboard_seq;

java - myspring - controller - BoardController.java

           service - BoardService.java

           dao - BoardDao.java

          model - Board.java

resources - util - configuration.xml

            sql - board.xml

board - boardform.jsp (글작성 폼)

    boardlist.jsp (글목록)

    boardcontent.jsp (상세 페이지)

    boardupdateform.jsp (글수정 폼)

    boarddeleteform.jsp (글삭제 폼)
    

sts사용중(data source management추가)

[Help] - Install New Software...

Add 버튼 클릭

Name : DTP
Location : http://download.eclipse.org/datatools/1.14.1.201712071719/repository/