컴퓨터 부품 판매 쇼핑몰

소개글

인터넷 DB응용이라는 과목을 배울 때 학기 프로젝트로 진행했던 컴퓨터 부품 판매 쇼핑몰 입니다.
설계과정부터 소스까지 첨부했습니다. JSP프로젝트입니다.

목차

없음

본문내용

Shopping Mall에서는 신상품 코너와 공지 사항, 조립 PC 견적 공동 구매에 대한 처리가 되어 있다. SERVICE항목에는 사이트 맵이 있는데 전체 프로그램의 항목들을 보여주고, Q&A BANK 항목에는 자유게시판과 FAQ 부분이 있고, My page 항목에서는 회원 가입과 자기 정보 수정, 배송 조회, 로그인, 로그아웃 설정에 대한 사항들이 있다.
◎ 쇼핑몰 둘러보기
01 index.jsp 페이지는 사이트에 방문했을 때 처음 접속하는 부분이다. 상품 메뉴와 서비스메뉴, 상품 목록의 출력과 공지 사항을 보여준다.

02 회원 로그인 페이지는 아이디와 비밀번호를 이용해 로그인할 수 있는 곳.
03 회원 가입하기 페이지는 기본적인 신상 정보를 입력받아 회원 가입을 처리하는 기능을 갖추고 있다.

04 쇼핑몰 메뉴 페이지는 공지 사항, 신상품 코너, 조립 PC 견적, 공동 구매와 같은 기능을 처리하는 부분이다.

참고 자료

없음

압축파일 내 파일목록

TermProject.ppt
TermProject.doc
sql/coo_product.sql
sql/member.sql
sql/newcart.sql
sql/notice.sql
sql/product.sql
sql/product_category.sql
sql/qna.sql
sql/re_board.sql
sql/zipcode.sql
term/in2.jsp
term/index.html
term/index.jsp
term/inproduct.jsp
term/list.jsp
term/query.jsp
term/search_view.jsp
term/upload.jsp
term/board/delete.jsp
term/board/delete_confirm.jsp
term/board/delete_form.jsp
term/board/reply.jsp
term/board/reply_form.jsp
term/board/reply_list.jsp
term/board/show.jsp
term/board/update.jsp
term/board/update_form.jsp
term/board/write.jsp
term/board/write_form.jsp
term/board/img/bg_01.gif
term/board/img/bg_02.gif
term/board/img/f_b03.gif
term/board/img/h_b02.gif
term/board/img/h_b04.gif
term/board/img/h_b05.gif
term/board/img/j_b04.gif
term/board/img/j_b05.gif
term/board/img/j_b19.gif
term/board/img/j_b20.gif
term/board/img/j_bt07.gif
term/board/img/j_bt08.gif
term/board/img/j_bt09.gif
term/board/img/m_bt05.gif
term/board/img/m_bt06.gif
term/board/img/m_bt10.gif
term/board/img/m_bt11.gif
term/board/img/m_bt12.gif
term/board/img/reply.gif
term/board/img/u_bt08.gif
term/common/copyright.jsp
term/common/logo.jsp
term/common/main_left.jsp
term/common/main_menu_left.jsp
term/common/main_right.jsp
term/common/menubar.jsp
term/common/qna_menubar.jsp
term/common/r1.html
term/common/r2.html
term/common/r3.html
term/common/r4.html
term/common/style.css
term/common/u3.css
term/common/u3.js
term/FAQ/cancel.jsp
term/FAQ/cyber_cash.jsp
term/FAQ/faq.jsp
term/FAQ/mem_info.jsp
term/FAQ/order_acc.jsp
term/FAQ/ship_period.jsp
term/img/1_page_all.gif
term/img/1_PAGE_BACK.gif
term/img/1_page_back_blue.gif
term/img/1_page_back_gray.gif
term/img/1_page_left.gif
term/img/1_page_left_1.gif
term/img/1_page_left_1_back.gif
term/img/1_page_left_2.gif
term/img/1_page_left_2_back.gif
term/img/1_page_left_3.gif
term/img/1_page_left_3_back.gif
term/img/1_page_left_4.gif
term/img/1_page_left_4_back.gif
term/img/1_page_left_5.gif
term/img/1_page_left_5_back.gif
term/img/1_page_left_6.gif
term/img/1_page_left_6_back.gif
term/img/1_page_left_7.gif
term/img/1_page_left_7_back.gif
term/img/1_page_left_blue.gif
term/img/1_PAGE_LINE.gif
term/img/1_PAGE_MYPAGE.gif
term/img/1_page_mypage_BACK.gif
term/img/1_PAGE_QNABANK.gif
term/img/1_page_qnabank_BACK.gif
term/img/1_PAGE_SERVICE.gif
term/img/1_page_service_BACK.gif
term/img/1_PAGE_SHOPPINGMALL.gif
term/img/1_page_shoppingmall_BACK.gif
term/img/1_PAGE_SUB.gif
term/img/2_page_all.gif
term/img/2_PAGE_BACK.gif
term/img/2_page_back_gray.gif
term/img/2_page_back_orange.gif
term/img/2_page_bar.gif
term/img/2_PAGE_MYPAGE.gif
term/img/2_PAGE_MYPAGE_BACK.gif
term/img/2_PAGE_QNABANK.gif
term/img/2_PAGE_QNABANK_BACK.gif
term/img/2_PAGE_SERVICE.gif
term/img/2_PAGE_SERVICE_BACK.gif
term/img/2_PAGE_SHOPPINGMALL.gif
term/img/2_page_shoppingmall_BACK.gif
term/img/2_PAGE_SUB.gif
term/img/3_page_all copy.gif
term/img/3_PAGE_BACK.gif
term/img/3_page_back_gray.gif
term/img/3_page_back_green.gif
term/img/3_page_bar.gif
term/img/3_PAGE_MYPAGE.gif
term/img/3_page_mypage_back.gif
term/img/3_PAGE_QNABANK.gif
term/img/3_PAGE_QNABANK_back.gif
term/img/3_PAGE_SERVICE.gif
term/img/3_page_service_back.gif
term/img/3_PAGE_SHOPPINGMALL.gif
term/img/3_page_shoppingmall_back.gif
term/img/3_PAGE_SUB.gif
term/img/4_page_all.gif
term/img/4_page_back_bora.gif
term/img/4_page_back_gray.gif
term/img/4_PAGE_MYPAGE.gif
term/img/4_page_mypage_back.gif
term/img/4_PAGE_QNABANK.gif
term/img/4_page_qnabank_back.gif
term/img/4_PAGE_SERVICE.gif
term/img/4_page_service_back.gif
term/img/4_PAGE_SHOPPINGMALL.gif
term/img/4_page_shoppingmall_back.gif
term/img/4_PAGE_SUB.gif
term/img/696601_T1.jpg
term/img/700087_T1.jpg
term/img/710573_M1.jpg
term/img/answ.gif
term/img/answ1.gif
term/img/back.bmp
term/img/basket_approval.gif
term/img/basket_del.gif
term/img/basket_previous.gif
term/img/basket_shopping.gif
term/img/bg-black.gif
term/img/bg-line01(1).gif
term/img/bg-line01.gif
term/img/bg-main.gif
term/img/box-dep5-sm-bgL.gif
term/img/box-dep5-sm-bgR.gif
term/img/box-dep5-sm-btC.gif
term/img/box-dep5-sm-btL.gif
term/img/box-dep5-sm-btR.gif
term/img/box-dep5-sm-topC.gif
term/img/box-dep5-sm-topL.gif
term/img/box-dep5-sm-topR.gif
term/img/box-dep5-spp-btC.gif
term/img/box-dep5-spp-btL.gif
term/img/box-dep5-spp-btR.gif
term/img/box-dep5-spp-topL.gif
term/img/box-dep5-spp-topR.gif
term/img/buttn-top.gif
term/img/b_all_buy.gif
term/img/b_member_reg.gif
term/img/b_new_pro.gif
term/img/b_pc_price.gif
term/img/cart.gif
term/img/dep-t-icon(1).gif
term/img/dep-t-icon.gif
term/img/dep-t-jmeshop.gif
term/img/dep-Tline-bgBlue(1).gif
term/img/dep-Tline-bgBlue.gif
term/img/dep-topT-cptsw.gif
term/img/dep05-t-ggcc.gif
term/img/dep05-t-ggspp.gif
term/img/dep05-t-spsssm.gif
term/img/go_b.gif
term/img/hanjin.gif
term/img/icon-arrowBblue.gif
term/img/icon-arrowTblue.gif
term/img/icon-dep5-brgm.gif
term/img/icon-dep5-Email.gif
term/img/icon-dep5-jb-bg.gif
term/img/icon-dep5-jb-bg01.gif
term/img/icon-dep5-jb-bg03.gif
term/img/icon-dep5-jb-btL.gif
term/img/icon-dep5-jb-btR.gif
term/img/icon-dep5-jb-jjs.gif
term/img/icon-dep5-jb-jmgs.gif
term/img/icon-dep5-jb-jrg.gif
term/img/icon-dep5-jb-line.gif
term/img/icon-dep5-jb-mijhb.gif
term/img/icon-dep5-jb-pmgg.gif
term/img/icon-dep5-jb-spcd.gif
term/img/icon-dep5-jb-wsj.gif
term/img/icon-dep5-jbgn.gif
term/img/icon-dep5-kg.gif
term/img/icon-dep5-sppsg.gif
term/img/icon-dep5-wishlist.gif
term/img/icon.gif
term/img/icon_dep5_jb_bg02.gif
term/img/icon_dep5_jb_topL.gif
term/img/icon_dep5_jb_topR.gif
term/img/Image2.jpg
term/img/image_3u.gif
term/img/image_case.gif
term/img/image_U3.gif
term/img/lghs_logo.gif
term/img/login1.gif
term/img/loginform copy.gif
term/img/login_b.gif
term/img/logo.gif
term/img/logout.gif
term/img/logout_b.gif
term/img/logo_1.gif
term/img/logo_10.gif
term/img/logo_11.gif
term/img/logo_12.gif
term/img/logo_2.gif
term/img/logo_3.bmp
term/img/logo_5.gif
term/img/logo_6.gif
term/img/logo_7.gif
term/img/logo_8.gif
term/img/logo_9.gif
term/img/main-bi01.gif
term/img/main-bi02.gif
term/img/main-body-left.gif
term/img/main-body-right.gif
term/img/middle.jpg
term/img/m_ani.gif
term/img/parchar1007a.gif
term/img/que.gif
term/img/quest.gif
term/img/regit1.gif
term/img/s.gif
term/img/shopping-bt.gif
term/img/shopping-point-best.gif
term/img/shopping-point-icon.gif
term/img/shopping-point-rightBg.gif
term/img/shopping-point-top.gif
term/img/spacer(1).gif
term/img/spacer(2).gif
term/img/spacer.gif
term/img/test.psd
term/img/uplogo.jpg
term/img/u_b02.gif
term/img/u_b03.gif
term/img/u_b04.gif
term/img/u_b05.gif
term/img/y_faq.gif
term/img/y_free_board.gif
term/img/y_pro_qna.gif
term/img/y_pro_use.gif
term/mypage/login_form.jsp
term/mypage/login_ok.jsp
term/mypage/logout.jsp
term/mypage/user.jsp
term/mypage/userinfo_insert.jsp
term/mypage/userinfo_insert_form.jsp
term/mypage/userinfo_update.jsp
term/mypage/view_user.jsp
term/mypage/view_userinfo.jsp
term/mypage/zip.jsp
term/mypage/zip2.jsp
term/mypage/img/f_b03.gif
term/mypage/img/h_b02.gif
term/mypage/img/h_b04.gif
term/mypage/img/h_b05.gif
term/mypage/img/h_bl02.gif
term/mypage/img/login.gif
term/mypage/img/u_b02.gif
term/mypage/img/u_b03.gif
term/mypage/img/u_b04.gif
term/mypage/img/u_b05.gif
term/mypage/img/u_bt01.gif
term/mypage/img/u_bt04.gif
term/mypage/img/u_bt05.gif
term/mypage/img/u_bt06.gif
term/mypage/img/u_bt07.gif
term/mypage/img/u_bt08.gif
term/mypage/img/u_bt13.gif
term/product/cart_delete.jsp
term/product/cart_insert.jsp
term/product/cart_insert_coo.jsp
term/product/cart_modify.jsp
term/product/cart_view.jsp
term/product/cart_view_coo.jsp
term/product/check.jsp
term/product/check1.jsp
term/product/order_com.jsp
term/product/order_com_del.jsp
term/product/order_view.jsp
term/product/order_view_coo.jsp
term/product/pc_calculation_insert.jsp
term/product/product.jsp
term/product/productcategoryall.jsp
term/product/productofcategory.jsp
term/product/image/100001.gif
term/product/image/100001.jpg
term/product/image/100002.jpg
term/product/image/10001.jpg
term/product/image/10002.jpg
term/product/image/10003.jpg
term/product/image/10004.jpg
term/product/image/110001.gif
term/product/image/110001.jpg
term/product/image/110002.jpg
term/product/image/120001.jpg
term/product/image/120002.jpg
term/product/image/130001.gif
term/product/image/130001.jpg
term/product/image/130002.jpg
term/product/image/140001.jpg
term/product/image/140002.jpg
term/product/image/140003.jpg
term/product/image/150001.jpg
term/product/image/150002.gif
term/product/image/150002.jpg
term/product/image/160001.jpg
term/product/image/160002.jpg
term/product/image/170001.jpg
term/product/image/170002.gif
term/product/image/170002.jpg
term/product/image/180001.jpg
term/product/image/180002.gif
term/product/image/180002.jpg
term/product/image/190002.JPG
term/product/image/19001.JPG
term/product/image/1_page_left.gif
term/product/image/200001.GIF
term/product/image/200002.GIF
term/product/image/20001.jpg
term/product/image/20002.jpg
term/product/image/210001.JPG
term/product/image/210002.GIF
term/product/image/220001.JPG
term/product/image/220002.GIF
term/product/image/230001.JPG
term/product/image/230002.JPG
term/product/image/240001.GIF
term/product/image/240002.GIF
term/product/image/250001.GIF
term/product/image/250002.JPG
term/product/image/260001.JPG
term/product/image/260002.GIF
term/product/image/270001.JPG
term/product/image/270002.JPG
term/product/image/280001.JPG
term/product/image/28002.JPG
term/product/image/290001.JPG
term/product/image/290002.JPG
term/product/image/300001.JPG
term/product/image/300002.JPG
term/product/image/30001.jpg
term/product/image/30002.jpg
term/product/image/30003.jpg
term/product/image/310001.JPG
term/product/image/310002.JPG
term/product/image/320001.GIF
term/product/image/320002.JPG
term/product/image/330001.JPG
term/product/image/330002.JPG
term/product/image/340001.JPG
term/product/image/340002.JPG
term/product/image/350001.GIF
term/product/image/350002.JPG
term/product/image/360001.GIF
term/product/image/360002.JPG
term/product/image/370001.JPG
term/product/image/370002.JPG
term/product/image/380001.JPG
term/product/image/380002.JPG
term/product/image/390001.JPG
term/product/image/390002.JPG
term/product/image/40001.jpg
term/product/image/40002.jpg
term/product/image/40003.jpg
term/product/image/50001.jpg
term/product/image/50002.jpg
term/product/image/60001.jpg
term/product/image/60002.jpg
term/product/image/70001.jpg
term/product/image/70002.jpg
term/product/image/80001.jpg
term/product/image/80002.jpg
term/product/image/90001.jpg
term/product/image/90002.jpg
term/product/image/a.jpg
term/product/image/all.gif
term/product/image/b.jpg
term/product/image/back.gif
term/product/image/c.jpg
term/product/image/col_alter.gif
term/product/image/d.jpg
term/product/image/logo.gif
term/product/image/new3.gif
term/product/image/next1.gif
term/product/image/prev.gif
term/product/image/prev1.gif
term/product/image/row_change.gif
term/product/image/small_100001.jpg
term/product/image/small_100002.jpg
term/product/image/small_10001.jpg
term/product/image/small_10002.jpg
term/product/image/small_10003.jpg
term/product/image/small_10004.jpg
term/product/image/small_110001.jpg
term/product/image/small_110002.jpg
term/product/image/small_120001.jpg
term/product/image/small_120002.jpg
term/product/image/small_130001.jpg
term/product/image/small_130002.jpg
term/product/image/small_140001.jpg
term/product/image/small_140002.jpg
term/product/image/small_140003.jpg
term/product/image/small_150001.jpg
term/product/image/small_150002.jpg
term/product/image/small_160001.jpg
term/product/image/small_160002.jpg
term/product/image/small_170001.jpg
term/product/image/small_170002.jpg
term/product/image/small_180001.jpg
term/product/image/small_180002.jpg
term/product/image/small_20001.jpg
term/product/image/small_20002.jpg
term/product/image/small_30001.jpg
term/product/image/small_30002.jpg
term/product/image/small_30003.jpg
term/product/image/small_40001.jpg
term/product/image/small_40002.jpg
term/product/image/small_40003.jpg
term/product/image/small_50001.jpg
term/product/image/small_50002.jpg
term/product/image/small_60001.jpg
term/product/image/small_60002.jpg
term/product/image/small_70001.jpg
term/product/image/small_70002.jpg
term/product/image/small_80001.jpg
term/product/image/small_80002.jpg
term/product/image/small_90001.jpg
term/product/image/small_90002.jpg
term/product/image/table_delete.gif
term/product/image/tomcat-power.gif
term/product/image/tomcat.gif
term/product/image/추가상품목록.txt
term/productimg/100001.gif
term/productimg/100001.jpg
term/productimg/100002.jpg
term/productimg/10001.jpg
term/productimg/10002.jpg
term/productimg/10003.jpg
term/productimg/10004.jpg
term/productimg/110001.gif
term/productimg/110001.jpg
term/productimg/110002.jpg
term/productimg/120001.jpg
term/productimg/120002.jpg
term/productimg/130001.gif
term/productimg/130001.jpg
term/productimg/130002.jpg
term/productimg/140001.jpg
term/productimg/140002.jpg
term/productimg/140003.jpg
term/productimg/150001.jpg
term/productimg/150002.gif
term/productimg/150002.jpg
term/productimg/160001.jpg
term/productimg/160002.jpg
term/productimg/170001.jpg
term/productimg/170002.gif
term/productimg/170002.jpg
term/productimg/180001.jpg
term/productimg/180002.gif
term/productimg/180002.jpg
term/productimg/190001.jpg
term/productimg/190002.jpg
term/productimg/200001.gif
term/productimg/200002.gif
term/productimg/20001.jpg
term/productimg/20002.jpg
term/productimg/210001.jpg
term/productimg/210002.gif
term/productimg/220001.jpg
term/productimg/220002.gif
term/productimg/230001.jpg
term/productimg/230002.jpg
term/productimg/240001.gif
term/productimg/240002.gif
term/productimg/250001.gif
term/productimg/250002.jpg
term/productimg/260001.jpg
term/productimg/260002.gif
term/productimg/270001.jpg
term/productimg/270002.jpg
term/productimg/280001.jpg
term/productimg/280002.jpg
term/productimg/290001.jpg
term/productimg/290002.jpg
term/productimg/300001.jpg
term/productimg/300002.jpg
term/productimg/30001.jpg
term/productimg/30002.jpg
term/productimg/30003.jpg
term/productimg/310001.jpg
term/productimg/310002.jpg
term/productimg/320001.gif
term/productimg/320002.jpg
term/productimg/330001.jpg
term/productimg/330002.jpg
term/productimg/340001.jpg
term/productimg/340002.jpg
term/productimg/350001.gif
term/productimg/350002.jpg
term/productimg/360001.GIF
term/productimg/360002.JPG
term/productimg/370001.JPG
term/productimg/370002.JPG
term/productimg/380001.JPG
term/productimg/380002.JPG
term/productimg/390001.JPG
term/productimg/390002.JPG
term/productimg/40001.jpg
term/productimg/40002.jpg
term/productimg/40003.jpg
term/productimg/50001.jpg
term/productimg/50002.jpg
term/productimg/60001.jpg
term/productimg/60002.jpg
term/productimg/70001.jpg
term/productimg/70002.jpg
term/productimg/80001.jpg
term/productimg/80002.jpg
term/productimg/90001.jpg
term/productimg/90002.jpg
term/productimg/추가상품목록.txt
term/service/service_index.jsp
term/service/service_index_c3s.jsp
term/service/service_index_site.jsp
term/service/service_menubar.jsp
term/service/s_c3s.jsp
term/service/s_sitemap.jsp
term/service/img/1.gif
term/service/img/1.jpg
term/service/img/arrow_04.gif
term/service/img/arrow_blue.gif
term/service/img/banner.jpg
term/service/img/bu.gif
term/service/img/bullet_nemo.gif
term/service/img/download.gif
term/service/img/left_arrow_02.gif
term/service/img/main_news.gif
term/service/img/main_news1.gif
term/service/img/main_news2.gif
term/service/img/middle_line_01.gif
term/service/img/middle_line_02.gif
term/service/img/more.gif
term/service/img/subject.gif
term/service/img/zip.gif
term/shoppingmall/gongdong.jsp
term/shoppingmall/gongdong_view.jsp
term/shoppingmall/gongji.jsp
term/shoppingmall/gongji_view.jsp
term/shoppingmall/newproduct.jsp
term/shoppingmall/pc_calculation.jsp
term/shoppingmall/pop.gif
term/shoppingmall/pop.html
term/upload/20051205121618.805.0.jpg
term/upload/A.JPG
term/upload/b.jpg
term/upload/c.jpg
term/upload/d.jpg
term/WEB-INF/web.xml
term/WEB-INF/classes/BasketBean.java
term/WEB-INF/classes/Bean.java
term/WEB-INF/classes/boardBean.java
term/WEB-INF/classes/category.java
term/WEB-INF/classes/dataBean.java
term/WEB-INF/classes/DBConnectionManager.java
term/WEB-INF/classes/Login.class
term/WEB-INF/classes/Login.java
term/WEB-INF/classes/memberBean.java
term/WEB-INF/classes/OrderBean.java
term/WEB-INF/classes/Sample.java
term/WEB-INF/classes/shopBean.java
term/WEB-INF/classes/Zip.class
term/WEB-INF/classes/Zip.java
term/WEB-INF/classes/zipcode.java
term/WEB-INF/classes/com/jspsmart/upload/File.class
term/WEB-INF/classes/com/jspsmart/upload/Files.class
term/WEB-INF/classes/com/jspsmart/upload/Request.class
term/WEB-INF/classes/com/jspsmart/upload/SmartUpload.class
term/WEB-INF/classes/com/jspsmart/upload/SmartUploadException.class
term/WEB-INF/classes/magic/board/boardBean.class
term/WEB-INF/classes/magic/dbpool/db.properties
term/WEB-INF/classes/magic/dbpool/db.properties.bak
term/WEB-INF/classes/magic/dbpool/DBConnectionManager$DBConnectionPool.class
term/WEB-INF/classes/magic/dbpool/DBConnectionManager.class
term/WEB-INF/classes/magic/member/memberBean.class
term/WEB-INF/classes/magic/product/category.class
term/WEB-INF/classes/magic/reply/replyBean.class
term/WEB-INF/classes/magic/shop/BasketBean.class
term/WEB-INF/classes/magic/shop/OrderBean.class
term/WEB-INF/classes/magic/shop/OrderMail.class
term/WEB-INF/classes/magic/shop/shopBean.class
term/WEB-INF/classes/magic/upload/UploadComponent.class
term/WEB-INF/classes/magic/upload/UploadMrg.class
term/WEB-INF/classes/magic/util/scanner.class
term/WEB-INF/classes/magic/zip/zipcode.class

전체 목록 보기