📄 inf_delete_student.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
var StudentMessage;
var StudentRs;
StudentMessage=Request.QueryString("studentmessage");
StudentRs=Server.CreateObject("ADODB.Recordset");
StudentRs.ActiveConnection=Conn;
StudentRs.Source="SELECT * FROM student WHERE studentNo="+StudentMessage;
StudentRs.CursorLocation=3;
StudentRs.Open();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生信息删除</title>
</head>
<body>
<div align="center">
<%
if(!StudentRs.EOF){%>
<a onClick="return confirm('确定删除？')" href="inf_delete_student_result.asp?studentmessage=<%=StudentRs("studentNo")%>">
<font size="6" color="#FF0000">要删除请点击这里</font>
</a>
</div>
<table border="1" width="100%" bordercolor="#ff0000" bgcolor="#00ffff" cellPadding="0" cellSpacing="0">
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">学籍号：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(0).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">姓名：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(1).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">性别：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%Response.Write(StudentRs(2).Value);%></font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">出生年月：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(3).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">民族：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(4).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">政治面貌：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%Response.Write(StudentRs(5).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">所在院系：</font></td>
<td height="20" colspan="2"><font size="2" color="#000000"><%Response.Write(StudentRs(6).Value);%></font></td>
<td height="20"><font size="2" color="#FF0000">所学专业：</font></td>
<td height="20" colspan="2"><font size="2" color="#000000"><%Response.Write(StudentRs(7).Value);%></font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">所在班级：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(8).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">班级学号：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(9).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">培养方式：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%Response.Write(StudentRs(10).Value);%></font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">学制：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(11).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">入学年份：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(12).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">学历：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%Response.Write(StudentRs(13).Value);%></font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">外语语种：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(14).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">外语水平：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%Response.Write(StudentRs(15).Value);%></font></td>
<td height="20" width="126"><font size="2" color="#FF0000">身体状况：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%Response.Write(StudentRs(16).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">在读情况：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(17).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">家庭住址：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(18).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">联系电话：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(19).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">EMAIL：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(20).Value);%></font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">个人主页：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(21).Value);%></font></td>
</tr>
<tr>
<td height="200"><font size="2" color="#FF0000">大学期间奖惩情况：</font></td>
<td height="200" colspan="5"><font size="2" color="#000000"><%Response.Write(StudentRs(22).Value);%></font></td>
</tr>
</table>
<%
}else{
Response.Redirect("errormessage.asp?message=数库中已无此记录，可能已经删除&toUrl=admin_main_manage.asp");
}
StudentRs.Close();
Conn.Close();
StudentRs=null;
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -