do_mdysmt.asp

来自「包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL」· ASP 代码 · 共 20 行

ASP
20
字号
<HTML> <BODY>
<%
	str = Request("xuehao")
	yuwen = Request("yuwen")
	shuxue = Request("shuxue")
	yingyu = Request("yingyu")
	set conn = Server.CreateObject("ADODB.Connection")
	conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" &_
		Server.MapPath("person.mdb"))
	set cmd = Server.CreateObject("ADODB.Command")
	cmd.ActiveConnection = conn
	sql = "UPDATE grade SET 数学 = " & shuxue & ",英语=" &_
		yingyu & ",语文=" &	yuwen & " where 学号=" & str
	Response.Write(sql)
	cmd.CommandText = sql
	cmd.Execute()
	Response.Redirect("pageV6.asp")
%> 
</BODY> </HTML>

⌨️ 快捷键说明

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