save.asp
来自「留言簿毕业设计用ASP和SQL2000开发的能够链接」· ASP 代码 · 共 28 行
ASP
28 行
<html>
<head>
<title></title>
</head>
<body>
<%
Dim sql,UserId,UserName,zhiwei,bumen,shijian
UserId=Request("UserId")
UserName=Request("UserName")
zhiwei=Request("zhiwei")
bumen = Request("bumen")
shijian = Request("shijian")
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="driver={SQL Server};server=(local);UID=sa;PWD=13513343483;Database=学院人事管理系统"
Conn.Open
sql="INSERT INTO 调动记录 (UserId,UserName,zhiwei, bumen, shijian) VALUES('" & UserId & "','" & UserName & "','" & zhiwei & "','" & bumen & "','" & shijian & "')"
Conn.Execute(sql)
Response.Redirect"success.asp"
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?