이클립스 & 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)

​

mysql-connector-java-8.0.25.jar

2.32MB

jar파일은 이렇게 넣어준다.