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

📄 gwsbjxg.asp

📁 学生成绩管理是学校管理的重要组成部分。成绩不仅关系到学生成绩升迁
💻 ASP
📖 第 1 页 / 共 5 页
字号:
<!--#include file="conn.asp"-->
<%
 zybj=request("zybj")
 
 dim rs
 dim sql
  set rs=server.createobject("adodb.recordset")
 sql="select * from zybjmc where zybj='" + zybj + "'"
 rs.open sql,conn,1,1
 
 
 dim rs1
 dim sql1
  set rs1=server.createobject("adodb.recordset")
 sql1="select * from xf where zybj='" + zybj + "'"
 rs1.open sql1,conn,1,1






 set rs2=server.createobject("adodb.recordset")
 sql2="select * from js where zybj='" + zybj + "'"
 rs2.open sql2,conn,1,1

 set rs3=server.createobject("adodb.recordset")
 sql3="select * from xg where zybj='" + zybj + "'"
 rs3.open sql3,conn,1,1

%>
<html>
 <head>
  <title>修改班级信息</title>
 </head>
 <body topmargin=0 leftmargin=0 rightmargin=0 bgcolor="#FFFFFF" background="BG01.gif">
    <center>
  <font face="华文行楷" size="6" color="#FF0000"><b>修改班级信息</b></font></center>
 <form action=xg.asp method=post>
   <table width=570 cellpadding=4 cellspacing=1 bgcolor=#ff0000 align=center height="1">
             
     <tr bgcolor=#FFcccc>
    <td align=center width=100 height="19">系
        <td height="19" width="432" colspan="3"><input type=text name="s" size=20 maxlength=20 class=i value="<%=rs("s")%>"><font size="2">最多10个汉字&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font><a href=scbjqr.asp?zybj=<%=zybj%>&bjbh=<%=rs("bjbh")%> title="请三思而后行"><font color="red"><kbd>点击删除</kbd></font></a><kbd>此记录</kbd>

    <tr bgcolor=#FFcccc>
    <td align=center width=100 height="1">班级名称
        <td height="1" width="432" colspan="3">&nbsp;<%=rs("zybj")%>
                <input type=hidden name="zybj" value="<%=rs("zybj")%>">    
<br>
    <tr bgcolor=#FFcccc>
    <td align=center width=100 height="19">管理员密码
        <td height="19" width="433" colspan="3"><input type=text name="glymm" size=20 maxlength=20 class=i value="<%=rs("glymm")%>"><font size="2">20个字符以内</font>
   <tr bgcolor=#FFcccc>
    <td align=center width=100 height="1">班主任
        <td height="1" width="238"><input type=text name="byxf" size=10 maxlength=10 class=i value="<%=rs("byxf")%>"><font size="2">5个汉字以内    </font>
      
        <td height="1" width="123">
        <p align="center">毕业学分<td height="1" width="90">
       <input type=text name="xf" size=6 maxlength=10 class=i value="<%=rs("xf")%>"><tr bgcolor=#FFcccc>
    <td align=center width=100 height="11">班主任性别
    <%
    xb=rs("xb")
    if xb="男" then
    %>
        <td height="11" width="433" colspan="3"><input type=radio name="xb" value="男" checked>男&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=radio name="xb" value="女">女
    <%   
    else
    %>
        <td height="11" width="433" colspan="3"><input type=radio name="xb" value="男">男&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=radio name="xb" value="女" checked>女
    <%
    end if
    %>
           
  </table>
  
   
   
   
   
   
   
   
  
     <center>
        
  <table width="800" cellspacing=0 bgcolor=#FFCCbb height="2" style="border-collapse: collapse" bordercolor="#000000" bordercolorlight="#0000FF" bordercolordark="#0000FF" border="1">

            <tr>
        <td width="28" height="16" align="center"><font size="2">序号</font></td>
        <td width="148" height="16" align="center"><font size="2">一学期课程名称</font></td>
        <td width="36" height="16" align="center"><font size="2">学分</font></td>
        <td width="65" height="16" align="justify">
        <p align="center"><font size="2">&nbsp;任课教师<a target="_blank" href="jsINDEX.ASP">代码查看</a></font></td>
        <td width="117" height="16" align="center"><font size="2">修改</font></td>
        <td width="6" height="16" align="center" bgcolor="#00FF00"> </td>
        <td width="148" height="16" align="center"><font size="2">二学期课程名称</font></td>
        <td width="36" height="16" align="center"><font size="2">学分</font></td>
        <td width="65" height="16" align="center">
        <p><font size="2">&nbsp;任课教师<a target="_blank" href="jsINDEX.ASP">代码查看</a></font></td>
        <td width="117" height="16" align="center"><font size="2">修改</font></td>
      </tr>
    
         <tr>
        <td width="28" height="16" align="center"><font size="2">1</font></td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs10" size=20 maxlength=20 class=i value="<%=rs("fs10")%>"> </font>  </td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s10" size=4 maxlength=4 class=i value="<%=rs1("fs10")/10%>"> </font></td>
        <td width="60" height="16" align="center"><font size="2">
        <input type=text name="js10" size=8 maxlength=4 class=i value="<%=rs2("fs10")%>"></font></td>
        <td width="117" height="16" align="justify">
  
           
        <%
    xg10=rs3("fs10")
    if xg10=1 then
    %>

        
        <input type=radio name="xg10" value="1" checked><font size="2">能&nbsp;</font> <input type=radio name="xg10" value="0"><font size="2">不能</font>
        
          <%   
    else
    %>

        
        <input type=radio name="xg10" value="1"><font size="2">能&nbsp; </font> <input type=radio name="xg10" value="0" checked><font size="2">不能</font>
        
        
        <%
    end if
    %>
 
        
        
        
        
        </td>
        <td width="6" height="16" align="center" bgcolor="#00FF00"> </td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs20" size=20 maxlength=20 class=i value="<%=rs("fs20")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s20" size=4 maxlength=4 class=i value="<%=rs1("fs20")/10%>"> </font></td>
        
        <td width="61" height="16" align="center"><font size="2">
        <input type=text name="js20" size=8 maxlength=4 class=i value="<%=rs2("fs20")%>"></font></td>
        <td width="117" height="16" align="justify">
        
                <%
    xg20=rs3("fs20")
    if xg20=1 then
    %>


        <input type=radio name="xg20" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg20" value="0"><font size="2">不能</font>
                <%   
    else
    %>
 <input type=radio name="xg20" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg20" value="0" checked><font size="2">不能</font>
      <%
    end if
    %>

</td>
      </tr>
    
      <tr>
        <td width="28" height="16" align="center"><font size="2">2</font></td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs11" size=20 maxlength=20 class=i value="<%=rs("fs11")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s11" size=4 maxlength=20 class=i value="<%=rs1("fs11")/10%>"> </font></td>
        <td width="60" height="16" align="center"><font size="2">
        <input type=text name="js11" size=8 maxlength=4 class=i value="<%=rs2("fs11")%>"></font></td>
        <td width="117" height="16" align="justify">
                   <%
    xg11=rs3("fs11")
    if xg11=1 then
    %>


        <input type=radio name="xg11" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg11" value="0"><font size="2">不能</font>
   <%   
    else
    %>
        <input type=radio name="xg11" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg11" value="0" checked><font size="2">不能</font>
           <%
    end if
    %>
   
 
        </td>
        <td width="6" height="16" align="center" bgcolor="#00FF00"> </td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs21" size=20 maxlength=20 class=i value="<%=rs("fs21")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s21" size=4 maxlength=20 class=i value="<%=rs1("fs21")/10%>"> </font></td>
        

        <td width="61" height="16" align="center"><font size="2">
        <input type=text name="js21" size=8 maxlength=4 class=i value="<%=rs2("fs21")%>"></font></td>
        <td width="117" height="16" align="justify">
                   <%
    xg21=rs3("fs21")
    if xg21=1 then
    %>


        <input type=radio name="xg21" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg21" value="0"><font size="2">不能</font>
        <%   
    else
    %>
        <input type=radio name="xg21" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg21" value="0" checked><font size="2">不能</font>
                   <%
    end if
    %>
   

        </td>
        


      </tr>
 
      <tr>
        <td width="28" height="16" align="center"><font size="2">3</font></td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs12" size=20 maxlength=20 class=i value="<%=rs("fs12")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s12" size=4 maxlength=20 class=i value="<%=rs1("fs12")/10%>"> </font></td>
        <td width="60" height="16" align="center"><font size="2">
        <input type=text name="js12" size=8 maxlength=4 class=i value="<%=rs2("fs12")%>"></font></td>
        <td width="117" height="16" align="justify">
                   <%
    xg12=rs3("fs12")
    if xg12=1 then
    %>


        <input type=radio name="xg12" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg12" value="0"><font size="2">不能</font>
                <%   
    else
    %>
    
        <input type=radio name="xg12" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg12" value="0" checked><font size="2">不能</font>
      
                      <%
    end if
    %>
       
        </td>
        <td width="6" height="16" align="center" bgcolor="#00FF00"> </td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs22" size=20 maxlength=20 class=i value="<%=rs("fs22")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s22" size=4 maxlength=20 class=i value="<%=rs1("fs22")/10%>"> </font></td>
        

        <td width="61" height="16" align="center"><font size="2">
        <input type=text name="js22" size=8 maxlength=4 class=i value="<%=rs2("fs22")%>"></font></td>
        <td width="117" height="16" align="justify">
                   <%
    xg22=rs3("fs22")
    if xg22=1 then
    %>


        <input type=radio name="xg22" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg22" value="0"><font size="2">不能</font>
<%   
    else
    %>
  
        <input type=radio name="xg22" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg22" value="0" checked><font size="2">不能</font>
   <%
    end if
    %>
  
        </td>
        

        </tr>
   
      <tr>
        <td width="28" height="16" align="center"><font size="2">4</font></td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs13" size=20 maxlength=20 class=i value="<%=rs("fs13")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">
        <input type=text name="s13" size=4 maxlength=20 class=i value="<%=rs1("fs13")/10%>"> </font></td>
        <td width="60" height="16" align="center"><font size="2">
        <input type=text name="js13" size=8 maxlength=4 class=i value="<%=rs2("fs13")%>"></font></td>
        <td width="117" height="16" align="justify">
                   <%
    xg13=rs3("fs13")
    if xg13=1 then
    %>


        <input type=radio name="xg13" value="1" checked><font size="2">能&nbsp; 
        </font><input type=radio name="xg13" value="0"><font size="2">不能</font>
        <%   
    else
    %>
        <input type=radio name="xg13" value="1"><font size="2">能&nbsp; 
        </font><input type=radio name="xg13" value="0" checked><font size="2">不能</font>
   <%
    end if
    %>
 
        </td>
        <td width="6" height="16" align="center" bgcolor="#00FF00"> </td>
        <td width="148" height="16" align="center"><font size="2">
        <input type=text name="fs23" size=20 maxlength=20 class=i value="<%=rs("fs23")%>"> </font></td>
        <td width="36" height="16" align="center"><font size="2">

⌨️ 快捷键说明

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