갈림길 이정표

[Servlet] 게시물 작성(DB에 저장하고 불러오기) 본문

Programming Language/Servlet & JSP

[Servlet] 게시물 작성(DB에 저장하고 불러오기)

이몽뇽 2020. 8. 24. 17:15
MariaDB [mydb]> CREATE TABLE miniguest(code INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(10) NOT NULL, subject VARCHAR(30), contents TEXT)CHARSET=UTF8;
Query OK, 0 rows affected (0.064 sec)

MariaDB [mydb]> show tables;
+----------------+
| Tables_in_mydb |
+----------------+
| abctab         |
| miniguest      |
+----------------+
2 rows in set (0.001 sec)

MariaDB [mydb]> INSERT INTO miniguest(name,subject,contents) VALUES('김기수','방문','반가워요');
Query OK, 1 row affected (0.012 sec)

MariaDB [mydb]> SELECT * FROM miniguest;
+------+--------+---------+----------+
| code | name   | subject | contents |
+------+--------+---------+----------+
|    1 | 김기수 | 방문    | 반가워요 |
+------+--------+---------+----------+
1 row in set (0.007 sec)
Comments