?? adminlook.asp
字號:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>學號搜索結果</title>
<style type="text/css">
<!--
body {
scrollbar-face-color: #FFC4B0;
scrollbar-highlight-color: #FFC4B0;
scrollbar-shadow-color: #FF7142;
scrollbar-3dlight-color: #FF7142;
scrollbar-arrow-color: #FF7142;
scrollbar-darkshadow-color:#FFC4B0;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(img/bg3.gif);
background-position:center;
margin-left: 0px;
}
body,td,th {
font-size: 16px;
color: #FF7142;
font-family: 宋體;
}
a {
font-family: 宋體;
font-size: 14px;
}
a:link {
text-decoration: none;
color: #FF7142;
}
a:visited {
text-decoration: none;
color: #FF7142;
}
a:hover {
text-decoration: none;
color: #FFB59D;
}
a:active {
text-decoration: none;
color: #FFB59D;
}
h1,h2,h3,h4,h5,h6 {
font-family: 宋體;
}
.style2 {color: #ff41b5}
-->
</style>
</head>
<body>
<%
dim rs
dim sql
dim conn
dim xh
xh=request("xh")
set conn=Server.CreateObject("adodb.connection") ''''''''''''''''''''''''''''''' 連接數據庫
set rs=server.CreateObject("adodb.recordset")
str="dsn=teacher"
conn.open str,"sa","810525"
if request("xh")<>"" then
sql="select * from teacher1 where tnum='"+xh+"'"
else
response.write "<script language=JavaScript>" & chr(13) & "alert('學號欄要全部填寫');"&"window.location.href = 'res.asp'"&" </script>"
Response.End
end if
rs.Open sql,conn,1,1
totalput=rs.RecordCount
if rs.EOF and rs.BOF then
Response.Write "當前沒有這個學號的成績~~~~~~~~~~"
else
%>
<table width="495" height="578" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="495" height="83" align="center" valign="top" background="img/top3.gif"> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td height="421" valign="top">
<table width="430" border="0" height="90%" align="center" cellpadding="0" cellspacing="0">
<tr><td width="478" height='421' valign='top' background="img/bg33.gif"><div align=center>
<p>
<p>在線查分個人編輯頁面</p>
</p>
<table width="423" border="1" bordercolor="#FFCC66">
<tr bgcolor="#FFFF66">
<td width="66" align="center"> 學號 </td>
<td width="100" align="center">姓名</td>
<td width="100" align="center">科目</td>
<td width="64" align="center">成績</td>
<td width="109" align="center">操作</td>
</tr>
</table>
<table width="428" height="24" border="0">
<%
do while not rs.eof
%>
<tr bgcolor=#FFCC99>
<td width="66" height="20" align="center"><%=rs("tnum")%></td>
<td width="100" align="center"><%=rs("tname")%></td>
<td width="100" align="center"><%=rs("tsc")%></td>
<td width="64" align="center"><%=rs("tscore")%></td>
<td width="109" align="center"><a href="update.asp?id=<%=rs("id")%>" target="_blank" class="blue" >修 改</a> <a href="delete.asp?id=<%=rs("id")%>" class="blue" onClick="return Delete();">刪 除</a></td>
</tr>
<%
rs.movenext
loop
end if
rs.Close
set rs=nothing
set conn=nothing
%>
</table>
<p> <table width="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="1" bgcolor="#FFCC9F" colspan="2"></td>
</tr>
<tr bordercolor="#FFCC99">
<td width="271" height="30" bordercolor="#FFCC99"> </td>
<td height="30" align="center" bordercolor="#FFCC66" bgcolor="#FFCC66"><a
href="gl.asp" class="black">返回主頁面</a> </td>
</tr>
<tr bgcolor="#FFCC9">
<td height="1" colspan="2"></td>
</tr>
</table></p>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -