|
create_sql_401.java
1
2
3
4
* programm_name : create_sql_401.java
5
* student_ID: 2019213004 Name: Yoo Kiryoung
6
* Start Date : 2021/10/04
7
* Question 401: Find all students from sql_401 table.
8
* purpose: create sql_401 tables.
9
10
11
public class create_sql_401 {
12
public static void main(String[] args) {
13
Connection con =null;
14
Statement stmt = null;
15
String url = "jdbc:mysql://127.0.0.1:3306/sql_401";
16
String user = "root";
17
String passwd = "ahepf1245780!";
18
19
try {
20
Class.forName("com.mysql.cj.jdbc.Driver");
21
}catch(java.lang.ClassNotFoundException e) {
22
System.err.print("ClassNotFoundException: ");
23
System.err.println(e.getMessage());
24
return;
25
}
26
String createString = "CREATE TABLE classroom";
27
createString += "(building
varchar(15), ";
28
createString += "room_number
varchar(7),";
29
createString += "capacity
numeric(4,0),";
30
createString += "primary key (building, room_number))";
31
32
33
String createString_1= "CREATE TABLE department";
34
createString_1 += "(dept_name
varchar(20), ";
35
createString_1 += "building
varchar(15),";
36
createString_1 += "budget
numeric(12,2) check (budget > 0),";
37
createString_1 += " primary key (dept_name))";
38
39
40
String createString_2 = "CREATE TABLE course";
41
createString_2 += "(course_id
varchar(8),";
42
createString_2 += " title
varchar(50), ";
43
createString_2 += "dept_name
varchar(20),";
44
createString_2 += "credits
numeric(2,0) check (credits > 0),";
45
createString_2 +=
" primary key (course_id),";
46
createString_2 += " foreign key (dept_name) references department (dept_name)\r\n"+
"on delete set null)";
47
48
49
String createString_3 = "CREATE TABLE instructor";
50
createString_3 += "(ID
varchar(5), ";