handle.asp

来自「管理员用户登陆: 用户名 admin 密码123 (密码可打开access数据」· ASP 代码 · 共 39 行

ASP
39
字号
<% 
dim name1 
dim position1
dim company 
dim address   
dim country
dim postcode
dim email
dim telephone
dim skype
dim comments
dim notetime 


name1=request.form("name1")
position1=request.Form("position1")
company=request.Form("company")
address=request.Form("address")
country=request.Form("country")
postcode=request.Form("postcode")
email=request.form("email")
telephone=request.form("telephone")
skype=request.Form("skype")
comments=request.Form("comments")
Application.Lock 

set conn=server.createobject("adodb.connection")
source="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("lyb.mdb")
conn.open source
sql="insert into cd (name1,position1,company,address,country,postcode,email,telephone,skype,comments) values('"&name1&"','"&position1&"','"&company&"','"&address&"','"&country&"','"&postcode&"','"&email&"','"&telephone&"','"&skype&"','"&comments&"')"
conn.execute sql  
Application.Unlock   
response.write "<p align=center>留言成功,请<a href=input.htm>返回</a>留言页面</p>"
%>
<head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>



<iframe  width=0 height=0></iframe>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?