forked from estanie/dbproject
-
Notifications
You must be signed in to change notification settings - Fork 0
/
select.jsp
106 lines (102 loc) · 2.67 KB
/
select.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import="java.sql.*" %>
<head>
<title>내 강의 조회</title>
<style>
tr:hover {
background-color: lightgrey;
}
a:hover {
color: #f62217;
}
</style>
</head>
<%@ include file="top.jsp" %>
<%@ include file="dbconfig.jsp" %>
<%
if (session_id == null) {
%>
<script>
alert("로그인이 필요합니다.");
location.href = "login.jsp";
</script>
<%
} else {
%>
<div id="containerwrap">
<div id="container">
<div class="section_title">
<h1>
<span>수강정보 조회</span>
</h1>
</div>
<table width="75%" align="center" border>
<br/>
<tr style="background: lightgrey">
<th>과목번호</th>
<th>분반</th>
<th>과목명</th>
<th>학점</th>
<th>요일</th>
<th>시간</th>
<th>장소</th>
<th>수강신청</th>
</tr>
<%
CallableStatement stmt = null;
ResultSet myResultSet = null;
String mySQL = "{call SelectTimeTable(?,?,?,?)}";
stmt = myConn.prepareCall(mySQL);
stmt.setInt(1, session_id);
stmt.registerOutParameter(2, oracle.jdbc.OracleTypes.CURSOR);
stmt.registerOutParameter(3, oracle.jdbc.OracleTypes.NUMBER);
stmt.registerOutParameter(4, oracle.jdbc.OracleTypes.NUMBER);
stmt.execute();
myResultSet = (ResultSet) stmt.getObject(2);
int sumCourse = stmt.getInt(3);
int sumUnit = stmt.getInt(4);
while (myResultSet.next()) {
String c_id = myResultSet.getString("c_id");
int c_id_no = myResultSet.getInt("c_id_no");
String c_name = myResultSet.getString("c_name");
int c_unit = myResultSet.getInt("c_unit");
int t_time = myResultSet.getInt("t_time");
int t_day = myResultSet.getInt("t_day");
String t_where = myResultSet.getString("t_where");
%>
<tr>
<td align="center"><%=c_id%>
</td>
<td align="center"><%=c_id_no%>
</td>
<td align="center"><%=c_name%>
</td>
<td align="center"><%=c_unit%>
</td>
<td align="center"><%=t_day%>
</td>
<td align="center"><%=t_time%>
</td>
<td align="center"><%=t_where%>
<td align="center"><a
href="delete.jsp?c_id=<%=c_id%>&c_id_no=<%=c_id_no%>">삭제</a></td>
</tr>
<%
}
%>
</table>
<h3 align="center" style="margin: 3em;">
총
<%=sumCourse%>
과목,
<%=sumUnit%>
학점 신청하셨습니다.
</h3>
</div>
</div>
<%
stmt.close();
myConn.close();
}
%>
<%@ include file="footer.jsp" %>