[쇼핑몰(문구점)]Spring MVC(MYSQL DB), Mybatis, JAVA, JSP, HTML, CSS, BootStrap, Jquery(AJAX, JSON)

소개글

안녕하세요. 현직 개발자입니다.
Spring MVC, Mybatis, JAVA, JSP, HTML, CSS, BootStrap, Jquery(AJAX, JSON) , MYSQL DB 기술을 이용한 문구점(쇼핑몰)사이트입니다.

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

샘플 유저정보 및 제품데이터는 전부 쿼리파일에 있습니다.


문구점사이트 주요기능 및 기술

1. 공통

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

2. 사용자

- 제품구매(바로구매, 장바구니)
- 제품구매후 주문서확인
- 제품구매후 댓글등록 및 삭제(모바일 형식의 댓글 UI), 평점등록(별모양 UI 사용)
- 구매내역
- 장바구니(장바구니에서 바로구매 기능, 리스트 삭제기능)

2. 관리자

- 재고관리(새로운 제품 등록 및 수정)
- 매출통계(제품 카테고리별, 항목별 매출 통계)
- 재고현황(카테고리별 재고현황, 제품 판매현황 통계)

간단하게 구조를 설명드리면
전체 프레임워크는 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처리

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

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

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

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

컴파일 실행환경

JAVA SDK1.7, ECLIPSE, MYSQL

압축파일 내 파일목록

.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
pom.xml
post/post.csv
sql/stationery(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-cart.xml
src/main/java/conf/sql-code.xml
src/main/java/conf/sql-example.xml
src/main/java/conf/sql-mark.xml
src/main/java/conf/sql-product.xml
src/main/java/conf/sql-reply.xml
src/main/java/conf/sql-sell.xml
src/main/java/conf/sql-user.xml
src/main/java/conf/SqlMapConfig.xml
src/main/java/log4j.properties
src/main/java/work/cart/CartBean.java
src/main/java/work/cart/CartController.java
src/main/java/work/cart/CartDAO.java
src/main/java/work/cart/CartService.java
src/main/java/work/cart/CartServiceImpl.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/product/ProductBean.java
src/main/java/work/product/ProductController.java
src/main/java/work/product/ProductDAO.java
src/main/java/work/product/ProductService.java
src/main/java/work/product/ProductServiceImpl.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/sell/SellBean.java
src/main/java/work/sell/SellController.java
src/main/java/work/sell/SellDAO.java
src/main/java/work/sell/SellService.java
src/main/java/work/sell/SellServiceImpl.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-cart.xml
target/classes/conf/sql-code.xml
target/classes/conf/sql-example.xml
target/classes/conf/sql-mark.xml
target/classes/conf/sql-product.xml
target/classes/conf/sql-reply.xml
target/classes/conf/sql-sell.xml
target/classes/conf/sql-user.xml
target/classes/conf/SqlMapConfig.xml
target/classes/log4j.properties
target/classes/work/cart/CartBean.class
target/classes/work/cart/CartController.class
target/classes/work/cart/CartDAO.class
target/classes/work/cart/CartService.class
target/classes/work/cart/CartServiceImpl.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/product/ProductBean.class
target/classes/work/product/ProductController.class
target/classes/work/product/ProductDAO.class
target/classes/work/product/ProductService.class
target/classes/work/product/ProductServiceImpl.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/sell/SellBean.class
target/classes/work/sell/SellController.class
target/classes/work/sell/SellDAO.class
target/classes/work/sell/SellService.class
target/classes/work/sell/SellServiceImpl.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/defaultpic.png
WebContent/backgroundImage/main_r1_06.jpg
WebContent/backgroundImage/vote1.png
WebContent/backgroundImage/vote2.png
WebContent/backgroundImage/vote3.png
WebContent/binderImg/f1.jpg
WebContent/binderImg/f2.jpg
WebContent/binderImg/f3.jpg
WebContent/binderImg/f4.jpg
WebContent/binderImg/f5.jpg
WebContent/binderImg/f6.jpg
WebContent/binderImg/f7.jpg
WebContent/binderImg/f8.jpg
WebContent/cart/cartListR.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/designImg/s1.jpg
WebContent/designImg/s10.jpg
WebContent/designImg/s11.jpg
WebContent/designImg/s12.jpg
WebContent/designImg/s2.jpg
WebContent/designImg/s3.jpg
WebContent/designImg/s4.jpg
WebContent/designImg/s5.jpg
WebContent/designImg/s6.jpg
WebContent/designImg/s7.jpg
WebContent/designImg/s8.jpg
WebContent/designImg/s9.jpg
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/fonts/glyphicons-halflings-regular.woff2
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/MYSQL 첫시작.txt
WebContent/officeImg/d1.jpg
WebContent/officeImg/d10.jpg
WebContent/officeImg/d2.jpg
WebContent/officeImg/d3.jpg
WebContent/officeImg/d4.jpg
WebContent/officeImg/d5.jpg
WebContent/officeImg/d6.jpg
WebContent/officeImg/d7.jpg
WebContent/officeImg/d8.jpg
WebContent/officeImg/d9.jpg
WebContent/penImg/p1.jpg
WebContent/penImg/p10.jpg
WebContent/penImg/p2.jpg
WebContent/penImg/p3.jpg
WebContent/penImg/p4.jpg
WebContent/penImg/p5.jpg
WebContent/penImg/p6.jpg
WebContent/penImg/p7.jpg
WebContent/penImg/p8.jpg
WebContent/penImg/p9.jpg
WebContent/product/main.jsp
WebContent/product/productListR.jsp
WebContent/product/productR.jsp
WebContent/sell/sellBuyListR.jsp
WebContent/sell/sellConfirmR.jsp
WebContent/sell/sellListR.jsp
WebContent/statistics/statisticsForSell.jsp
WebContent/statistics/statisticsForStock.jsp
WebContent/stockmanage/stockListR.jsp
WebContent/stockmanage/stockRegisterC.jsp
WebContent/stockmanage/stockRegisterU.jsp
WebContent/storageImg/c1.jpg
WebContent/storageImg/c2.jpg
WebContent/storageImg/c3.jpg
WebContent/storageImg/c4.jpg
WebContent/storageImg/c5.jpg
WebContent/storageImg/c6.jpg
WebContent/storageImg/c7.jpg
WebContent/storageImg/c8.jpg
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/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
[쇼핑몰]문구점.JPG
문구점쇼핑몰사이트 메뉴얼.txt

전체 목록 보기

참고 자료

없음