JSP,JAVA,오라클 회원가입관리 및 답변형게시판만들기

소개글

JSP,자바,톰캣, 오라클을 이용하여 회원가입 수정 답변형 게시판을 만들었습니다.
JSP에서는 JSTL,EL문을 사용하였습니다.
게시판은 답글 및 리플기능 , 파일 업로드,다운로드 기능 구현하였습니다.

컴파일 실행환경

JSP 톰캣 오라클 JDK

압축파일 내 파일목록

.classpath
.project
.settings/.jsdtscope
.settings/org.eclipse.jdt.core.prefs
.settings/org.eclipse.wst.common.component
.settings/org.eclipse.wst.common.project.facet.core.xml
.settings/org.eclipse.wst.jsdt.ui.superType.container
.settings/org.eclipse.wst.jsdt.ui.superType.name
build/classes/com/seoulit/board/action/BoardCommentAction.class
build/classes/com/seoulit/board/action/BoardCommentDeleteAction.class
build/classes/com/seoulit/board/action/BoardDeleteAction.class
build/classes/com/seoulit/board/action/BoardEditAction.class
build/classes/com/seoulit/board/action/BoardEditFormAction.class
build/classes/com/seoulit/board/action/BoardFileDownAction.class
build/classes/com/seoulit/board/action/BoardListAction.class
build/classes/com/seoulit/board/action/BoardReplyAction.class
build/classes/com/seoulit/board/action/BoardReplyFormAction.class
build/classes/com/seoulit/board/action/BoardShowAction.class
build/classes/com/seoulit/board/action/BoardWriteAction.class
build/classes/com/seoulit/board/action/BoardWriteFormAction.class
build/classes/com/seoulit/board/exception/BoardDAOException.class
build/classes/com/seoulit/board/exception/ExitedBoardException.class
build/classes/com/seoulit/board/model/Board.class
build/classes/com/seoulit/board/model/BoardDAO.class
build/classes/com/seoulit/board/model/BoardServiceFacade.class
build/classes/com/seoulit/board/model/CommentBoard.class
build/classes/com/seoulit/board/model/FileBeans.class
build/classes/com/seoulit/board/model/PageBeans.class
build/classes/com/seoulit/common/action/Action.class
build/classes/com/seoulit/common/action/ActionForward.class
build/classes/com/seoulit/common/controller/ActionServlet.class
build/classes/com/seoulit/common/controller/FileDownLoadServlet.class
build/classes/com/seoulit/common/exception/FileUploadWrapperException.class
build/classes/com/seoulit/common/exception/ServiceLocatorException.class
build/classes/com/seoulit/common/fileupload/FileUploadRequestWrapper.class
build/classes/com/seoulit/common/mapper/ActionMapper.class
build/classes/com/seoulit/common/util/ConnUtil.class
build/classes/com/seoulit/common/util/ServiceLocator.class
build/classes/com/seoulit/member/action/AddFormAction.class
build/classes/com/seoulit/member/action/AddMemberAction.class
build/classes/com/seoulit/member/action/AddrCheckAction.class
build/classes/com/seoulit/member/action/DeleteMemberAction.class
build/classes/com/seoulit/member/action/IdCheckAction.class
build/classes/com/seoulit/member/action/ListMemberAction.class
build/classes/com/seoulit/member/action/LoginAction.class
build/classes/com/seoulit/member/action/LogoutAction.class
build/classes/com/seoulit/member/action/MainAction.class
build/classes/com/seoulit/member/action/MainFormAction.class
build/classes/com/seoulit/member/action/UpdateFormAction.class
build/classes/com/seoulit/member/action/UpdateMemberAction.class
build/classes/com/seoulit/member/action/UseIdAction.class
build/classes/com/seoulit/member/exception/ExitedMemberException.class
build/classes/com/seoulit/member/exception/IdNotFoundException.class
build/classes/com/seoulit/member/exception/MemberDAOException.class
build/classes/com/seoulit/member/model/Member.class
build/classes/com/seoulit/member/model/MemberAddr.class
build/classes/com/seoulit/member/model/MemberDAO.class
build/classes/com/seoulit/member/model/MemberServiceFacade.class
build/classes/com/seoulit/member/model/PageBeans.class
src/com/seoulit/board/action/BoardCommentAction.java
src/com/seoulit/board/action/BoardCommentDeleteAction.java
src/com/seoulit/board/action/BoardDeleteAction.java
src/com/seoulit/board/action/BoardEditAction.java
src/com/seoulit/board/action/BoardEditFormAction.java
src/com/seoulit/board/action/BoardFileDownAction.java
src/com/seoulit/board/action/BoardListAction.java
src/com/seoulit/board/action/BoardReplyAction.java
src/com/seoulit/board/action/BoardReplyFormAction.java
src/com/seoulit/board/action/BoardShowAction.java
src/com/seoulit/board/action/BoardWriteAction.java
src/com/seoulit/board/action/BoardWriteFormAction.java
src/com/seoulit/board/exception/BoardDAOException.java
src/com/seoulit/board/exception/ExitedBoardException.java
src/com/seoulit/board/model/Board.java
src/com/seoulit/board/model/BoardDAO.java
src/com/seoulit/board/model/BoardServiceFacade.java
src/com/seoulit/board/model/CommentBoard.java
src/com/seoulit/board/model/FileBeans.java
src/com/seoulit/board/model/PageBeans.java
src/com/seoulit/common/action/Action.java
src/com/seoulit/common/action/ActionForward.java
src/com/seoulit/common/controller/ActionServlet.java
src/com/seoulit/common/controller/FileDownLoadServlet.java
src/com/seoulit/common/exception/FileUploadWrapperException.java
src/com/seoulit/common/exception/ServiceLocatorException.java
src/com/seoulit/common/fileupload/FileUploadRequestWrapper.java
src/com/seoulit/common/mapper/ActionMapper.java
src/com/seoulit/common/util/ConnUtil.java
src/com/seoulit/common/util/ServiceLocator.java
src/com/seoulit/member/action/AddFormAction.java
src/com/seoulit/member/action/AddMemberAction.java
src/com/seoulit/member/action/AddrCheckAction.java
src/com/seoulit/member/action/DeleteMemberAction.java
src/com/seoulit/member/action/IdCheckAction.java
src/com/seoulit/member/action/ListMemberAction.java
src/com/seoulit/member/action/LoginAction.java
src/com/seoulit/member/action/LogoutAction.java
src/com/seoulit/member/action/MainAction.java
src/com/seoulit/member/action/MainFormAction.java
src/com/seoulit/member/action/UpdateFormAction.java
src/com/seoulit/member/action/UpdateMemberAction.java
src/com/seoulit/member/action/UseIdAction.java
src/com/seoulit/member/exception/ExitedMemberException.java
src/com/seoulit/member/exception/IdNotFoundException.java
src/com/seoulit/member/exception/MemberDAOException.java
src/com/seoulit/member/model/Member.java
src/com/seoulit/member/model/MemberAddr.java
src/com/seoulit/member/model/MemberDAO.java
src/com/seoulit/member/model/MemberServiceFacade.java
src/com/seoulit/member/model/PageBeans.java
WebContent/addrcheck.jsp
WebContent/boardeditform.jsp
WebContent/boardlist.jsp
WebContent/boardreplyform.jsp
WebContent/boardshowform.jsp
WebContent/boardwriteform.jsp
WebContent/content.jsp
WebContent/error.jsp
WebContent/header.jsp
WebContent/idcheck.jsp
WebContent/image/comment.png
WebContent/image/filedown.png
WebContent/image/head.jpg
WebContent/image/hot.bmp
WebContent/image/re.gif
WebContent/image/remove.png
WebContent/joinerror.jsp
WebContent/joinform.jsp
WebContent/loginform.jsp
WebContent/main.jsp
WebContent/mainform.jsp
WebContent/memberlist.jsp
WebContent/menu.jsp
WebContent/META-INF/MANIFEST.MF
WebContent/template.jsp
WebContent/updateForm.jsp
WebContent/WEB-INF/BoardCommands.properties
WebContent/WEB-INF/lib/commons-beanutils-1.8.0.jar
WebContent/WEB-INF/lib/commons-digester-1.8.1.jar
WebContent/WEB-INF/lib/commons-fileupload-1.2.1-javadoc.jar
WebContent/WEB-INF/lib/commons-fileupload-1.2.1-sources.jar
WebContent/WEB-INF/lib/commons-fileupload-1.2.1.jar
WebContent/WEB-INF/lib/commons-io-1.4-javadoc.jar
WebContent/WEB-INF/lib/commons-io-1.4-sources.jar
WebContent/WEB-INF/lib/commons-io-1.4.jar
WebContent/WEB-INF/lib/commons-logging-1.1.jar
WebContent/WEB-INF/lib/tiles-api-2.1.2.jar
WebContent/WEB-INF/lib/tiles-core-2.1.2.jar
WebContent/WEB-INF/lib/tiles-jsp-2.1.2.jar
WebContent/WEB-INF/lib/tiles-servlet-2.1.2.jar
WebContent/WEB-INF/MemberCommands.properties
WebContent/WEB-INF/tags/boardpageview.tag
WebContent/WEB-INF/tags/memberpageview.tag
WebContent/WEB-INF/tags/showpageview.tag
WebContent/WEB-INF/tiles-seoulit.xml
WebContent/WEB-INF/web.xml

전체 목록 보기

참고 자료

----오라클 테이블 생성 쿼리문입니다----
drop table board;

create table board (
id number primary key,
name varchar2(20) not null,
title varchar2(100) not null,
content varchar2(4000) not null,
hit number not null,
ref number not null,
step number not null,
levell number not null
);

drop table commentboard;

create table commentboard(
commentid number primary key,
commentname varchar2(20) not null,
commentcontent varchar2(500) not null,
commentref number not null,
commentstep number not null,
commentlevell number not null
);


drop sequence file_no_seq;
create sequence file_no_seq;

drop table fileboard;
create table fileboard(
boardno number not null,
filename varchar2(200) not null,
filepath varchar2(500) not null,
constraints fileboard_fk foreign key (boardno) references board(id) on delete cascade
);

drop table member;
create table member(
id varchar2(20) primary key,
pw varchar2(20) not null,
addr varchar2(100) not null,
tel varchar2(50) not null
);