⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 changestudentinfo.asp

📁 一套完整的学生课程管理系统
💻 ASP
字号:
<!-- #include file="utility/checkAdmin.asp" -->

<%
	'****************************************
	'目的:			依据学号读取信息并显示
	'开始时间:		2005-6-4 16:11
	'最后修改时间:	2005-6-4 16:11
	'编写人:		某某某
	'****************************************
	
	'定义变量
	dim studentID
	dim studentName
	dim studentPassword
	dim studentGrade
	dim studentSex
	dim studentPhone
	dim studentEmail
	dim studentAddress
	dim studentCheck
	dim sql
	dim rs
	
	studentID = Request.QueryString("stuID")
	
	if(studentID = "") then
		Alert("参数丢失,操作失败!")
		GoBack()
		Response.end
	end if
	
	sql = "select * from student where ID = '" & studentID & "'"
	Set rs = ExecuteQuery(sql)
	
	if(rs.EOF) then
		Alert("没有这个学号的学生,操作失败!")
		GoBack()
		rs.close()
		set rs = nothing
		Response.end
	end if
	
	studentName = rs("sName")
	studentPassword = rs("sPassword")
	studentGrade = rs("sGrade")
	studentSex = rs("sSex")
	studentPhone = rs("sPhone")
	studentEmail = rs("sEmail")
	studentAddress = rs("sAddress")
	studentCheck = rs("sCheck")
	
	rs.close()
	set rs = nothing

%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>基本信息</title>
<link rel="stylesheet" type="text/css" href="images/link.css">
</head>
<div align="center">
<table border="1" width="580" id="table2" cellpadding="0" height="131" style="border-collapse: collapse">
				<form action="manageStudent.asp?actionType=change&stuID=<%=studentID%>" method="post" name="baseInfoForm">
				<tr>
					<td height="27" width="104" align="right" bgcolor="#F2F2F2">学号:</td>
					<td height="27" width="531" valign="bottom">
						&nbsp;&nbsp;<input type=text name="studentID" class="inputText" size="20" readonly value="<%=studentID%>"><font color="#FF0000">*</font>
					</td>
				</tr>
				<tr>
					<td height="27" width="104" align="right" bgcolor="#F2F2F2">姓名:</td>
					<td height="27" width="531" valign="bottom">
						&nbsp;&nbsp;<input type=text name="studentName" class="inputText" size="20" value="<%=studentName%>" ><font color="#FF0000">*</font></td>
				</tr>
				<tr>
					<td width="104" height="27" align="right" bgcolor="#F2F2F2">密码:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input type=password name="studentPassword" size="20" class="inputText"><font color="#FF0000">如不修改请留空</font></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">密码确认:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input type=password name="studentPasswordChk" size="20" class="inputText"><font color="#FF0000">如不修改请留空</font></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">班级:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input name="studentGrade" size="20" class="inputText" value="<%=studentGrade%>" ><font color="#FF0000">*</font></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">性别:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input type="radio" value="男" <%if(studentSex = "男") then response.write("checked")%> name="studentSex" id="fp1"><label for="fp1">男</label>&nbsp;&nbsp;
					<input type="radio" name="studentSex" value="女" <%if studentSex = "女" then response.write("checked")%> id="fp2"><label for="fp2">女</label></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">电话:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input name="studentPhone" size="20" class="inputText" value="<%=studentPhone%>"></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">邮箱:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input name="studentEmail" size="20" class="inputText" value="<%=studentEmail%>"></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">住址:</td>
					<td width="531" height="27" valign="bottom">
						&nbsp;&nbsp;<input name="studentAddress" size="50" class="inputText" value="<%=studentAddress%>"></td>
				</tr>
				<tr>
					<td width="104" align="right" height="27" bgcolor="#F2F2F2">
					操作:</td>
					<td width="531" height="27" valign="middle">
						&nbsp;&nbsp;
					<button type=submit class="anniu" style="width: 60px; height: 20px">提 交</button>&nbsp;&nbsp;&nbsp; &nbsp; 
					<button type=reset class="anniu" style="width: 60px; height: 20px">重 写</button></td>
				</tr>
				</form>
			</table>
</div>
<body>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -