이클립스 & mysql 세팅하기
계정테이블 생성하기
Enter password: ******
mysql> create database bbs;
Query OK, 1 row affected (0.01 sec)
mysql> use bbs;
Database changed
mysql> create table user( userID varchar(20), userPW varchar(20), primary key(userID));
Query OK, 0 rows affected (0.04 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 | |
| userPW | varchar(20) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into user values('admin','admin');
Query OK, 1 row affected (0.01 sec)
mysql> select * from user;
+--------+--------+
| userID | userPW |
+--------+--------+
| admin | admin |
+--------+--------+
1 row in set (0.00 sec)
jar파일은 이렇게 넣어준다.
