📄 kechengxg.asp
字号:
<!--#include file ="connection.asp"-->
<%
user=session("user")
lb=session("lb")
lessonno=trim(request.QueryString("lessonno"))
'response.write teacherno
if user=""or lb<>"admin" then
response.redirect"index.asp"
else
sqlstr="select * from 课程 where lessonno='" & lessonno &"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sqlstr,CN
sqlstr="select * from 系"
set rs1=Server.CreateObject("ADODB.Recordset")
rs1.open sqlstr,CN
sqlstr="select * from 专业"
set rs2=Server.CreateObject("ADODB.Recordset")
rs2.open sqlstr,CN
sqlstr="select * from 教师"
set rs3=Server.CreateObject("ADODB.Recordset")
rs3.open sqlstr,CN
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改教学计划</title>
<style type="text/css">
<!--
.STYLE2 {
font-size: 18px;
font-weight: bold;
color: #FFFFFF;
}
-->
</style>
</head>
<body bgcolor="#FBC2AD">
<div align=center>
<form name="f1" action="kechengxgz.asp" method="post">
<table width="144" height="31">
<tr>
<td> </td>
</tr>
</table>
<table width="311" border="0" cellpadding="3" cellspacing="1" bordercolor="#000000" bgcolor="#000000" class="sft">
<tr>
<td height="30" colspan="2" bgcolor="#FF903C"><div align="center" class="STYLE1">
<div align="center"><span class="STYLE2">修改教学计划</span>
<input name="oldlessonno" type="hidden" id="oldlessonno" value=<%=lessonno%>></div>
</div></td>
</tr>
<tr>
<td width="85" height="30" bgcolor="#FF903C"><div align="center">课程编号：</div></td>
<td width="211" height="30" bgcolor="#FFFFFF"><input name="lessonno" type="text" id="lessonno"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20" value=<%=rs("lessonno")%>></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">课程名称：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="lessonname" type="text" id="lessonname"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value=<%=rs("lessonname")%> size="20"></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">开课系部:</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="xino" size="1" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
do while not rs1.eof
if rs1("xino")=rs("xino") then
%>
<option value="<%=rs1("xino")%>" selected><%=rs1("xiname")%></option>
<% else %>
<option value="<%=rs1("xino")%>"><%=rs1("xiname")%></option>
<%end if %>
<% rs1.movenext
loop
%>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">开课专业:</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="zhuanyeno" size="1" id="zhuanyeno" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
do while not rs2.eof
if rs2("zhuanyeno")=rs("zhuanyeno") then
%>
<option value="<%=rs2("zhuanyeno")%>" selected><%=rs2("zhuanye")%></option>
<% else %>
<option value="<%=rs2("zhuanyeno")%>"><%=rs2("zhuanye")%></option>
<%end if %>
<% rs2.movenext
loop
%>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">开课学期:</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="xueqi" size="1" id="xueqi" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
if rs("xueqi")="2007-2008(1)" then
%>
<option value="2007-2008(1)" selected>2007-2008(1)</option>
<%else%>
<option value="2007-2008(1)">2007-2008(1)</option>
<% end if %>
<%
if rs("xueqi")="2007-2008(2)" then
%>
<option value="2007-2008(2)" selected>2007-2008(2)</option>
<%else%>
<option value="2007-2008(2)">2007-2008(2)</option>
<% end if %>
<%
if rs("xueqi")="2008-2009(1)" then
%>
<option value="2008-2009(1)" selected>2008-2009(1)</option>
<%else%>
<option value="2008-2009(1)">2008-2009(1)</option>
<% end if %>
<%
if rs("xueqi")="2008-2009(2)" then
%>
<option value="2008-2009(2)" selected>2008-2009(2)</option>
<%else%>
<option value="2008-2009(2)">2008-2009(2)</option>
<% end if %>
<%
if rs("xueqi")="2009-2010(1)" then
%>
<option value="2009-2010(1)" selected>2009-2010(1)</option>
<%else%>
<option value="2009-2010(1)">2009-2010(1)</option>
<% end if %>
<%
if rs("xueqi")="2009-2010(2)" then
%>
<option value="2009-2010(2)" selected>2009-2010(2)</option>
<%else%>
<option value="2009-2010(2)">2009-2010(2)</option>
<% end if %>
n>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">开课教师:</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="teacherno" size="1" id="teacherno" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
do while not rs3.eof
if strcomp(rs3("teacherno"),rs("teacherno"))=0 then
%>
<option value="<%=rs3("teacherno")%>" selected><%=rs3("teachername")%></option>
<% else %>
<option value="<%=rs3("teacherno")%>"><%=rs3("teachername")%></option>
<%end if %>
<% rs3.movenext
loop
%>
</select></td>
</tr>
<tr>
<td height="35" colspan="2" bgcolor="#FFFFFF"><div align="center">
<input type="submit" name="Submit" value="修改教学计划" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
</div></td>
</tr>
</table>
</form>
<p class=sft>
</div>
<body>
</body>
</html>
<%
end if
rs.close
rs1.close
rs2.close
rs3.close
CN.close
set rs=nothing
set rs1=nothing
set rs2=nothing
set rs3=nothing
set CN=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -