📄 addcj.asp
字号:
<!--#include file="top.asp"-->
<!--#include file="conn.asp"-->
<%
number1=request.form("number1")
Set rs = Server.CreateObject("ADODB.Recordset")
number=session("number")
passwd=session("Passwd")
sql="select * from admin1 where number='"&number&"'and passwd='"&Passwd&"'"
rs.open sql,conn,3,3
if rs.eof then
response.redirect "index.asp"
response.end
end if
key1=rs("oskey")
IF not(KEY1="super") THEN
response.redirect "error.asp?id=065"
response.end
END IF
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css">
<title>理学院成绩查询系统-添加新成绩</title>
</head>
<%Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from admin1 where number='"&number1&"'"
rs.open sql,conn,3,2
if rs.eof then
response.write"对不起,此学号不存在"
else
%>
<body leftmargin="0" Topmargin="0" marginwidth="0" marginheight="0" background="images/greystrip.gIf">
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr><td><div align="right"><a href="manage.asp"><font color="red">返回管理首页</font></a> </div></td></tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" bgcolor="#316395" vspace="0" hspace="0" bordercolor="#316395" bordercolordark="#FFFFFF" bordercolorlight="#316395" background="images/titbg.gIf" height="26" align="center">
<tr>
<td width="163">
<font color=red>学生信息:</font></td>
<td width="206"> 学号: <font color=green><%=number1%></font></td>
<td width="150">姓名: <font color=green><%=rs("studentname")%></font></td>
<td width="241">班级:<font color=green><%=rs("class")%></font></td>
</tr>
</table>
<table align="center"><tr><td height="11"></td>
</tr>
<form action="addcjok.asp?number1=<%=number1%>" method="post" name="form" id="form">
<tr>
<td><div align="center">学年学期：
<select name="xueqi" style="border: 1px dotted #008000">
<%
rs.close
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from xueqi"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option " & sel & ">"+rs("xueqi")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td></tr><tr><td> </td>
</tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c1" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j1" type="text" id="j1">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c2" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j2" type="text" id="j2">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c3" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j3" type="text" id="j3">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c4" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j4" type="text" id="j4">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c5" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j5" type="text" id="j5">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c6" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j6" type="text" id="j6">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c7" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j7" type="text" id="j7">
</div></td></tr>
<tr>
<td width=249 ><div align="center">选择科目：
<select name="c8" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j8" type="text" id="j8">
</div></td></tr>
<tr>
<td width=249 hight=14><div align="center">选择科目：
<select name="c9" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j9" type="text" id="j9">
</div></td></tr>
<tr>
<td width=249><div align="center">选择科目：
<select name="c10" style="border: 1px dotted #008000">
<option selected></option>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from kecheng"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("ke")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</div></td><td width="251"><div align="center">成绩：
<input name="j10" type="text" id="j10">
</div></td></tr>
<tr>
<td colspan="2" align="center"><div align="center"><br>
<br>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
<table>
<tr><td></td></tr></table>
</form></table>
<%end if%>
</body>
</html>
<!--#include file="bottom.asp"-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -