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 + -
显示快捷键?