achmodifysave.asp

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

<!-- #include file = "conn.asp" -->
<!--#include file = "chkuser.asp"-->
<%
	   dim strSQL, cmdObj, rsObj
	   dim id
       id  =  Request.Form("id")
       Set cmdObj  =  Server.CreateObject("ADODB.Command")
       Set rsObj  =  Server.CreateObject("ADODB.RecordSet")
      ' cmdObj.CommandText  =  "SELECT top 1 * FROM ach ORDER by ID desc"
	   cmdObj.CommandText  =  "SELECT * FROM ach WHERE ID=" & id & ""
       cmdObj.CommandType  =  1
       Set cmdObj.ActiveConnection  =  conn
       rsObj.Open cmdObj, , 2,3
       rsObj("user_testnumber")  = Request.Form("user_testnumber")
       rsObj("user_name")  = Request.Form("user_name")
	   rsObj("user_class")  = Request.Form("user_class")
	   rsObj("testno")  = Request.Form("testno")
	   rsObj("subject")  = Request.Form("subject")
	   rsObj("ach")  = Request.Form("ach")
       rsObj.Update
       
       rsObj.Close
       set rsObj = nothing
       set cmdObj = nothing
       
   '  CloseConn()
%>
<script language = Javascript>
<!--
alert("修改成功！");
window.location = "ach_manager.asp"
-->
</script>