📄 getcourse.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>课程</title>
<style type="text/css">
<!--
.STYLE1 {
font-family: "华文行楷";
font-weight: bold;
}
.STYLE2 {font-family: "华文行楷"}
-->
</style>
</head>
<jsp:useBean id="course" scope="page" class="stu.course"/>
<jsp:useBean id="sqlB" scope="page" class="stu.sqlBean"/>
<body bgcolor="#4692B3" text="#FFFFFF" link="#00FF00">
<div align="center">
<p>
<%
String id="",name="",prepare_id="",prepare="",dep="";
int mark=0;
%>
<span class="STYLE2"><font color="#00FF00" size="+3">所有课程</font></span> </p>
<p> </p>
<p align="left" class="STYLE1"><a href="addcourse.jsp"><font size="+1">新增课程</font></a></p>
</div>
<form action="getcourse_confirm.jsp" method="post">
<div align="center">
<table width="75%" border="1">
<tr>
<td>课程号</td>
<td>课程名</td>
<td>学分</td>
<td>预修课</td>
<td>所在系</td>
<td>删除</td>
<td>更新</td>
</tr>
<%
ResultSet rs=course.getCourse();
while(rs.next()) {
id=rs.getString("id");
name=rs.getString("name");
mark=rs.getInt("mark");
prepare_id=rs.getString("prepare");
dep=rs.getString("dep");
String sql="select name from course where id ='"+prepare_id+"' ";
ResultSet rs1= sqlB.executeQuery(sql);
if(rs1.next())
prepare=rs1.getString("name");
else
prepare="无";
%>
<tr><td><%=id%></td><td><%=name%></td><td><%=mark%></td><td><%=prepare%></td>
<td><%=dep%></td><td><input type="checkbox" name="chkbx" value="<%=id%>")></td>
<td><a href="updatecour.jsp?id=<%=id%> ">更新</a></td></tr>
<%
}
%>
</table>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</div>
</form>
<p align="left"><a href="admin.jsp"><<返 回</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -