[도서관리사이트]Spring MVC(MYSQL DB), Mybatis, JAVA, JSP, BootStrap, Jquery(AJAX, JSON)

소개글

안녕하세요. 현직 개발자입니다.
Spring MVC, Mybatis, JAVA, JSP, BootStrap, Jquery(AJAX, JSON) , MYSQL DB 기술을 이용한 도서관리사이트입니다.

로그인은 권한 A(아이디 : admin, 비밀번호 : admin)으로 접속하시거나,
그외에 일반유저(ranone/ranone, love86n/love86n)로 접속하시면 됩니다.
TB_COM_USER에서 조회해서 확인하시면 됩니다.

샘플 도서데이터는 다수 수집해 놓았습니다.

도서관리 프로세스

-대출
대출책수는 4권입니다.
대출기간은 대출일로부터 3일 입니다.

-대출연장신청
대출연장신청은 3일의 대출기간을 반납예정일로부터 1일 연기가능하고,
해당도서의 연장 신청은 1회만 가능 합니다.

대출연장신청이 안되는 경우
1. 연기하고자 하는 도서를 다른이용자가 대출예약한 경우
2. 이미 해당도서를 연장하였을 경우

-예약
다른 이용자가 대출중인 도서를 3권까지 예약할 수 있습니다.

1.관리자가 다른이용자의 대출신청에 대해 대출승인을 해야
자신이 예약신청한 도서정보를 예약현황에서 데이터를 볼 수 있습니다.
(예약은 다른이용자가 대출신청중에도 가능)

도서관리 주요기능 및 기술

1. 공통

- 로그인(ID찾기, 패스워드찾기) / 로그아웃
- 회원가입, 회원정보 수정
- 데이터 검색 및 페이징(BootStrap 테이블이용)
- 약50,000건 정도의 우편번호 데이터 삽입 후, 모달페이지에서 동으로 검색

2. 사용자

- 도서대출(대출신청, 예약신청)
- 대출연장신청
- 예약취소기능

3. 관리자

- 도서관리(신규도서등록, 기존도서정보 수정)
- 대출관리(대출승인, 반납처리)
- 전체통계 도넛 형식, 바 형식
(장르별 도서현황, 도서현황(대출신청, 대출승인, 예약), 출판사별 도서현황, 저자별 도서현황)

간단하게 구조를 설명드리면
전체 프레임워크는 Spring이며, Tomcat, MYSQL DB 등을 사용합니다.
자바(Controller, Service, ServiceImpl, Bean) + xml(mybatis) 로 셋트가 구성되어있습니다.
화면단은 JSP(BootStrap 이용)입니다.

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

common.js(jquery구현) 주요기능

- 입력단 뒤로가기 버튼 방지
- 로그인체크
- validation자동체크(백그라운드에 애니메이션 효과(red))
- 입력단 필수값표시(required속성이용(html5)) 앞단에 빨간*표시
- 입력단 숫자만 입력해야 할 경우 스크립트 처리

주요기술

- 비동기 사진업로드
- 비동기 JSON처리

코드 테이블이 따로 존재합니다.
주로 현업기술이 많이 들어가있지만 어렵지 않습니다.

개인적으로 졸작이나, 중간/기말고사 프로젝트, 학습용, 웹개발자가 되고자 하시는분들한테 유용한 프로젝트라고 생각합니다.

문의는 [구매문의]를 이용해주시기바랍니다.

많은 이용바랍니다.

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

컴파일 실행환경

JAVA SDK1.7, MYSQL, ECLIPSE

압축파일 내 파일목록

.classpath
.project
.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
.springBeans
.svn/entries
.svn/format
.svn/wc.db
basicsetting.html
pom.xml
post/post.bad
post/post.csv
post/post.ctl
post/post.log
sql/library(mysql).sql
src/main/java/conf/dtd/mybatis-3-config.dtd
src/main/java/conf/dtd/mybatis-3-mapper.dtd
src/main/java/conf/sql-book.xml
src/main/java/conf/sql-code.xml
src/main/java/conf/sql-rent.xml
src/main/java/conf/sql-reserve.xml
src/main/java/conf/sql-user.xml
src/main/java/conf/SqlMapConfig.xml
src/main/java/log4j.properties
src/main/java/work/book/BookBean.java
src/main/java/work/book/BookController.java
src/main/java/work/book/BookDAO.java
src/main/java/work/book/BookService.java
src/main/java/work/book/BookServiceImpl.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/rent/RentBean.java
src/main/java/work/rent/RentController.java
src/main/java/work/rent/RentDAO.java
src/main/java/work/rent/RentService.java
src/main/java/work/rent/RentServiceImpl.java
src/main/java/work/reserve/ReserveBean.java
src/main/java/work/reserve/ReserveController.java
src/main/java/work/reserve/ReserveDAO.java
src/main/java/work/reserve/ReserveService.java
src/main/java/work/reserve/ReserveServiceImpl.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/webapp/WEB-INF/mvc-config.xml
src/main/webapp/WEB-INF/view/showMessage.jsp
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/sql-book.xml
target/classes/conf/sql-code.xml
target/classes/conf/sql-rent.xml
target/classes/conf/sql-reserve.xml
target/classes/conf/sql-user.xml
target/classes/conf/SqlMapConfig.xml
target/classes/log4j.properties
target/classes/work/book/BookBean.class
target/classes/work/book/BookController.class
target/classes/work/book/BookDAO.class
target/classes/work/book/BookService.class
target/classes/work/book/BookServiceImpl.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/rent/RentBean.class
target/classes/work/rent/RentController.class
target/classes/work/rent/RentDAO.class
target/classes/work/rent/RentService.class
target/classes/work/rent/RentServiceImpl.class
target/classes/work/reserve/ReserveBean.class
target/classes/work/reserve/ReserveController.class
target/classes/work/reserve/ReserveDAO.class
target/classes/work/reserve/ReserveService.class
target/classes/work/reserve/ReserveServiceImpl.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/m2e-wtp/web-resources/META-INF/MANIFEST.MF
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
WebContent/backgroundImage/blueSky.jpg
WebContent/backgroundImage/book.png
WebContent/backgroundImage/defaultpic.png
WebContent/backgroundImage/voteBox.png
WebContent/book/bookListR.jsp
WebContent/book/main.jsp
WebContent/bookextend/extendListR.jsp
WebContent/bookImage/21s.jpg
WebContent/bookImage/bugslife.jpg
WebContent/bookImage/buyuhistory.jpg
WebContent/bookImage/centralpark.jpg
WebContent/bookImage/demian.jpg
WebContent/bookImage/die of mockingbird.jpg
WebContent/bookImage/dreamofbird.jpg
WebContent/bookImage/ethicalCost.jpg
WebContent/bookImage/fairtrade.jpg
WebContent/bookImage/fastcalculate.jpg
WebContent/bookImage/foretdesmanes.jpg
WebContent/bookImage/girlonthetrain.jpg
WebContent/bookImage/haebang.jpg
WebContent/bookImage/historyAndBlame.jpg
WebContent/bookImage/hunter.jpg
WebContent/bookImage/husbandsecret.jpg
WebContent/bookImage/jeju4.3.jpg
WebContent/bookImage/kongsik.jpg
WebContent/bookImage/koreaandjapan.jpg
WebContent/bookImage/lime.jpg
WebContent/bookImage/maskmurder.jpg
WebContent/bookImage/mykoreanhistory.jpg
WebContent/bookImage/oldSeoul.jpg
WebContent/bookImage/originofpeople.jpg
WebContent/bookImage/physics.jpg
WebContent/bookImage/recordapeople.jpg
WebContent/bookImage/sayEin.jpg
WebContent/bookImage/selfishDNA.jpg
WebContent/bookImage/tempgo.jpg
WebContent/bookImage/verter.jpg
WebContent/bookImage/whyhungry.jpg
WebContent/bookImage/whyKorea.jpg
WebContent/bookImage/youngprince.jpg
WebContent/bookImage/yurasia.jpg
WebContent/bookImage/yusin.jpg
WebContent/bookmanage/bookListRForManage.jsp
WebContent/bookmanage/bookListRForRent.jsp
WebContent/bookmanage/bookRegisterC.jsp
WebContent/bookmanage/bookRegisterU.jsp
WebContent/bookreserve/bookListRForReserve.jsp
WebContent/common/foot.jsp
WebContent/common/top.jsp
WebContent/css/bootstrap-theme.css
WebContent/css/bootstrap.min.css
WebContent/css/common.css
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/jquery-ui.css
WebContent/css/jquery-ui.theme.css
WebContent/css/morris.css
WebContent/css/plugins/dataTables.bootstrap.css
WebContent/css/plugins/metisMenu/metisMenu.css
WebContent/css/plugins/metisMenu/metisMenu.min.css
WebContent/css/plugins/morris.css
WebContent/css/plugins/social-buttons.css
WebContent/css/plugins/timeline.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-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/fonts/FontAwesome.otf
WebContent/font-awesome-4.4.0/HELP-US-OUT.txt
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/font-awesome.scss
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/fonts/glyphicons-halflings-regular.eot
WebContent/fonts/glyphicons-halflings-regular.svg
WebContent/fonts/glyphicons-halflings-regular.ttf
WebContent/fonts/glyphicons-halflings-regular.woff
WebContent/index.html
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/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/raphael.js
WebContent/js/sb-admin-2.js
WebContent/META-INF/MANIFEST.MF
WebContent/statistics/statisticsR.jsp
WebContent/user/idFind.jsp
WebContent/user/login.jsp
WebContent/user/pwFind.jsp
WebContent/user/userC.jsp
WebContent/user/userU.jsp
WebContent/WEB-INF/dispatch-servlet.xml
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/web.xml
도서관리사이트 메뉴얼.txt

전체 목록 보기

참고 자료

없음