📄 updatecour.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="myBeans.SQLBean"%>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>确定课程</title>
</head>
<jsp:useBean id="course" scope="page" class="myBean.Course"/>
<body bgcolor="#0099FF" text="#FFFFFF" link="#33FF00">
<p>
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
int period=0;float credit=0;
String id="",name="",semester="",dep="",pre="";
String dep_id = (String)session.getAttribute("dep");
if(dep_id==null){response.sendRedirect("login.jsp");}
id=request.getParameter("id");
ResultSet rs = course.getCourse(id);
if(rs.next()){
name = rs.getString("NAME");
period = rs.getInt("PERIOD");
credit = rs.getFloat("CREDIT");
semester = new String(rs.getString("SEMESTER").getBytes("8859_1"));
dep = rs.getString("DEPARTMENT");
pre = rs.getString("PREPARE");}
%>
<form method="post" action="CourseSvlt">
<input type="hidden" name="action" value="update">
<input type="hidden" name="id" value="<%=id%>">
</p>
<p align="center"><font color="#00FF00" size="+3" face="方正舒体">更新课程</font></p>
<p align="center"> </p>
<table width="420" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="37%" bgcolor="#FFFFFF"><div align="right">课程号</div></td>
<td width="63%" bgcolor="#FFFFFF"><%=id%></td>
</tr>
<tr>
<td width="37%" bgcolor="#FFFFFF"><div align="right">课程名</div></td>
<td width="63%" bgcolor="#FFFFFF"><input name="name" type="text" id="name" value="<%=name%>"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">学分</div></td>
<td bgcolor="#FFFFFF"><select name="mark" size="1" id="mark">
<%
for(double i=0.5;i<=6;i=i+0.5){
if(i==credit){%>
<option selected ><%=i%></option>
<%}else{%>
<option><%=i%></option>
<%}}%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">系别</div></td>
<td bgcolor="#FFFFFF"><select name="dep" size="1" id="dep">
<option>public</option>
<% SQLBean db = new SQLBean();
String sql = "";
if(dep_id.equals("0000")){
sql = "select ID,NAME from department ";
}else{sql = "select ID,NAME from department where ID='"+dep_id+"'";}
rs = db.executeQuery(sql);
while(rs.next()){
id =rs.getString("ID");
if(id.equals(dep)){%>
<option selected value="<%=id%>"><%=rs.getString("NAME")%></option>
<%}else{%>
<option value="<%=id%>"><%=rs.getString("NAME")%></option>
<%}}%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">预修课</div></td>
<td bgcolor="#FFFFFF"><select name="prepare" size="1" id="prepare">
<option value="0">无</option>
<%
rs=course.getPrepares();
while(rs.next()) {
if(!name.equals(rs.getString("NAME"))){
id=rs.getString("ID");
if(id.equals(pre)){%>
<option selected value="<%=id%>"><%=rs.getString("NAME")%></option>
<%}else{%>
<option value="<%=id%>"><%=rs.getString("NAME")%></option>
<%}}}%>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">学时</div></td>
<td bgcolor="#FFFFFF"><input name="period" id="period" type="text" value=<%=period%>> </td>
</tr>
<td bgcolor="#FFFFFF"><tr><td bgcolor="#FFFFFF"><div align="right">开课学期</div></td>
<td bgcolor="#FFFFFF"><select name="semester" size="1" id="semester">
<%String sem[] = {"第一学期","第二学期","第三学期","第四学期","第五学期","第六学期","第七学期","第八学期"};
for(int i=0;i<sem.length;i++){
if(sem[i].equals(semester)){%>
<option seleted ><%=sem[i]%></option>
<%}else{%>
<option><%=sem[i]%></option>
<%}}%>
</select>
</td>
</tr>
</table>
<p> </p><p align="center">
<input type="submit" name="Submit" value="提交">
</p>
</form>
<p> </p>
<p align="center"><a href="getCourse.jsp">返回</a> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -