[수강신청프로그램]Spring MVC(Oracle DB), Mybatis, JAVA, JSP, HTML, CSS, BootStrap, Jquery(AJAX, JSON)

소개글

안녕하세요. 현직 개발자입니다.
Spring MVC, Mybatis, JAVA, JSP, HTML, CSS, BootStrap, Jquery(AJAX, JSON) , Oracle 기술을 이용한 수강신청프로그램 웹사이트입니다.

로그인은 권한 A(관리자)(아이디 : admin, 비밀번호 : admin)으로 접속하시거나,
권한 P(교수)으로 접속하시거나,
권한 S(수강생)으로 접속하시면 됩니다.

TB_COM_USER에서 조회해서 확인하시면 됩니다.
샘플 유저정보 및 과목데이터는 전부 쿼리파일에 있습니다.

수강신청프로그램 웹사이트 주요기능 및 기술

1. 공통
- 로그인 / 로그아웃
- 테이블 검색및 페이징(BootStrap table 기본기능)

2. 수강생
- 수강신청리스트 조회(과목명, 학점, 신청인원, 교실, 요일, 교시, 과목분류(교필,전필,전선,교선))
- 실시간 수강신청(오른쪽 UI에 수강신청과목 바로 갱신)
정원이 꽉차거나 본인이 같은요일 같은시간에 이미 신청한 과목 신청불가
- 수강신청 취소
- 시간표조회

3. 교수
- 수강신청리스트 조회
- 실시간 담당과목 신청
다른교수가 이미 해당과목을 신청했거나 본인이 같은요일 같은시간에 이미 신청한 과목 신청불가
- 담당과목신청 취소
- 시간표 조회

4. 관리자
- 과목개설(새로운 과목 등록 및 수정)

간단하게 구조를 설명드리면
전체 프레임워크는 Spring이며, Tomcat, Oracle 등을 사용합니다.

자바(Controller, Service, ServiceImpl, Bean) + xml(mybatis) 로 셋트가 구성되어있습니다.
화면단은 JSP(BootStrap 이용)입니다.

Sciprt는 Jquery가 95%를 차지하고 있고요.

입력단 validation 체크라던가 공통(common.js)으로 빼놨으니, 소스분석하실때 보시면 됩니다.
입력단 validation은 화면마다 한줄처리로 가능하게 만들어놨습니다.

common.js(jquery구현) 주요기능
- 입력단 뒤로가기 버튼 방지
- 로그인체크
- validation자동체크(백그라운드에 애니메이션 효과(red))
- 입력단 필수값표시(required속성이용(html5)) 앞단에 빨간*표시
- 숫자 입력단에 숫자이외 타이핑 금지

주요기술
- AJAX(비동기) 처리

코드 테이블이 따로 존재합니다.

주로 현업기술이 많이 들어가있지만 어렵지 않습니다.
개인적으로 졸작이나, 중간/기말고사 프로젝트, 학습용, 웹개발자가 되고자 하시는분들한테 유용한 프로젝트라고 생각합니다.

압축파일 내에 메뉴얼.txt 보시고 [ 메일 ] 로 문의하시기 바랍니다.
많은 이용바랍니다.

p.s) 프로젝트 import하시고 clean한번 해주시기 바랍니다.

컴파일 실행환경

JAVA SDK 1.7, ORACLE, TOMCAT, ECLIPSE

압축파일 내 파일목록

