[JSP] 회원가입 만들기

DB CODE : http://colorscripter.com/s/n4qdJr9

 

 

1. 로그인 부분

CODE : http://colorscripter.com/s/mKNs37P

 

- 회원가입 -

 

- 1.0 회원가입 -

회원가입 CODE : http://colorscripter.com/s/EmW0J2f

 

- 1.1 회원 목록 DB에 추가하기 (INSERT) -

JOINPROCESS CODE : joinprocess) : http://colorscripter.com/s/4Z8pXEJ

 

 

 

 

- 로그인 -

 

- DB에서 회원정보 값 불러오기 -

SELECT * FROM SLMEMBER WHERE ID = ?;

LOGINPROCESS CODE :  http://colorscripter.com/s/3EvhcKp

 

 

 

- 메인 -

(admin으로 관리자 구분)

TMPLATE CODE : http://colorscripter.com/s/2fz7saK

LEFT CODE : http://colorscripter.com/s/pJz9mVV

TOP CODE : http://colorscripter.com/s/gWEy62z

MAIN CODE : -

 

 

 

 

 

 

- 기능 -

 

 - 개인정보 확인 -

SELECT CODE : http://colorscripter.com/s/80B6fQ6

 

- 개인정보 수정 -

UPDATE SLMEMBER SET ~ WHERE ID = ?

UPDATE CODE : http://colorscripter.com/s/rCPSXmC

UPDATEPROCESS CODE : https://colorscripter.com/s/Ms5ZKnL

 

 

- 회원 탈퇴, (관리자)추방 -

DELETE FROM SLMEMBER WHERE ID = ?

DELETE CODE : http://colorscripter.com/s/gbKjXD5

 

- 회원 전체 목록 -

SELECT ID, NAME FROM SLMEMBER

SELECTALL CODE : http://colorscripter.com/s/gqwdhpp