[JSP/Servlet] 기말텀 WebDBMS 웹 어플리케이션

소개글

웹 기말텀으로 작성했던 JSP/Servlet 으로 구현한 웹DBMS입니다.

목차

소스코드
배포문서
설계문서

본문내용

설계문서

█ 개요
: 이번 텀 프로젝트인 WebDBMS 웹 어플리케이션은 관리자와 사용자가 웹에서 DB를 관리할 수 있도록하는 시스템이다. 사용자들은 사용자 등록을 통하여 DB에 접근하여 테이블과 레코드들을 관리할 수 있다. 각 사용자들은 자신이 생성한 테이블에 대해서 소유자가 되고, 다른 소유자의 테이블에 대해서는 테이블의 구조와 레코드 조회만 할 수 있다. 하지만 admin 사용자ID를 가지는 관리자는 시스템 테이블인 tblUser, tblTable 을 제외한 모든 테이블에 대해서 모든 작업을 수행할 수 있다. 시스템 테이블은 테이블의 구조 조회와 레코드의 추가/변경/삭제만 가능하다.
사용자가 로그인을 하면 사용자에 대한 사용자ID, 비밀번호, 로그인상태, 선택한 테이블명, 테이블의 소유자 여부 등의 정보를 세션에 저장한다. 그래서 각 페이지에서는 이 세션에 저장되어 있는 정보를 이용하여 현재 사용자가 선택한 테이블에 대한 권한 여부를 알 수 있다. 그리고 화면에 표시되는 정보들은 자바빈의 메소드를 호출하여 반환값으로 받은 ResultSet을 이용한다. 모든 DB에 대한 작업은 manage*.jsp 페이지들에서만 수행한다. 그리고 사용자의 편의를 도모하기 위해서 테이블의 구조변경이나 레코드의 추가/변경/삭제 등의 작업은 한 페이지내에서 모두 수행할 수 있도록 구현해 놓았다.

참고 자료

없음

압축파일 내 파일목록