.settings/.jsdtscope
.settings/org.eclipse.core.resources.prefs
.settings/org.eclipse.jdt.core.prefs
.settings/org.eclipse.m2e.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
WebContent/META-INF/MANIFEST.MF
WebContent/WEB-INF/lib/json-simple-1.1.1.jar
WebContent/WEB-INF/lib/jstl.jar
WebContent/WEB-INF/lib/log4j-1.2.17.jar
WebContent/WEB-INF/lib/mybatis-3.2.2.jar
WebContent/WEB-INF/lib/ojdbc14.jar
WebContent/WEB-INF/lib/standard.jar
WebContent/WEB-INF/dispatch-servlet.xml
WebContent/WEB-INF/web.xml
WebContent/backgroundImage/blueSky.jpg
WebContent/backgroundImage/defaultpic.png
WebContent/common/top.jsp
WebContent/course/courseListRForAdmin.jsp
WebContent/course/courseListRForProfessor.jsp
WebContent/course/courseListRForStudent.jsp
WebContent/course/courseRForProfessor.jsp
WebContent/course/courseRForStudent.jsp
WebContent/course/courseRegisterC.jsp
WebContent/course/courseRegisterU.jsp
WebContent/course/main.jsp
WebContent/css/images/ui-bg_diagonals-thick_18_b81900_40x40.png
WebContent/css/images/ui-bg_diagonals-thick_20_666666_40x40.png
WebContent/css/images/ui-bg_flat_10_000000_40x100.png
WebContent/css/images/ui-bg_glass_100_f6f6f6_1x400.png
WebContent/css/images/ui-bg_glass_100_fdf5ce_1x400.png
WebContent/css/images/ui-bg_glass_65_ffffff_1x400.png
WebContent/css/images/ui-bg_gloss-wave_35_f6a828_500x100.png
WebContent/css/images/ui-bg_highlight-soft_100_eeeeee_1x100.png
WebContent/css/images/ui-bg_highlight-soft_75_ffe45c_1x100.png
WebContent/css/images/ui-icons_222222_256x240.png
WebContent/css/images/ui-icons_228ef1_256x240.png
WebContent/css/images/ui-icons_ef8c08_256x240.png
WebContent/css/images/ui-icons_ffd27a_256x240.png
WebContent/css/images/ui-icons_ffffff_256x240.png
WebContent/css/plugins/metisMenu/metisMenu.css
WebContent/css/plugins/metisMenu/metisMenu.min.css
WebContent/css/plugins/dataTables.bootstrap.css
WebContent/css/plugins/morris.css
WebContent/css/plugins/social-buttons.css
WebContent/css/plugins/timeline.css
WebContent/css/bootstrap-theme.css
WebContent/css/bootstrap.min.css
WebContent/css/common.css
WebContent/css/jquery-ui.css
WebContent/css/jquery-ui.theme.css
WebContent/css/morris.css
WebContent/css/process.css
WebContent/css/sb-admin-2.css
WebContent/font-awesome-4.4.0/css/font-awesome.css
WebContent/font-awesome-4.4.0/css/font-awesome.min.css
WebContent/font-awesome-4.4.0/fonts/FontAwesome.otf
WebContent/font-awesome-4.4.0/fonts/fontawesome-webfont.eot
WebContent/font-awesome-4.4.0/fonts/fontawesome-webfont.svg
WebContent/font-awesome-4.4.0/fonts/fontawesome-webfont.ttf
WebContent/font-awesome-4.4.0/fonts/fontawesome-webfont.woff
WebContent/font-awesome-4.4.0/fonts/fontawesome-webfont.woff2
WebContent/font-awesome-4.4.0/less/animated.less
WebContent/font-awesome-4.4.0/less/bordered-pulled.less
WebContent/font-awesome-4.4.0/less/core.less
WebContent/font-awesome-4.4.0/less/fixed-width.less
WebContent/font-awesome-4.4.0/less/font-awesome.less
WebContent/font-awesome-4.4.0/less/icons.less
WebContent/font-awesome-4.4.0/less/larger.less
WebContent/font-awesome-4.4.0/less/list.less
WebContent/font-awesome-4.4.0/less/mixins.less
WebContent/font-awesome-4.4.0/less/path.less
WebContent/font-awesome-4.4.0/less/rotated-flipped.less
WebContent/font-awesome-4.4.0/less/stacked.less
WebContent/font-awesome-4.4.0/less/variables.less
WebContent/font-awesome-4.4.0/scss/_animated.scss
WebContent/font-awesome-4.4.0/scss/_bordered-pulled.scss
WebContent/font-awesome-4.4.0/scss/_core.scss
WebContent/font-awesome-4.4.0/scss/_fixed-width.scss
WebContent/font-awesome-4.4.0/scss/_icons.scss
WebContent/font-awesome-4.4.0/scss/_larger.scss
WebContent/font-awesome-4.4.0/scss/_list.scss
WebContent/font-awesome-4.4.0/scss/_mixins.scss
WebContent/font-awesome-4.4.0/scss/_path.scss
WebContent/font-awesome-4.4.0/scss/_rotated-flipped.scss
WebContent/font-awesome-4.4.0/scss/_stacked.scss
WebContent/font-awesome-4.4.0/scss/_variables.scss
WebContent/font-awesome-4.4.0/scss/font-awesome.scss
WebContent/font-awesome-4.4.0/HELP-US-OUT.txt
WebContent/fonts/glyphicons-halflings-regular.eot
WebContent/fonts/glyphicons-halflings-regular.svg
WebContent/fonts/glyphicons-halflings-regular.ttf
WebContent/fonts/glyphicons-halflings-regular.woff
WebContent/fonts/glyphicons-halflings-regular.woff2
WebContent/js/plugins/dataTables/dataTables.bootstrap.js
WebContent/js/plugins/dataTables/jquery.dataTables.js
WebContent/js/plugins/flot/excanvas.min.js
WebContent/js/plugins/flot/flot-data.js
WebContent/js/plugins/flot/jquery.flot.pie.js
WebContent/js/plugins/flot/jquery.flot.resize.js
WebContent/js/plugins/flot/jquery.flot.tooltip.min.js
WebContent/js/plugins/metisMenu/metisMenu.js
WebContent/js/plugins/metisMenu/metisMenu.min.js
WebContent/js/plugins/morris/morris-data.js
WebContent/js/plugins/morris/morris.js
WebContent/js/plugins/morris/morris.min.js
WebContent/js/bootstrap.min.js
WebContent/js/common.js
WebContent/js/jquery-1.9.1.js
WebContent/js/jquery-ui.js
WebContent/js/jquery.form.js
WebContent/js/jquery.js
WebContent/js/jquery.layout.min.js
WebContent/js/morris.min.js
WebContent/js/raphael.js
WebContent/js/sb-admin-2.js
WebContent/user/login.jsp
WebContent/index.html
WebContent/오라클 첫시작.txt
post/post.bad
post/post.csv
post/post.ctl
post/post.log
sql/course.sql
src/main/java/conf/dtd/mybatis-3-config.dtd
src/main/java/conf/dtd/mybatis-3-mapper.dtd
src/main/java/conf/SqlMapConfig.xml
src/main/java/conf/sql-code.xml
src/main/java/conf/sql-course.xml
src/main/java/conf/sql-professorreg.xml
src/main/java/conf/sql-studentreg.xml
src/main/java/conf/sql-user.xml
src/main/java/work/code/CodeBean.java
src/main/java/work/code/CodeDAO.java
src/main/java/work/code/CodeService.java
src/main/java/work/code/CodeServiceImpl.java
src/main/java/work/course/CourseBean.java
src/main/java/work/course/CourseController.java
src/main/java/work/course/CourseDAO.java
src/main/java/work/course/CourseService.java
src/main/java/work/course/CourseServiceImpl.java
src/main/java/work/professorreg/ProfessorregBean.java
src/main/java/work/professorreg/ProfessorregController.java
src/main/java/work/professorreg/ProfessorregDAO.java
src/main/java/work/professorreg/ProfessorregImpl.java
src/main/java/work/professorreg/ProfessorregService.java
src/main/java/work/studentreg/StudentregBean.java
src/main/java/work/studentreg/StudentregController.java
src/main/java/work/studentreg/StudentregDAO.java
src/main/java/work/studentreg/StudentregImpl.java
src/main/java/work/studentreg/StudentregService.java
src/main/java/work/user/UserBean.java
src/main/java/work/user/UserController.java
src/main/java/work/user/UserDAO.java
src/main/java/work/user/UserService.java
src/main/java/work/user/UserServiceImpl.java
src/main/java/log4j.properties
src/main/webapp/WEB-INF/view/showMessage.jsp
src/main/webapp/WEB-INF/mvc-config.xml
src/main/webapp/WEB-INF/web.xml
target/classes/conf/dtd/mybatis-3-config.dtd
target/classes/conf/dtd/mybatis-3-mapper.dtd
target/classes/conf/SqlMapConfig.xml
target/classes/conf/sql-code.xml
target/classes/conf/sql-course.xml
target/classes/conf/sql-professorreg.xml
target/classes/conf/sql-studentreg.xml
target/classes/conf/sql-user.xml
target/classes/work/code/CodeBean.class
target/classes/work/code/CodeDAO.class
target/classes/work/code/CodeService.class
target/classes/work/code/CodeServiceImpl.class
target/classes/work/course/CourseBean.class
target/classes/work/course/CourseController.class
target/classes/work/course/CourseDAO.class
target/classes/work/course/CourseService.class
target/classes/work/course/CourseServiceImpl.class
target/classes/work/professorreg/ProfessorregBean.class
target/classes/work/professorreg/ProfessorregController.class
target/classes/work/professorreg/ProfessorregDAO.class
target/classes/work/professorreg/ProfessorregImpl.class
target/classes/work/professorreg/ProfessorregService.class
target/classes/work/studentreg/StudentregBean.class
target/classes/work/studentreg/StudentregController.class
target/classes/work/studentreg/StudentregDAO.class
target/classes/work/studentreg/StudentregImpl.class
target/classes/work/studentreg/StudentregService.class
target/classes/work/user/UserBean.class
target/classes/work/user/UserController.class
target/classes/work/user/UserDAO.class
target/classes/work/user/UserService.class
target/classes/work/user/UserServiceImpl.class
target/classes/log4j.properties
target/m2e-wtp/web-resources/META-INF/maven/org.springframework.samples.service.service/spring/pom.properties
target/m2e-wtp/web-resources/META-INF/maven/org.springframework.samples.service.service/spring/pom.xml
target/m2e-wtp/web-resources/META-INF/MANIFEST.MF
.classpath
.project
.springBeans
pom.xml
수강신청프로그램.JPG
수강신청프로그램.txt

전체 목록 보기

참고 자료

없음