modclass.asp

来自「网络教学管理系统」· ASP 代码 · 共 23 行

<!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<%
	Dim strName ,strSchoolID ,strZhuanyeID ,strMainTeacher ,strID ,strUrl
	strName = trim(Request.Form("name"))
	strSchoolID = trim(Request.Form("SchoolID"))
	strZhuanyeID = trim(Request.Form("ZhuanyeID"))
	strMainTeacher = trim(Request.Form("mainteacher"))
	strID = Request.QueryString("ID")
	strUrl = "Mod_Class.asp?ID="& strID
	If strID &"" = "" Then
		Response.Write("参数错误！")
		Response.End
	End If 
	
	Dim rs ,strSql 
	strSql = "UPDATE Class Set Name = '"& strName &"', ZhuanyeID = '"& strZhuanyeID &"' ,SchoolID = '"& strSchoolID &"' ,MainTeacher = '"& strMainTeacher &"' WHERE ID = "& strID
	Set rs = Server.CreateObject("ADODB.Recordset")
	rs.open strSql,conn,3,1
	Response.Redirect(strUrl)

%>