📄 addbiao.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
xino=request.QueryString("xino")
zhuanyeno=request.QueryString("zy")
xueqi=request.QueryString("xq")
sqlstr="select 课程.*,系.xiname,专业.zhuanye from 课程,系,专业 where 课程.xino='" & xino &"' and 课程.zhuanyeno='"& zhuanyeno &"' and 课程.xino=系.xino and 专业.zhuanyeno=课程.zhuanyeno"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sqlstr,CN,1,3
if rs.eof then
response.writre "还没有课程信息！"
response.end
else
teacherno=rs("teacherno")
%>
<table width="144" height="26">
<tr>
<td> </td>
</tr>
</table>
<form action="addbiaoz.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"><%=xueqi%>课程表详细信息</div> </td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">所在系：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="xiname" type="text" style="border-style: dotted; border-width: 0; background-color: #333366" size="20" value="<%=rs("xiname")%>" disabled><input type="hidden" name="xino" value=<%=xino%>></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">专业：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="zhuanye" type="text" disabled id="zhuanye" style="border-style: dotted; border-width: 0; background-color: #333366" value="<%=rs("zhuanye")%>" size="20"><input type="hidden" name="zhuanyeno" value=<%=zhuanyeno%>></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">学期：</div></td>
<td height="31" bgcolor="#FFFFFF"><input name="xueqi" type="text"style="border-style: dotted; border-width: 0; background-color: #333366" size="20" value="<%=xueqi%>" disabled><input name="xq" type="hidden"style="border-style: dotted; border-width: 0; background-color: #333366" size="20" value="<%=xueqi%>" ></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">
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</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">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
</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="xueqi" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<%
do while not rs.eof
%>
<option value="<%=rs("lessonno")%>"><%=rs("lessonname")%></option>
<%
rs.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">
<option value="每周上课">每周上课</option>
<option value="单周">单周</option>
<option value="双周">双周</option>
</select></td>
</tr>
<tr>
<td width="83" height="23" bgcolor="#FF903C"><div align="center">星期：</div></td>
<td width="329" height="23" bgcolor="#FFFFFF"><select name="week" size="1" id="week" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="星期一">星期一</option>
<option value="星期二">星期二</option>
<option value="星期三">星期三</option>
<option value="星期四">星期四</option>
<option value="星期五">星期五</option>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FF903C"><div align="center">节次：</div></td>
<td height="31" bgcolor="#FFFFFF"><p>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value=" 1、2节">
1、2节
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="3、4 节">
3、4
节
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="5、6节">
5、6节</p>
<p>
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="7、8节">
7、8节
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="9、10节">
9、10节
<input name="jiecheck" type="checkbox" id="jiecheck" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" value="11、12节">
11、12节</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">
分</td>
</tr>
<tr>
<td width="83" height="26" bgcolor="#FF903C"><div align="center">课程性质： </div></td>
<td width="329" height="26" bgcolor="#FFFFFF"><select name="lessontype" size="1" id="lessontype"style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="必修/考试">必修/考试</option>
<option value="必修/考查">必修/考查</option>
<option value="选修">选修</option>
</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">
<input type="hidden" name="teacherno" value=<%=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>
</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 + -