WebDBMS 웹 어플리케이션 - 설계문서.doc
WebDBMS 웹 어플리케이션 - 배포문서.doc
FinalTerm/home.html
FinalTerm/index.html
FinalTerm/login.jsp
FinalTerm/menu.html
FinalTerm/movepage.jsp
FinalTerm/right.html
FinalTerm/common/checkform.js
FinalTerm/common/managerecord.css
FinalTerm/common/managetable.css
FinalTerm/common/member.css
FinalTerm/common/script.js
FinalTerm/database/WebDB.mdb
FinalTerm/error/msgError.jsp
FinalTerm/error/msgSmallError.html
FinalTerm/error/images/btn_close_1.gif
FinalTerm/error/images/btn_close_2.gif
FinalTerm/error/images/btn_close_3.gif
FinalTerm/error/images/title_error.gif
FinalTerm/images/button_email_1.gif
FinalTerm/images/button_email_2.gif
FinalTerm/images/button_home_1.gif
FinalTerm/images/button_home_2.gif
FinalTerm/images/button_login_1.gif
FinalTerm/images/button_login_2.gif
FinalTerm/images/button_logout_1.gif
FinalTerm/images/button_logout_2.gif
FinalTerm/images/button_register_1.gif
FinalTerm/images/button_register_2.gif
FinalTerm/images/login_id.gif
FinalTerm/images/login_password.gif
FinalTerm/images/logo_webdbms.gif
FinalTerm/images/mainmenu_bg1.gif
FinalTerm/images/mainmenu_bg2.gif
FinalTerm/images/mainmenu_bg3.gif
FinalTerm/images/mm_managerecord_1.gif
FinalTerm/images/mm_managerecord_2.gif
FinalTerm/images/mm_managetable_1.gif
FinalTerm/images/mm_managetable_2.gif
FinalTerm/images/mm_modifymember_1.gif
FinalTerm/images/mm_modifymember_2.gif
FinalTerm/images/submenu_bg.gif
FinalTerm/images/submenu_managetable.gif
FinalTerm/images/title_login.gif
FinalTerm/images/title_logo.gif
FinalTerm/member/checkUserID.jsp
FinalTerm/member/manageMember.jsp
FinalTerm/member/modifyMember.jsp
FinalTerm/member/registerMember.jsp
FinalTerm/member/images/bg.gif
FinalTerm/member/images/blt_home.gif
FinalTerm/member/images/btn_cancel_1.gif
FinalTerm/member/images/btn_cancel_2.gif
FinalTerm/member/images/btn_cancel_3.gif
FinalTerm/member/images/btn_checkid_1.gif
FinalTerm/member/images/btn_checkid_2.gif
FinalTerm/member/images/btn_checkid_3.gif
FinalTerm/member/images/btn_check_1.gif
FinalTerm/member/images/btn_check_2.gif
FinalTerm/member/images/btn_check_3.gif
FinalTerm/member/images/btn_modify_1.gif
FinalTerm/member/images/btn_modify_2.gif
FinalTerm/member/images/btn_modify_3.gif
FinalTerm/member/images/btn_register_1.gif
FinalTerm/member/images/btn_register_2.gif
FinalTerm/member/images/btn_register_3.gif
FinalTerm/member/images/bullet01.gif
FinalTerm/member/images/bullet02.gif
FinalTerm/member/images/bullet03.gif
FinalTerm/member/images/cancelbutton.gif
FinalTerm/member/images/icon01.gif
FinalTerm/member/images/icon02.gif
FinalTerm/member/images/icon1.gif
FinalTerm/member/images/main_bg_bottom.gif
FinalTerm/member/images/main_bg_center.gif
FinalTerm/member/images/main_bg_top.gif
FinalTerm/member/images/registerbutton.gif
FinalTerm/member/images/subj1.gif
FinalTerm/member/images/title_memberinfo.gif
FinalTerm/member/images/title_modifymember.gif
FinalTerm/member/images/title_registermember.gif
FinalTerm/record/manageRecord.jsp
FinalTerm/record/selectRecord.jsp
FinalTerm/record/submenuRecord.jsp
FinalTerm/record/updateRecord.jsp
FinalTerm/record/viewRecord.jsp
FinalTerm/record/images/btn_addcondition_1.gif
FinalTerm/record/images/btn_addcondition_2.gif
FinalTerm/record/images/btn_addcondition_3.gif
FinalTerm/record/images/btn_clearcondition_1.gif
FinalTerm/record/images/btn_clearcondition_2.gif
FinalTerm/record/images/btn_clearcondition_3.gif
FinalTerm/record/images/btn_deleterecord_1.gif
FinalTerm/record/images/btn_deleterecord_2.gif
FinalTerm/record/images/btn_deleterecord_3.gif
FinalTerm/record/images/btn_insertrecord_1.gif
FinalTerm/record/images/btn_insertrecord_2.gif
FinalTerm/record/images/btn_insertrecord_3.gif
FinalTerm/record/images/btn_selectrecord_1.gif
FinalTerm/record/images/btn_selectrecord_2.gif
FinalTerm/record/images/btn_selectrecord_3.gif
FinalTerm/record/images/btn_updaterecord_1.gif
FinalTerm/record/images/btn_updaterecord_2.gif
FinalTerm/record/images/btn_updaterecord_3.gif
FinalTerm/record/images/button_logout_1.gif
FinalTerm/record/images/button_logout_2.gif
FinalTerm/record/images/mainmenu_bg1.gif
FinalTerm/record/images/mainmenu_bg2.gif
FinalTerm/record/images/mainmenu_bg3.gif
FinalTerm/record/images/rm_selectrecord_1.gif
FinalTerm/record/images/rm_selectrecord_2.gif
FinalTerm/record/images/rm_updaterecord_1.gif
FinalTerm/record/images/rm_updaterecord_2.gif
FinalTerm/record/images/rm_viewrecord_1.gif
FinalTerm/record/images/rm_viewrecord_2.gif
FinalTerm/record/images/stitle_selectrecord.gif
FinalTerm/record/images/stitle_updaterecord.gif
FinalTerm/record/images/stitle_viewrecord.gif
FinalTerm/record/images/submenu_bg.gif
FinalTerm/record/images/submenu_managerecord.gif
FinalTerm/record/images/title_login.gif
FinalTerm/record/images/title_managerecord.gif
FinalTerm/table/designTable.jsp
FinalTerm/table/dropTable.jsp
FinalTerm/table/dropTableMsg.jsp
FinalTerm/table/inputFieldCount.html
FinalTerm/table/inputTableName.jsp
FinalTerm/table/manageTable.jsp
FinalTerm/table/msgSelectTable.html
FinalTerm/table/showTableDesign.jsp
FinalTerm/table/showTableList.jsp
FinalTerm/table/submenuTable.jsp
FinalTerm/table/images/btn_addfield_1.gif
FinalTerm/table/images/btn_addfield_2.gif
FinalTerm/table/images/btn_addfield_3.gif
FinalTerm/table/images/btn_cancel_1.gif
FinalTerm/table/images/btn_cancel_2.gif
FinalTerm/table/images/btn_cancel_3.gif
FinalTerm/table/images/btn_close_1.gif
FinalTerm/table/images/btn_close_2.gif
FinalTerm/table/images/btn_close_3.gif
FinalTerm/table/images/btn_createtable_1.gif
FinalTerm/table/images/btn_createtable_2.gif
FinalTerm/table/images/btn_createtable_3.gif
FinalTerm/table/images/btn_delete_1.gif
FinalTerm/table/images/btn_delete_2.gif
FinalTerm/table/images/btn_delete_3.gif
FinalTerm/table/images/btn_dropfield_1.gif
FinalTerm/table/images/btn_dropfield_2.gif
FinalTerm/table/images/btn_dropfield_3.gif
FinalTerm/table/images/btn_input_1.gif
FinalTerm/table/images/btn_input_2.gif
FinalTerm/table/images/btn_input_3.gif
FinalTerm/table/images/button_logout_1.gif
FinalTerm/table/images/button_logout_2.gif
FinalTerm/table/images/icon1.gif
FinalTerm/table/images/icon2.gif
FinalTerm/table/images/mainmenu_bg1.gif
FinalTerm/table/images/mainmenu_bg2.gif
FinalTerm/table/images/mainmenu_bg3.gif
FinalTerm/table/images/stitle_createtable.gif
FinalTerm/table/images/stitle_deletetable.gif
FinalTerm/table/images/stitle_selecttable.gif
FinalTerm/table/images/stitle_tabledesign.gif
FinalTerm/table/images/submenu_bg.gif
FinalTerm/table/images/submenu_managetable.gif
FinalTerm/table/images/title_login.gif
FinalTerm/table/images/title_managetable.gif
FinalTerm/table/images/tm_altertable_1.gif
FinalTerm/table/images/tm_altertable_2.gif
FinalTerm/table/images/tm_createtable_1.gif
FinalTerm/table/images/tm_createtable_2.gif
FinalTerm/table/images/tm_droptable_1.gif
FinalTerm/table/images/tm_droptable_2.gif
FinalTerm/table/images/tm_selecttable_1.gif
FinalTerm/table/images/tm_selecttable_2.gif
FinalTerm/WEB-INF/web.xml
FinalTerm/WEB-INF/classes/WebDBMS.class
FinalTerm/WEB-INF/source/WebDBMS.java

전체 목록 보기