게시판 만들기_회원가입

1. 만들 데이터베이스 설계하기

DROP DATABASE IF EXISTS member_db;

CREATE DATABASE member_db;

USE member_db;

CREATE TABLE member_table(

mbNo INT PRIMARY KEY AUTO_INCREMENT,
mbId VARCHAR(20) NOT NULL,
mbPw VARCHAR(20) NOT NULL,
mbName VARCHAR(20),
mbNic VARCHAR(20),
mbTel VARCHAR(20) NOT NULL,
mbEmail VARCHAR(20) NOT NULL,
mbPost CHAR(20),
mbAddr VARCHAR(50),
mbDetailAddr VARCHAR(50),
mbExtraAddr VARCHAR(50),
mbDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

SELECT * FROM member_table;

---

2. 화면구성

---

3. 파일작성

WebContent

main.jsp

main.jsp

0.00MB

 

WebContent

nav.jsp

nav.jsp

0.00MB

 

 

 

WebContent

join_write.jsp

join_write.jsp

0.01MB

WebContent

join_update.jsp

join_update.jsp

0.00MB

 

 

 

WebContent

mb_id_chk.jsp

mb_id_chk.jsp

0.00MB

---

SRC>membermanage

Member.java

Member.java

0.00MB

 

SRC>membermanage

MemberDAO.java

MemberDAO.java

0.00MB

 

SRC>control

ConnectionInfo.java

ConnectionInfo.java

0.00MB