📄 recsave.asp

📁 本同学录系统演示地址:　http://class.19870123.cn/ 下载后请在Web.Config里更改设置,如数据库路径等如果要换sql数据库,请将app_code里的MyPage

💻 ASP

字号:

<html>
<head>
<title>保存用户信息</title>
</head>
<body>
<%
  '定义变量
  Dim sql, vFlag, vUserName, vSubject, vWords, vUpperId
  '从参数或表单中接收数据到变量中
  vUserName = Request("name")
  vSubject = Request("Subject")
  vWords = Request("Words")
  vEmail = Request("Email")
  vHomepage = Request("homepage")
  vFace = CLng(Request("logo"))
  vUpperId = CLng(Request("UpperId"))
 
  'Server对象的CreateObject方法建立Connection对象
  Set Conn=Server.CreateObject("ADODB.Connection")
  Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("book.mdb")
  Conn.Open
  
  '生成当前时间
  vCreateTime = Now

  '插入新数据
  sql="INSERT INTO Content (Subject, Words, UserName, CreateTime, Face, Email," _
    	& " Homepage, UpperId) VALUES('" & vSubject & "','" & vWords & "','" & vUserName & "','" _
    	& vCreateTime & "','" & vFace & ".gif','" & vEmail & "','" & vHomepage & "'," & vUpperId & ")" 
  Conn.Execute(sql)

  Response.Write "<h2>信息已成功保存！</h2>"
%>
</body>
<Script language="javascript">
  //打开此脚本的网页将被刷新
  opener.location.reload();
  //停留800毫秒后关闭窗口
  setTimeout("window.close()",800);
</Script>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -