📄 glycksj.asp

📁 学生成绩管理是学校管理的重要组成部分。成绩不仅关系到学生成绩升迁

💻 ASP

字号:

<!--#include file="conn.asp"-->
<%

  if Session.Contents("gws")<>true then
 %>
<body text="#000000" background="bg01.gif">
<p align="center">请重新登录！
<%  
else
sql="SELECT * from xxld Order by bh" 

set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
	
total=rs.recordcount


%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="config.css" type="text/css">
</head>
<body text="#000000" background="bg01.gif">
</p>
<div align="center">
  <center>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  <tr>
    <td>
          <div align="center"><b><font face="华文行楷" size="6" color="red">
            管理校级人员窗口</font></b></div>　
            <div align="center"><b><font color="#0066FF">共找到<font color=red><%=total%></font>位校级管理人员 
        </font></b></div>
    </td>
  </tr>
</table>



  </center>
</div>



<center>

	<table border=1 cellpadding=1 cellspacing=1>
    <tr bgcolor=black style='color:white'>
    
    <td align=center>编号</td>
    
    <td align=center>登录号</td>

    <td align=center>姓名</td>

    <td align=center>性别</td>
    
    <td align=center>部门</td>

    <td align=center>职务</td>

    <td align=center>密码</td>

    <td align=center>删除此人</td>

    <td align=center>修改</td>



<%
do while not rs.eof
i=i+1
xm=rs("xm")
xb=rs("xb")
zw=rs("zw")
mm=rs("mm")
bh=rs("bh")
bm=rs("bm")



%>

  
  
  
<% 
 If sColor = "silver" Then
		sColor = "#cccccc"
	Else
		sColor = "silver"
	End If
   
	Response.Write("<tr bgcolor='" & sColor & "'>")	 
%> 
	 

  
  
  
  
  
  
  
    
    <td align=center><font color="red"><%=i%></font>　</td>
    <td align=center><%=bh%>　</td>
        <td align=center><%=xm%>　</td>
    <td align=center><%=xb%>　</td>
    <td align=center><%=bm%>　</td>

        <td align=center><%=zw%>　</td>
    <td align=center><%=mm%>　</td>

   <td align=center><a href=sjggsc.asp?bh=<%=bh%>><font color="red">点击删除</font></a></td>
    <td align=center><a href=gwsxjxg.asp?bh=<%=bh%>><font color="green">点击修改</font></a></td>

    </tr>
   

    
    
    
 <%
rs.movenext
loop

Response.Write("</table>") 
Response.Write("</center>")

%>
 <!--#include file="nnx.asp"-->

</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -