save.asp
来自「留言簿毕业设计用ASP和SQL2000开发的能够链接」· ASP 代码 · 共 31 行
ASP
31 行
<html>
<head>
<title></title>
</head>
<body>
<%
Dim sql,UserId,UserName,shengao ,tizhong ,xuexing ,jiankang ,hunyin
UserId=Request("UserId")
UserName=Request("UserName")
shengao=Request("shengao")
tizhong=Request("tizhong")
xuexing = Request("xuexing")
jiankang=Request("jiankang")
hunyin=Request("hunyin")
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, shengao, tizhong,xuexing,jiankang,hunyin) VALUES('" & UserId & "','" & UserName & "','" & shengao & "','" & tizhong & "','" & xuexing & "','" & jiankang & "','" & hunyin & "')"
Conn.Execute(sql)
Response.Redirect"success.asp"
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?