📄 guanli.asp
字号:
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
</tr>
<%
end if
if Request.QueryString("lastnf")="tjzy" then%>
<tr>
<form action="check.asp">
<input type="hidden" name="check" value="addzy">
<td height=100% colspan="2" valign="top"><table width="491" border="0">
<tr bgcolor="#0033FF">
<td colspan="4" align="right" scope="row"> </td>
</tr>
<tr>
<td align="right" scope="row"> </td>
<td> </td>
<td align="right"> </td>
<td> </td>
</tr>
<tr>
<td width="70" align="right" scope="row">课程编号：</td>
<td width="149"><input type="text" name="cnum" size="17"></td>
<td width="133" align="right">作业名称：</td>
<td width="121"><input type="text" name="zyname" size="17"></td>
</tr>
<tr>
<td align="right" scope="row">作业分值：</td>
<td><input type="text" name="fenzhi" size="17"></td>
<td align="right"> </td>
<td> </td>
</tr>
<tr>
<td align="right" scope="row">作业说明：</td>
<td colspan="3" rowspan="2"><textarea name="shuoming" rows="4" cols="57"></textarea></td>
</tr>
<tr>
<td align="right" scope="row"> </td>
</tr>
<tr>
<td align="right" scope="row"> </td>
<td align="center"><input type="submit" name="Submit" value="确 定"></td>
<td align="center"><input type="reset" name="Submit2" value="重 置"></td>
<td> </td>
</tr>
</table></td>
</form></tr>
<%
end if
if Request.QueryString("lastnf")="zywh" then
%>
<tr><td height=100% colspan="2" valign="top">
<%
sql1="select num,zyname,fenzhi,shuoming,cname from zy,kecheng where zy.cnum=kecheng.cnum"
set rs1=server.CreateObject("ADODB.RECORDSET")
rs1.open sql1,conn_sql,0,4
DO WHILE NOT rs1.eof
%>
<table width="621" border="0">
<tr bgcolor="#0033FF">
<td colspan="4" align="right" scope="row"> </td>
</tr>
<tr>
<td align="right" scope="row">作业编号：</td>
<td><%=rs1("num")%></td>
<td align="right">作业所属课程：</td>
<td><%=rs1("cname")%></td>
</tr>
<tr>
<td width="70" align="right" scope="row">作业名称：</td>
<td width="149"><%=rs1("zyname")%></td>
<td width="133" align="right">作业分值：</td>
<td width="251"><%=rs1("fenzhi")%></td>
</tr>
<tr>
<td align="right" valign="top" scope="row">作业说明：</td>
<td colspan="3" rowspan="2" valign="top"><%=rs1("shuoming")%></td>
</tr>
<tr>
<td align="right" scope="row"> </td>
</tr>
</table>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
</tr>
<%
end if
if (Request.QueryString("lastnf")="" and Request.QueryString("ccnf")="zy")then
%>
<tr><td height=100% colspan="2" valign="top">
<%
sql1="select * from news where bknum=2"
set rs1=server.CreateObject("ADODB.RECORDSET")
rs1.open sql1,conn_sql,0,1
DO WHILE NOT rs1.eof
%>
<table width="493" border="0">
<tr>
<td width="25" align="right" scope="row"> </td>
<td width="36" align="left" scope="row"><img src="<%=rs1("tupian")%>"></td>
<td width="375" align="left" scope="row"><a href="guanli.asp?ccnf=zy"><%=rs1("biaoti")%></a></td>
<td width="39" align="left" scope="row"> </td>
</tr>
</table>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
</tr>
<%
end if
if (Request.QueryString("lastnf")="" and Request.QueryString("ccnf")="bj")then
%>
<tr><td height=100% valign="top">
<%
sql1="select * from news where bknum=3"
set rs1=server.CreateObject("ADODB.RECORDSET")
rs1.open sql1,conn_sql,0,1
DO WHILE NOT rs1.eof
%>
<table width="359" border="0">
<tr>
<td width="10" align="right" scope="row"> </td>
<td width="36" align="left" scope="row"><img src="<%=rs1("tupian")%>"></td>
<td width="272" align="left" scope="row"><a href="guanli.asp?ccnf=bj"><%=rs1("biaoti")%></a></td>
<td width="23" align="left" scope="row"> </td>
</tr>
</table>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
<td width="63%" valign="top"><table width="150" border="0">
<tr>
<th scope="row"> </th>
</tr>
<tr>
<th scope="row"><img src="images/05.gif" width="150" height="200"></th>
</tr>
</table></td>
</tr>
<%
end if
if (Request.QueryString("lastnf")="" and Request.QueryString("ccnf")="cj")then
%>
<tr><td height=100% valign="top">
<%
sql1="select * from news where bknum=4"
set rs1=server.CreateObject("ADODB.RECORDSET")
rs1.open sql1,conn_sql,0,1
DO WHILE NOT rs1.eof
%>
<table width="359" border="0">
<tr>
<td width="10" align="right" scope="row"> </td>
<td width="36" align="left" scope="row"><img src="<%=rs1("tupian")%>"></td>
<td width="272" align="left" scope="row"><a href="guanli.asp?ccnf=cj"><%=rs1("biaoti")%></a></td>
<td width="23" align="left" scope="row"> </td>
</tr>
</table>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
<td width="63%" valign="top"><table width="150" border="0">
<tr>
<th scope="row"> </th>
</tr>
<tr>
<th scope="row"><img src="images/05.gif" width="150" height="200"></th>
</tr>
</table></td>
</tr>
<%
end if
if (Request.QueryString("lastnf")="" and Request.QueryString("ccnf")="yh")then
%>
<tr><td height=100% valign="top">
<%
sql1="select * from news where bknum=4 or bknum=1"
set rs1=server.CreateObject("ADODB.RECORDSET")
rs1.open sql1,conn_sql,0,1
DO WHILE NOT rs1.eof
%>
<table width="359" border="0">
<tr>
<td width="10" align="right" scope="row"> </td>
<td width="36" align="left" scope="row"><img src="<%=rs1("tupian")%>"></td>
<td width="272" align="left" scope="row"><a href="guanli.asp?ccnf=yh"><%=rs1("biaoti")%></a></td>
<td width="23" align="left" scope="row"> </td>
</tr>
</table>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
</td>
<td width="63%" valign="top"><table width="150" border="0">
<tr>
<th scope="row"> </th>
</tr>
<tr>
<th scope="row"><img src="images/05.gif" width="150" height="200"></th>
</tr>
</table></td>
</tr>
<%
end if
%>
</table>
</body>
</html>
<%
end if
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -