[게시판프로젝트]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 기술을 이용한 게시판프로젝트입니다.
유저정보는 TB_COM_USER에서 조회해서 확인하시면 됩니다.
샘플 유저정보 및 투표데이터는 전부 쿼리파일에 있습니다.
게시판프로젝트 주요기능 및 기술
1. 공통
- 로그인(ID찾기, 패스워드찾기) / 로그아웃
- 회원가입, 회원정보 수정
- 데이터 검색 및 페이징(BootStrap 테이블이용)
- 약50000건 정도의 우편번호 데이터 삽입 후, 모달페이지에서 동으로 검색
2. main페이지
- 게시판 데이터 조회(유저이미지, 게시판본문, 데이터작성시간(몇시간전, 며칠전으로 표시)
- 조회순Top5, 좋아요순 Top5, 최신순
- 최근접속자리스트 Top5
3. 새 글 쓰기
- 제목, 본문 입력
4. 게시글상세
- 게시글코드, 좋아요 수, 조회수, 댓글수 표시
- 모바일형식의 댓글UI 구현
간단하게 구조를 설명드리면
전체 프레임워크는 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)) 앞단에 빨간*표시
주요기술
- 비동기 사진업로드
- 비동기 JSON처리
코드 테이블이 따로 존재합니다.
주로 현업기술이 많이 들어가있지만 어렵지 않습니다.
개인적으로 졸작이나, 중간/기말고사 프로젝트, 학습용, 웹개발자가 되고자 하시는분들한테 유용한 프로젝트라고 생각합니다.
압축파일 내에 메뉴얼.txt 보시고 메일로 문의하시기 바랍니다.
많은 이용바랍니다.
p.s) 프로젝트 import하시고 clean한번 해주시기 바랍니다.
컴파일 실행환경
JAVA SDK 1.7, TOMCAT, ORACLE, 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/backgroundImage/main_r1_06.jpg
WebContent/backgroundImage/vote1.png
WebContent/backgroundImage/vote2.png
WebContent/backgroundImage/vote3.png
WebContent/board/boardListR.jsp
WebContent/board/boardR.jsp
WebContent/board/boardRegisterC.jsp
WebContent/board/boardRegisterU.jsp
WebContent/board/main.jsp
WebContent/common/foot.jsp
WebContent/common/top.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/idFind.jsp
WebContent/user/login.jsp
WebContent/user/pwFind.jsp
WebContent/user/userC.jsp
WebContent/user/userU.jsp
WebContent/userImg/admin.png
WebContent/userImg/ksy.png
WebContent/userImg/love86n.png
WebContent/userImg/ranone.png
WebContent/userImg/sawol.png
WebContent/userImg/shm.png
WebContent/index.html
WebContent/오라클 첫시작.txt
post/post.bad
post/post.csv
post/post.ctl
post/post.log
sql/board.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-board.xml
src/main/java/conf/sql-code.xml
src/main/java/conf/sql-mark.xml
src/main/java/conf/sql-reply.xml
src/main/java/conf/sql-user.xml
src/main/java/work/board/BoardBean.java
src/main/java/work/board/BoardController.java
src/main/java/work/board/BoardDAO.java
src/main/java/work/board/BoardService.java
src/main/java/work/board/BoardServiceImpl.java
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/mark/MarkBean.java
src/main/java/work/mark/MarkController.java
src/main/java/work/mark/MarkDAO.java
src/main/java/work/mark/MarkService.java
src/main/java/work/mark/MarkServiceImpl.java
src/main/java/work/reply/ReplyBean.java
src/main/java/work/reply/ReplyController.java
src/main/java/work/reply/ReplyDAO.java
src/main/java/work/reply/ReplyService.java
src/main/java/work/reply/ReplyServiceImpl.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-board.xml
target/classes/conf/sql-code.xml
target/classes/conf/sql-mark.xml
target/classes/conf/sql-reply.xml
target/classes/conf/sql-user.xml
target/classes/work/board/BoardBean.class
target/classes/work/board/BoardController.class
target/classes/work/board/BoardDAO.class
target/classes/work/board/BoardService.class
target/classes/work/board/BoardServiceImpl.class
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/mark/MarkBean.class
target/classes/work/mark/MarkController.class
target/classes/work/mark/MarkDAO.class
target/classes/work/mark/MarkService.class
target/classes/work/mark/MarkServiceImpl.class
target/classes/work/reply/ReplyBean.class
target/classes/work/reply/ReplyController.class
target/classes/work/reply/ReplyDAO.class
target/classes/work/reply/ReplyService.class
target/classes/work/reply/ReplyServiceImpl.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
.classpath
.project
.springBeans
Board.png
pom.xml
게시판사이트 메뉴얼.txt
.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/backgroundImage/main_r1_06.jpg
WebContent/backgroundImage/vote1.png
WebContent/backgroundImage/vote2.png
WebContent/backgroundImage/vote3.png
WebContent/board/boardListR.jsp
WebContent/board/boardR.jsp
WebContent/board/boardRegisterC.jsp
WebContent/board/boardRegisterU.jsp
WebContent/board/main.jsp
WebContent/common/foot.jsp
WebContent/common/top.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/idFind.jsp
WebContent/user/login.jsp
WebContent/user/pwFind.jsp
WebContent/user/userC.jsp
WebContent/user/userU.jsp
WebContent/userImg/admin.png
WebContent/userImg/ksy.png
WebContent/userImg/love86n.png
WebContent/userImg/ranone.png
WebContent/userImg/sawol.png
WebContent/userImg/shm.png
WebContent/index.html
WebContent/오라클 첫시작.txt
post/post.bad
post/post.csv
post/post.ctl
post/post.log
sql/board.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-board.xml
src/main/java/conf/sql-code.xml
src/main/java/conf/sql-mark.xml
src/main/java/conf/sql-reply.xml
src/main/java/conf/sql-user.xml
src/main/java/work/board/BoardBean.java
src/main/java/work/board/BoardController.java
src/main/java/work/board/BoardDAO.java
src/main/java/work/board/BoardService.java
src/main/java/work/board/BoardServiceImpl.java
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/mark/MarkBean.java
src/main/java/work/mark/MarkController.java
src/main/java/work/mark/MarkDAO.java
src/main/java/work/mark/MarkService.java
src/main/java/work/mark/MarkServiceImpl.java
src/main/java/work/reply/ReplyBean.java
src/main/java/work/reply/ReplyController.java
src/main/java/work/reply/ReplyDAO.java
src/main/java/work/reply/ReplyService.java
src/main/java/work/reply/ReplyServiceImpl.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-board.xml
target/classes/conf/sql-code.xml
target/classes/conf/sql-mark.xml
target/classes/conf/sql-reply.xml
target/classes/conf/sql-user.xml
target/classes/work/board/BoardBean.class
target/classes/work/board/BoardController.class
target/classes/work/board/BoardDAO.class
target/classes/work/board/BoardService.class
target/classes/work/board/BoardServiceImpl.class
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/mark/MarkBean.class
target/classes/work/mark/MarkController.class
target/classes/work/mark/MarkDAO.class
target/classes/work/mark/MarkService.class
target/classes/work/mark/MarkServiceImpl.class
target/classes/work/reply/ReplyBean.class
target/classes/work/reply/ReplyController.class
target/classes/work/reply/ReplyDAO.class
target/classes/work/reply/ReplyService.class
target/classes/work/reply/ReplyServiceImpl.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
.classpath
.project
.springBeans
Board.png
pom.xml
게시판사이트 메뉴얼.txt