📄 updatebiao.asp
字号:
<!--#include file ="connection.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改课程表信息</title>
<style type="text/css">
<!--
.STYLE1 {
color: #FFFFFF;
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body bgcolor="#FBC2AD">
<div align=center>
<%
user=session("user")
lb=session("lb")
if user=""or lb<>"admin" then
response.redirect"index.asp"
else
biaono=request.QueryString("biaono")
sqlstr="select * from 课程表 where biaono='" & biaono &"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sqlstr,CN,1,3
if rs.eof then
response.writre "还没有课程表信息！"
response.end
else
jieci=split(rs("jieci"),",")
sqlstr1="select * from 系"
set rs1=Server.CreateObject("ADODB.Recordset")
rs1.open sqlstr1,CN,1,3
sqlstr2="select * from 专业"
set rs2=Server.CreateObject("ADODB.Recordset")
rs2.open sqlstr2,CN,1,3
sqlstr4="select * from 课程"
set rs4=Server.CreateObject("ADODB.Recordset")
rs4.open sqlstr4,CN,1,3
%>
<form action="editbiaoz.asp" method="post">
<table width="442" 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"><%=rs("xueqi")%>课程表详细信息<input type="hidden" name="biaono" value="<%=rs("biaono")%>"></div> </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 rs("xino")=rs1("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 rs("zhuanyeno")=rs2("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="jino" size="1" id="jino" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
if rs("jino")="2004" then
%>
<option value="2004" selected>2004</option>
<%else%>
<option value="2004">2004</option>
<% end if %>
<%
if rs("jino")="2005" then
%>
<option value="2005" selected>2005</option>
<%else%>
<option value="2005">2005</option>
<% end if %>
<%
if rs("jino")="2006" then
%>
<option value="2006" selected>2006</option>
<%else%>
<option value="2006">2006</option>
<% end if %>
<%
if rs("jino")="2007" then
%>
<option value="2007" selected>2007</option>
<%else%>
<option value="2007">2007</option>
<% end if %>
<%
if rs("jino")="2008" then
%>
<option value="2008" selected>2008</option>
<%else%>
<option value="2008">2008</option>
<% end if %>
<%
if rs("jino")="2009" then
%>
<option value="2009" selected>2009</option>
<%else%>
<option value="2009">2009</option>
<% end if %>
<%
if rs("jino")="2010" then
%>
<option value="2010" selected>2010</option>
<%else%>
<option value="2010">2010</option>
<% end if %>
</select>
级</td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">班级：</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="banno" size="1" id="banno" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
if rs("banno")="2010" then
%>
<option value="01" selected>01</option>
<%else%>
<option value="01">01</option>
<% end if %>
<%
if rs("banno")="02" then
%>
<option value="02" selected>02</option>
<%else%>
<option value="02">02</option>
<% end if %>
<%
if rs("banno")="03" then
%>
<option value="03" selected>03</option>
<%else%>
<option value="03">03</option>
<% end if %>
<%
if rs("banno")="04" then
%>
<option value="04" selected>04</option>
<%else%>
<option value="04">04</option>
<% end if %>
<%
if rs("banno")="05" then
%>
<option value="05" selected>05</option>
<%else%>
<option value="05">05</option>
<% end if %>
<%
if rs("banno")="06" then
%>
<option value="06" selected>06</option>
<%else%>
<option value="06">06</option>
<% end if %>
<%
if rs("banno")="07" then
%>
<option value="07" selected>07</option>
<%else%>
<option value="07">07</option>
<% end if %>
<%
if rs("banno")="08" then
%>
<option value="08" selected>08</option>
<%else%>
<option value="08">08</option>
<% end if %>
</select>
班</td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">课程：</div></td>
<td height="31" bgcolor="#FFFFFF"><select name="lessonno" size="1" id="lessonno" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
do while not rs4.eof
if rs("lessonno")=rs4("lessonno") then
%>
<option value="<%=rs("lessonno")%>" selected><%=rs4("lessonname")%></option>
<% else %>
<option value="<%=rs("lessonno")%>"><%=rs4("lessonname")%></option>
<%end if%>
<%
rs4.movenext
loop
%>
</select> </td>
</tr>
<tr>
<td height="28" bgcolor="#FF903C"><div align="center">周次：</div></td>
<td height="28" bgcolor="#FFFFFF"><select name="everyweek" size="1" id="everyweek" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
if rs("everyweek")="每周上课" then
%>
<option value="每周上课" selected>每周上课</option>
<%else%>
<option value="每周上课">每周上课</option>
<% end if %>
<%
if rs("everyweek")="单周" then
%>
<option value="单周" selected>单周</option>
<%else%>
<option value="单周">单周</option>
<% end if %>
<%
if rs("everyweek")="双周" then
%>
<option value="双周" selected>双周</option>
<%else%>
<option value="双周">双周</option>
<% end if %>
</select></td>
</tr>
<tr>
<td width="103" height="23" bgcolor="#FF903C"><div align="center">星期：</div></td>
<td width="324" height="23" bgcolor="#FFFFFF"><select name="week" size="1" id="week" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
if rs("week")="星期一" then
%>
<option value="星期一" selected>星期一</option>
<%else%>
<option value="星期一">星期一</option>
<%end if%>
<%
if rs("week")="星期二" then
%>
<option value="星期二" selected>星期二</option>
<%else%>
<option value="星期二">星期二</option>
<% end if %>
<%
if rs("week")="星期三" then
%>
<option value="星期三" selected>星期三</option>
<%else%>
<option value="星期三">星期三</option>
<% end if %>
<%
if rs("week")="星期四" then
%>
<option value="星期四" selected>星期四</option>
<%else%>
<option value="星期四">星期四</option>
<% end if %>
<%
if rs("week")="星期五" then
%>
<option value="星期五" selected>星期五</option>
<%else%>
<option value="星期五">星期五</option>
<% end if %>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">节次：</div></td>
<td height="31" bgcolor="#FFFFFF"><p>
<%for i=LBound(jieci) to UBound(jieci)%>
<% if jieci(i)="1、2节" then %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="1、2节" checked> 1、2节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="1、2节"> 1、2节
<% end if%>
<% if jieci(i)="3、4节" then%>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="3、4节" checked> 3、4节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="3、4节">3、4节
<% end if%>
<% if jieci(i)="5、6节"then %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="5、6节" checked> 5、6节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="5、6节">5、6节
<% end if%>
<% if jieci(i)="7、8节" then%>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="7、8节" checked> 7、8节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="7、8节">7、8节
<% end if%>
<% if jieci(i)="9、10节" then %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="9、10节" checked> 9、10节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="9、10节">9、10节
<% end if%>
<% if jieci(i)="11、12节"then %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="11、12节" checked> 11、12节
<% else %>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="11、12节">11、12节
<% end if%>
<% next %>
</p></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">学分：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="xuefen" type="text" id="xuefen"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="4" value="<%=rs("xuefen")%>">
分</td>
</tr>
<tr>
<td width="103" height="26" bgcolor="#FF903C"><div align="center">课程性质： </div></td>
<td width="324" height="26" bgcolor="#FFFFFF"><select name="lessontype" size="1" id="lessontype"style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<% if rs("lessontype")="必修/考试" then%>
<option value="必修/考试" selected>必修/考试</option>
<% else %>
<option value="必修/考试">必修/考试</option>
<% end if%>
<% if rs("lessontype")="必修/考查" then %>
<option value="必修/考查" selected>必修/考查</option>
<% else %>
<option value="必修/考查">必修/考查</option>
<% end if%>
<% if rs("lessontype")="选修" then %>
<option value="选修" selected>选修</option>
<% else %>
<option value="选修">选修</option>
<% end if%>
</select> </td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">教室：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="classroom" type="text" id="classroom"style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20" value=<%=rs("classroom")%>><input type="hidden" name="teacherno" value="<%=rs("teacherno")%>"></td>
</tr>
<tr>
<td height="20" colspan="2" bgcolor="#FFFFFF"><div align="center">
<div align="center">
<input type="submit" name="action" value="修改课程表信息" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
</div>
</div>
</td>
</tr>
</table>
</form>
<p class=sft>
</div>
</body>
</html>
<%
end if
end if
rs.close
'rs1.close
'rs2.close
CN.close
set rs=nothing
'set rs1=nothing
'set rs2=nothing
set CN=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -