JSP 게시판 만들기 - 3강

3강 회원 데이터베이스 구축하기 (JSP Advanced Development Tutorial #3)

 

 

[데이터베이스 생성]

 

mysql> CREATE DATABASE BBS;
Query OK, 1 row affected (0.47 sec)
 
mysql> USE BBS;
Database changed

 

 

[USER 테이블 생성]

 

▶ userID는 겹치는 것이 있으면 안되므로 PRIMARY KEY로 설정한다.

 

mysql> CREATE TABLE USER (
    -> userID VARCHAR(20),
    -> userPassword VARCHAR(20),
    -> userName VARCHAR(20),
    -> userGender VARCHAR(20),
    -> userEmail VARCHAR(50),
    -> PRIMARY KEY (userID)
    -> );
Query OK, 0 rows affected (0.07 sec)
 
mysql> show tables;
+---------------+
| Tables_in_bbs |
+---------------+
| user          |
+---------------+
1 row in set (0.01 sec)
 
mysql> desc user;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| userID       | varchar(20) | NO   | PRI | NULL    |       |
| userPassword | varchar(20) | YES  |     | NULL    |       |
| userName     | varchar(20) | YES  |     | NULL    |       |
| userGender   | varchar(20) | YES  |     | NULL    |       |
| userEmail    | varchar(50) | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

 

 

[테이블에 예제 데이터 삽입 & COMMIT]

 

mysql> INSERT INTO USER VALUES('gildong', '123456', '홍길동', '남자', 'gildong@naver.com');
Query OK, 1 row affected (0.01 sec)
 
mysql> select * from user;
+---------+--------------+----------+------------+-------------------+
| userID  | userPassword | userName | userGender | userEmail         |
+---------+--------------+----------+------------+-------------------+
| gildong | 123456       | 홍길동   | 남자       | gildong@naver.com |
+---------+--------------+----------+------------+-------------------+
1 row in set (0.00 sec)
 
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
 
mysql> desc user;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| userID       | varchar(20) | NO   | PRI | NULL    |       |
| userPassword | varchar(20) | YES  |     | NULL    |       |
| userName     | varchar(20) | YES  |     | NULL    |       |
| userGender   | varchar(20) | YES  |     | NULL    |       |
| userEmail    | varchar(50) | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

 

 

[소스코드]

 

▶ 하나의 회원 정보를 담을 수 있는 USER 테이블을 구축한 뒤, Java Beans로 USER CLASS를 만들었다.

 

 

 

출처 : https://www.youtube.com/watch?v=kN8xRG6UPZM&list=PLRx0vPvlEmdAZv_okJzox5wj2gG_fNh_6&index=3