⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 cj_select2.asp

📁 C# SQL 齐齐哈尔职业学院学生成绩管理系统
💻 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 classid,classnum,classname
classid=Request.Form("classid")
set fs=server.createobject("adodb.recordset")
fs.open "select * from [class] where id="&Cint(classid),conn,1,1
proid=fs("proid")
classnum=fs("num")
fs.close
Set fs=nothing

set fs=server.createobject("adodb.recordset")
fs.open "select * from [pro] where id="&proid,conn,1,1
classname=fs("xi")&fs("pro")&classnum
fs.close
Set fs=nothing
%>
<form method="post" action="cj_select3.asp">
<div align="center">
  <center>
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#ffffff" width="100%" height="55">
    
    <tr>
      <td width="100%" background="../Images/admin_table_bg.gif" height="24" colspan="2">
      <p align="center"><font color="#FFFFFF"><b><%=classname%>班成绩录入:选择考试名称</b></font></td>
    </tr>
    
    <tr>
      <td width="8%" height="14" bgcolor="#D9E6FF">考试名称:</td>
      <td width="92%" height="14" bgcolor="#D9E6FF">
      <select name="jecid" tabindex="1">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [jec]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有考试类型</option>"
Else
Do While Not fs.EOF
  If fs("proid")=Cint(proid) Then
%>      
      <option value=<%=fs("id")%>><%=fs("jec")%></option>
<%
  End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
      </select></td>
    </tr>
    
    <tr>
      <td width="8%" bgcolor="#D9E6FF" height="15">
       </td>
      <td width="92%" bgcolor="#D9E6FF" height="15">
    <input type="hidden" value="<%=classid%>" name="classid">  
    <input type="hidden" value="<%=proid%>" name="proid"> 
    <input type="hidden" value="<%=classname%>" name="classname">  
   <input type="submit" value="下一步" name="B1" tabindex="2"> (2/3)</td>
    </tr>
  </table>
  </center>
</div>
</form>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -