소개글
JSP를 이용하여 게임 쇼핑몰을 구축하였습니다.DB에 고객의정보와 상품관리 저장.
회원 관리, 상품목록, 문의점은 이메일로 질문, 장바구니 기능 구현.
제품을 다운받아서 java 소스 파일내의 디비 주소와 아이디 비밀번호라고
적혀 있는곳에 mysql 디비를 만들어서 작성하여 컴파일후 실행해야 합니다.
mysql 이 아닌 다른 db 를 사용할 경우는 주소 넣는곳 위의 드라이버에
적당한 디비의 드라이버를 받은 후 경로지정후 하셔야 합니다
WEB-INF\classes\shop\GuestBean.class 는 사용하지 않는 class 입니다. 참조 바랍니다.
컴파일 실행환경
Apache Tomcat 과 java 1.4 sdk 에서 제작.그리고 mysql 과의 DB 연동.본문내용
package shop;import java.sql.*;
import java.util.*;
public class ShopBean {
private int shop_id;
private String name;
private String price;
private String date;
private String passwd;
private String checkpw;
private String title;
private String contents;
private String kind;
Connection conn=null;
PreparedStatement pstmt = null;
String jdbc_driver = "org.gjt.mm.mysql.Driver";
String jdbc_url="jdbc:mysql://디비 주소/디비 이름";
public ShopBean() {
}
public void connect() {
try{
Class.forName(jdbc_driver);
conn = DriverManager.getConnection(jdbc_url,"디비 아이디","디비 비밀번호");
}
catch(Exception e){
System.out.println(e);
e.printStackTrace();
}
}
public void disconnect() {
try{
if(pstmt != null) pstmt.close();
} catch (Exception e) {
System.out.println(e);
}
System.out.println("close");
}
public boolean insertDB() {
....
}
public String getKind(){
return kind;
}
public void setCheckpw(String checkpw) {
this.checkpw = checkpw;
}
public String getCheckpw(){
return checkpw;
}
public void setTitle(String title){
this.title = title;
}
public String getTitle() {
return title;
}
public void setContents(String contents){
this.contents = contents;
}
public String getContents() {
return contents;
}
}
압축파일 내 파일목록
cart.jsp
edit.jsp
error.jsp
idcheck.jsp
index.jsp
join.jsp
list.jsp
login.jsp
logout.jsp
member_control.jsp
member_join.jsp
memberinfo.jsp
menu_control.jsp
normal.jsp
product_edit.jsp
productview.jsp
prowrite.jsp
main.jsp
ps2.jsp
xbox.jsp
ps2list.jsp
xboxlist.jsp
buycart.jsp
MailBean2.java
mail_send2.jsp
company.jsp
LoginBean.java
ShopBean.java
write.jsp
listview.jsp
product.jsp
mail_send.jsp
table.txt
memberadmin.jsp
종화의 쇼핑몰.hwp
images/bt_join.gif
images/bt_login.gif
images/baguni.jpg
images/pw.gif
images/comp.jpg
images/lblock.jpg
images/button_list.gif
images/button_write.gif
images/bt_join2.gif
images/bt_cancel.gif
images/main.jpg
images/down.jpg
images/down.psd
images/center.jpg
images/bt_confirm_overlap.gif
images/join.gif
images/loginup.jpg
images/uptitle.jpg
images/SHOP.jpg
images/new.jpg
images/best.jpg
images/hard.jpg
images/ps2.jpg
images/xbox.jpg
images/xbox2.jpg
images/ps2rol.jpg
images/line.jpg
images/home.jpg
images/company.jpg
images/cart.jpg
images/list.jpg
images/line2.jpg
images/list2.jpg
images/home2.jpg
images/cart2.jpg
images/company2.jpg
images/ps2menu.jpg
images/xboxmenu.jpg
images/goods-info-txttit1.gif
images/goods-info-txttit2.gif
images/goods-info-txttit3.gif
images/q&a.jpg
images/q&a2.jpg
images/update.jpg
images/confirm.jpg
images/del.jpg
images/xbox/xboxpac.jpg
images/xbox/xcon.jpg
images/xbox/rally.jpg
images/xbox/raw.jpg
images/xbox/doa.jpg
images/xbox/fifa.jpg
images/xbox/nba.jpg
images/xbox/mvp.jpg
images/xbox/poter.jpg
images/xbox/ring.jpg
images/xbox/hulk.jpg
images/xbox/street.jpg
images/ps2/vfight.jpg
images/ps2/winpac.jpg
images/ps2/socom.jpg
images/ps2/sam.jpg
images/ps2/ffx2.jpg
images/ps2/gimuja.jpg
images/ps2/mvp.jpg
images/ps2/eye.jpg
images/ps2/ssx.jpg
images/ps2/winnig.jpg
images/ps2/ps2con.jpg
WEB-INF/lib.zip
WEB-INF/framework.properties
WEB-INF/web.xml
WEB-INF/lib/activation.jar
WEB-INF/lib/cos.jar
WEB-INF/lib/dom.jar
WEB-INF/lib/jaxen-full.jar
WEB-INF/lib/jaxp-api.jar
WEB-INF/lib/jdbc2_0-stdext.jar
WEB-INF/lib/jstl.jar
WEB-INF/lib/mail.jar
WEB-INF/lib/sax.jar
WEB-INF/lib/saxpath.jar
WEB-INF/lib/standard.jar
WEB-INF/lib/xalan.jar
WEB-INF/lib/xercesImpl.jar
WEB-INF/lib/simple-framework.jar
WEB-INF/lib/ojdbc14.jar
WEB-INF/classes/shop/GuestBean.class
WEB-INF/classes/shop/LoginBean.class
WEB-INF/classes/shop/ShopBean.class
WEB-INF/classes/mail/MailBean2.class
edit.jsp
error.jsp
idcheck.jsp
index.jsp
join.jsp
list.jsp
login.jsp
logout.jsp
member_control.jsp
member_join.jsp
memberinfo.jsp
menu_control.jsp
normal.jsp
product_edit.jsp
productview.jsp
prowrite.jsp
main.jsp
ps2.jsp
xbox.jsp
ps2list.jsp
xboxlist.jsp
buycart.jsp
MailBean2.java
mail_send2.jsp
company.jsp
LoginBean.java
ShopBean.java
write.jsp
listview.jsp
product.jsp
mail_send.jsp
table.txt
memberadmin.jsp
종화의 쇼핑몰.hwp
images/bt_join.gif
images/bt_login.gif
images/baguni.jpg
images/pw.gif
images/comp.jpg
images/lblock.jpg
images/button_list.gif
images/button_write.gif
images/bt_join2.gif
images/bt_cancel.gif
images/main.jpg
images/down.jpg
images/down.psd
images/center.jpg
images/bt_confirm_overlap.gif
images/join.gif
images/loginup.jpg
images/uptitle.jpg
images/SHOP.jpg
images/new.jpg
images/best.jpg
images/hard.jpg
images/ps2.jpg
images/xbox.jpg
images/xbox2.jpg
images/ps2rol.jpg
images/line.jpg
images/home.jpg
images/company.jpg
images/cart.jpg
images/list.jpg
images/line2.jpg
images/list2.jpg
images/home2.jpg
images/cart2.jpg
images/company2.jpg
images/ps2menu.jpg
images/xboxmenu.jpg
images/goods-info-txttit1.gif
images/goods-info-txttit2.gif
images/goods-info-txttit3.gif
images/q&a.jpg
images/q&a2.jpg
images/update.jpg
images/confirm.jpg
images/del.jpg
images/xbox/xboxpac.jpg
images/xbox/xcon.jpg
images/xbox/rally.jpg
images/xbox/raw.jpg
images/xbox/doa.jpg
images/xbox/fifa.jpg
images/xbox/nba.jpg
images/xbox/mvp.jpg
images/xbox/poter.jpg
images/xbox/ring.jpg
images/xbox/hulk.jpg
images/xbox/street.jpg
images/ps2/vfight.jpg
images/ps2/winpac.jpg
images/ps2/socom.jpg
images/ps2/sam.jpg
images/ps2/ffx2.jpg
images/ps2/gimuja.jpg
images/ps2/mvp.jpg
images/ps2/eye.jpg
images/ps2/ssx.jpg
images/ps2/winnig.jpg
images/ps2/ps2con.jpg
WEB-INF/lib.zip
WEB-INF/framework.properties
WEB-INF/web.xml
WEB-INF/lib/activation.jar
WEB-INF/lib/cos.jar
WEB-INF/lib/dom.jar
WEB-INF/lib/jaxen-full.jar
WEB-INF/lib/jaxp-api.jar
WEB-INF/lib/jdbc2_0-stdext.jar
WEB-INF/lib/jstl.jar
WEB-INF/lib/mail.jar
WEB-INF/lib/sax.jar
WEB-INF/lib/saxpath.jar
WEB-INF/lib/standard.jar
WEB-INF/lib/xalan.jar
WEB-INF/lib/xercesImpl.jar
WEB-INF/lib/simple-framework.jar
WEB-INF/lib/ojdbc14.jar
WEB-INF/classes/shop/GuestBean.class
WEB-INF/classes/shop/LoginBean.class
WEB-INF/classes/shop/ShopBean.class
WEB-INF/classes/mail/MailBean2.class
참고 자료
없음이 자료와 함께 구매한 자료
개인 인터넷 쇼핑몰 23페이지
Internet Shopping Mall By JSP,MYSQL 0페이지
[발표자료] DB를 이용한 인터넷 쇼핑몰제작 (인터넷 서점) 19페이지
[JSP] 최종 과제물 - 인터넷서점 25페이지
jsp 쇼핑몰 0페이지