전체 글
-
[ERMaster] shoppingmall - updateWEB/ERMaster 2022. 9. 10. 12:20
회원 정보 수정하기 else if(command.equals("editForm")) ac=new EditFormAction(); package com.sam.shop.controller.action; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class EditFormAction implements Action { @Override public void execute(HttpServ..
-
[ERMaster] shoppingmall - login, logout, joinWEB/ERMaster 2022. 9. 10. 12:17
로그인 화면 else if(command.equals("loginForm")) ac=new LoginFormAction(); package com.sam.shop.controller.action; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class LoginFormAction implements Action { @Override public void execute(HttpServl..
-
[ERMaster] shoppingmall - mainWEB/ERMaster 2022. 9. 10. 12:03
Run 시작페이지 Servlet package com.sam.shop.controller; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.sam.shop.controller.action.Action; @WebServlet("/shop.do") public class ShoppingMallServlet e..
-
[ERMaster] 설치 후 테이블 생성WEB/ERMaster 2022. 9. 10. 12:00
설치하기 테이블 생성하기 외래키 설정하기 내보내기 그렇게 생성된 테이블들 /* Drop Tables */ DROP TABLE address CASCADE CONSTRAINTS; DROP TABLE cart CASCADE CONSTRAINTS; DROP TABLE order_detail CASCADE CONSTRAINTS; DROP TABLE orders CASCADE CONSTRAINTS; DROP TABLE qna CASCADE CONSTRAINTS; DROP TABLE Member CASCADE CONSTRAINTS; DROP TABLE product CASCADE CONSTRAINTS; DROP TABLE worker CASCADE CONSTRAINTS; /* Create Tables */ CREA..
-
[JSTL] file uploadWEB/JSTL 2022. 9. 10. 11:51
프로그램 다운로드 Servlets.com | com.oreilly.servlet Servlets.com | com.oreilly.servlet www.servlets.com 글쓴이: 제 목: 파일 저장하기: package com.file.upload; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.Http..
-
[JSTL] CSS 추가한 loginWEB/JSTL 2022. 9. 9. 20:44
sql로 테이블 생성 create table member( name varchar2(30), userid varchar2(30), pwd varchar2(30), email varchar2(30), phone varchar2(15), admin number(1) default 0, -- 0:일반사용자 , 1:관리자 primary key(userid) ); create table board( num number(5) primary key, pass varchar2(30), --게시물의 수정 삭제를 위한 비번 userid varchar2(30), email varchar2(30), title varchar2(50), content varchar2(1000), readcount number(4) default..
-
[JSTL] interface를 이용한 loginWEB/JSTL 2022. 9. 9. 20:40
*.jsp파일 - background color 검정 접속할 로그인 창(주소창 표시 안함) main servlet 생성 package com.mgr.member.controller; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.mgr.member.controller.action.Action; @WebS..
-
[JSTL] 정보수정, 회원&관리자 변화, 탈퇴WEB/JSTL 2022. 9. 9. 20:33
정보수정 1) UpdateServlet package com.jstl.member; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.jstl.dao.MemberDao..