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