mod_admin.asp

来自「学生档案管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和」· ASP 代码 · 共 27 行

<!-- #include file = "conn.asp" -->
<!-- #include file = "chkuser.asp" -->
<%
dim strSQL, cmdObj, rsObj
dim admin_name
admin_name  =  Request.Form("admin_name")

       Set cmdObj  =  Server.CreateObject("ADODB.Command")
       Set rsObj  =  Server.CreateObject("ADODB.RecordSet")
       cmdObj.CommandText  =  "SELECT * FROM admin WHERE admin_name = '" & admin_name & "'"
       cmdObj.CommandType  =  1
       Set cmdObj.ActiveConnection  =  conn
       rsObj.Open cmdObj, , 2,3
       rsObj("admin_pwd")  =  Request.Form("pwd")	   
       rsObj.Update
       rsObj.Close
       set rsObj = nothing

     '  CloseConn()
%>
<script language = Javascript>
<!--
alert("修改成功！");
window.location = "info_manager.asp"
-->
</script>