📄 mmxgxs.asp

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

💻 ASP

字号:

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

<%
xsmm = request("xsmm")
xxsmm1 = request("xxsmm1")
xxsmm2 = request("xxsmm2")
 xh=request("xh")
 bjbh=request("bjbh")

 
 dim rs
 dim sql
  set rs=server.createobject("adodb.recordset")
 sql="select * from "&bjbh&" where xh='" + xh + "'"
 rs.open sql,conn,3,3
 xsmm1 = request("xsmm")

if rs.eof then	
		response.write"<script language='javascript'>" 
		 response.write"alert('没有此学号！');" 
		 response.write"history.go(-1);"
		 response.write"</script>" 
		 response.end
end if
if xsmm<>rs("xsmm") then	
		response.write"<script language='javascript'>" 
		 response.write"alert('密码不对！');" 
		 response.write"history.go(-1);"
		 response.write"</script>" 
		 response.end
end if
if xxsmm1<>xxsmm2 then	
		response.write"<script language='javascript'>" 
		 response.write"alert('两次输入的密码不一样！');" 
		 response.write"history.go(-1);"
		 response.write"</script>" 
		 response.end
end if

 conn.execute("update ["&bjbh&"] set xsmm='"&xxsmm1&"' WHERE xh='"&xh&"'")
   conn.close
 set conn=nothing

%>
 
<center>　<p>　</p>
<p>密码修改成功！</center>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -