📄 gwsxwxs.asp

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

💻 ASP

字号:




<!--#include file="conn.asp"-->
 <body bgcolor="#FFFFFF" text="#000000" background="BG01.gif">

<%
 dim rs
 dim sql
  set rs=server.createobject("adodb.recordset")
 sql="select * from gg Order by rq desc"

rs.open sql,conn,1,1
total=rs.recordcount
    if not rs.eof then   
 bt=rs("bt")
  rq=rs("rq")
 bh=rs("bh")
  nr=rs("nr")
 end if  
  
    
  

 %>




 

<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>A {
	COLOR: black; FONT-STYLE: normal; TEXT-DECORATION: none
}
A:hover {
	BACKGROUND: red; COLOR: yellow; FONT-STYLE: normal; TEXT-DECORATION: none
}
A:active {
	COLOR: #0080ff; FONT-STYLE: normal; TEXT-DECORATION: none
}
TABLE {
	BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; BORDER-RIGHT: 0px; BORDER-TOP: 0px; FONT-SIZE: 9pt; cellspacing: "0"; cellpadding: "0"
}
.space {
	LINE-HEIGHT: 0.5cm
}
P {
	FONT-SIZE: 9pt; LINE-HEIGHT: 18px; font-famliy: 宋体
}
BIG {
	FONT-SIZE: 10.8pt; LINE-HEIGHT: 18px; font-famliy: 宋体
}
.p10pt {
	FONT-SIZE: 10pt
}
</STYLE>

<title>龚文生新闻系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="config.css" type="text/css">
<script language='javascript'>
<!--

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>


</head>
<%
if bh<>"" then
%>
<body bgcolor="#FFFFFF" text="#000000" onLoad="MM_openBrWindow('lys31.asp?bh=<%=bh%>', 'Sample', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=yes,height=340,width=420,left=0,top=0')"','','width=400,height=420')" background="BG01.gif"></head></html>
<%
else
%>
<body bgcolor="#FFFFFF" text="#000000" background="BG01.gif">
<%
end if
%>

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
                
        <div align="center"><b><font color="#0066FF">共有<font color=red><%=total%></font>条公告</font></b></div>
    </td>
  </tr>
</table>




	<table>
    <tr>
  


<%
do while not rs.eof
i=i+1
bh=rs("bh")
bt=rs("bt")
nr=rs("nr")
rq=rs("rq")



%>

  
  
  
  
  
    
    <td align=center><font color="red"><%=i%></font></td>
        <td align=left><%=rq%></td>
       <td align=center>
    <a href="#" onClick="window.open('lys31.asp?bh=<%=bh%>', 'Sample', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=yes,height=340,width=420,left=0,top=0')">
    <font color="green"><%=bt%></font></a></td></tr>
   

    
    
    
 <%
rs.movenext
loop
Response.Write("</table>") 
Response.Write("</center>")
 rs.close
set rs=nothing
conn.close
set conn=nothing
 
 

%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -