📄 guanli.asp
字号:
<%@ LANGUAGE="VBSCRIPT"%>
<%
subject=request("tm")
db1=request("db1")
db2=request("db2")
db3=request("db3")
db4=request("db4")
if ((len(db1)>40)or (len(db2)>40) or (len(db3)>40) or (len(db4)>40))then
response.write "所输入的1.2.3.4 数据太长!"
response.write "请酌情输入"
response.write "<a href=guanlib.htm>返回</a>"
response.end
end if
if subject="" then
response.write "<body bgcolor=""#FFCC99"" text=""#3333FF"">"
response.write "<font size=""6"" face=""Times New Roman, Times, serif"">"
response.write "所有表格不能为空,返回重新输入"
response.write "<a href=""vbscript:history.back(-1)"">返回</a>"
response.end
else
set conn=server.createObject("ADODB.Connection")
dbpath=server.mappath("diaocha.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs=server.createobject("adodb.recordset")
rs.LockType=2
end if
rs.open "select * from diaoc1",conn
rs.addnew
rs("sb")=trim(subject)
rs("db1")=trim(db1)
rs("db2")=trim(db2)
rs("db3")=trim(db3)
rs("db4")=trim(db4)
rs("db01")=CInt(0)
rs("db02")=CInt(0)
rs("db03")=CInt(0)
rs("db04")=CInt(0)
rs.Update
set rs=nothing
%>
<html>
<head>
<title>guanli0.asp</title>
</head>
<body bgcolor="#FFCC99" text="#0000FF" link="#0000FF">
<font size="4" face="Times New Roman, Times, serif">更新成功!</font><br>
如果继续录入请按
<a href="guanli.htm"><b><font size="6" face="Times New Roman, Times, serif">继续</font></b></a>
否则
<a href="javascript:window.close()"><b><font size="6" face="Times New Roman, Times, serif">关闭</font></b></a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -