|
98
createString_7 += " year
numeric(4,0),";
99
createString_7 +=
varchar(2),";
100
createString_7 += " primary key (ID, course_id, sec_id, semester, year),";
101
createString_7 += " foreign key (course_id, sec_id, semester, year) references
section (course_id, sec_id, semester, year)\r\n"+ "
on delete cascade,";
102
createString_7 +=" foreign key (ID) references student (ID)\r\n"+ "
on delete
cascade)";
103
104
105
String createString_8 = "CREATE TABLE advisor";
106
createString_8 +="(s_ID
varchar(5),";
107
createString_8 +=" i_ID
varchar(5),";
108
createString_8 +=" primary key (s_ID),";
109
createString_8 +=" foreign key (i_ID) references instructor (ID)\r\n"+ "
on
delete set null,";
110
createString_8 +=" foreign key (s_ID) references student (ID)\r\n"+ "
on delete
cascade)";
111
112
113
114
String createString_10 = "CREATE TABLE prereq";
115
createString_10 +="(course_id
varchar(8), ";
116
createString_10 +=" prereq_id
varchar(8),";
117
createString_10 +=" primary key (course_id, prereq_id),";
118
createString_10 +=" foreign key (course_id) references course (course_id)\r\n"+ "
on delete cascade,";
119
createString_10 +="foreign key (prereq_id) references course (course_id))";
120
121
122
try {
123
con=DriverManager.getConnection(url, user, passwd);
124
stmt = con.createStatement();
125
stmt.executeUpdate(createString);
126
stmt.executeUpdate(createString_1);
127
stmt.executeUpdate(createString_2);
128
stmt.executeUpdate(createString_3);
129
stmt.executeUpdate(createString_4);
130
stmt.executeUpdate(createString_5);
131
stmt.executeUpdate(createString_6);
132
stmt.executeUpdate(createString_7);
133
stmt.executeUpdate(createString_8);
134
stmt.executeUpdate(createString_10);
135
System.out.println("The table sql_401 has been successfully created!");
136
}catch(SQLException e) {
137
System.err.println("SQLException:"+e.getMessage());
138
}
139
finally {
140
try {
141
if(stmt != null) stmt.close();
142
if(con != null) con.close();
143
}catch(Exception e) {}
144
}
145
}
146