?? studentsearchok.asp
字號:
<!--#include file="top.asp"-->
<!--#include file="conn.asp"-->
<%
number1=request.form("number1")
Set rs = Server.CreateObject("ADODB.Recordset")
number=session("number")
passwd=session("Passwd")
sql="select * from admin1 where number='"&number&"'and passwd='"&Passwd&"'"
rs.open sql,conn,3,3
if rs.eof then
response.redirect "index.asp"
response.end
end if
%>
<%
key1=rs("oskey")
IF not(KEY1="super") THEN
response.redirect "error.asp?id=065"
response.end
END IF
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css">
<title>理學院成績查詢系統-學生管理</title>
</head>
<body leftmargin="0" Topmargin="0" marginwidth="0" marginheight="0" background="images/greystrip.gIf">
<%Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from admin1 where number='"&number1&"'"
rs.open sql,conn,3,2
if rs.eof then
response.write"對不起,此學號不存在"
else
%>
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr><td><div align="right"><a href="manage.asp"><font color="red">返回管理首頁</font></a> </div></td></tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" bgcolor="#316395" vspace="0" hspace="0" bordercolor="#316395" bordercolordark="#FFFFFF" bordercolorlight="#316395" background="images/titbg.gIf" height="26" align="center">
<tr>
<td height="25"></td>
<td height="25"><div align="center"><a align="center">--<font color=red>學生信息修改刪除</font>--</a></div></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center" width="500"><a align="center"><br>修改學生信息</a></div></td><td width="100"><div align="center"><a href="delstudent.asp?number=<%=rs("number")%>" align="center"><br>刪除學生信息</a></div></td>
</tr><tr>
<td><br></td>
</tr>
</table>
<table align="center">
<form action="studentsearchokok.asp?number1=<%=rs("number")%>" method="post" name="form" id="form">
<tr>
<td width="278"> 學 號：
<input name="number" type="text" id="number" value="<%=rs("number")%>"></td>
</tr><tr> <td width="303"> 姓 名：
<input name="studentname" type="text" id="studentname" value="<%=rs("studentname")%>"></td>
</tr>
<tr>
<td>性 別：
<select name="sex">
<option selected><%=rs("sex")%></option>
<option>男</option>
<option>女</option></select></td>
</tr>
<tr>
<td>電 話：
<input name="phone" type="text" id="phone" value="<%=rs("phone")%>"></td>
</tr><tr> <td>宿 舍：
<input name="home" type="text" id="home" value="<%=rs("home")%>"></td>
</tr>
<tr> <td>班 級：
<select name="classname" style="border: 1px dotted #008000">
<option selected><%=rs("class")%></option>
<%
rs.close
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from class"
rs.open sql,conn,1,1
do while not rs.eof
sel="selected"
response.write "<option>"+rs("classname")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
rs.close
%>
</select>
</td>
</tr>
<tr>
<td><p>
</p>
<p align="center">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</p></td>
</tr>
</form>
</table>
<%end if%>
</body>
</html>
<!--#include file="bottom.asp"-->?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -