📄 jec_add2.asp
字号:
<!--#include file="chkadmin.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<title>学生成绩管理系统</title>
</head>
<body>
<%
Dim j(8),proid,jec,jecsum
jecsum=Request("jecsum")
jec=Request("jec")
proid=Request("proid")
%>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#ffffff" width="100%">
<tr>
<td width="100%" background="../Images/admin_table_bg.gif" height="25" colspan="2">
<p align="center"><b><font color="#FFFFFF">添加考试类型:步骤二</font></b></td>
</tr>
<tr>
<td width="9%" height="15" bgcolor="#D9E6FF">考试名称:</td>
<td width="91%" height="15" bgcolor="#D9E6FF"><%=jec%> </td>
</tr>
<tr>
<td width="9%" height="15" bgcolor="#D9E6FF">科目数:</td>
<td width="91%" height="15" bgcolor="#D9E6FF"><%=jecsum%> </td>
</tr>
<tr>
<td width="9%" height="15" bgcolor="#D9E6FF">所属专业:</td>
<td width="91%" height="15" bgcolor="#D9E6FF"> <%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from pro where id="&proid,conn,1,1
Response.Write rs("pro")
rs.Close
Set rs=nothing
%>
</td>
</tr>
<tr>
<td width="100%" height="15" bgcolor="#D9E6FF" colspan="2">
<form method="POST" action="jec_add_ok.asp">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
<tr>
<td width="9%">所属科目:</td>
<td width="91%">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%" id="AutoNumber1">
<tr>
<td width="3%">1.</td>
<td width="58%">
<select name="j1" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
<td width="39%" rowspan="8"><font color="#FF0000">『注意』<br>
1.根据科目数依次选择科目；<br>
2.不同表单不要选择相同科目；<br>
3.选择的科目数量一定要与科目数相同；<br>
3.此处添加后不能修改!</font></td>
</tr>
<tr>
<td width="3%">2.</td>
<td width="58%">
<select name="j2" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">3.</td>
<td width="58%">
<select name="j3" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">4.</td>
<td width="58%">
<select name="j4" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">5.</td>
<td width="58%">
<select name="j5" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">6.</td>
<td width="58%">
<select name="j6" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">7.</td>
<td width="58%">
<select name="j7" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
<tr>
<td width="3%">8.</td>
<td width="58%">
<select name="j8" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Response.Write "<option value=" & "1>请选择</option>"
Do While Not fs.EOF
If fs("proid")=Cint(proid) Then
%>
<option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="9%"> </td>
<td width="91%">
<input type="submit" value="添 加" name="B1"></td>
</tr>
</table>
<input type="hidden" name="jec" value="<%=jec%>">
<input type="hidden" name="jecsum" value="<%=jecsum%>">
<input type="hidden" name="proid" value="<%=proid%>">
</form>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -