📄 add.asp
字号:
<body style="font-size:12px"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><%
xh_mdb_server="data/#Robot.mdb"
dim conn,connstr
'on error resume next
connstr="DBQ="+server.mappath(""&xh_mdb_server&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("adodb.recordset")
id=request("id")
XH_Answer=request("XH_Answer")
if id<>"" and XH_Answer<>"" then
rs.open "Select * from XH_Robot where id="&request("id"),conn,1,3
rs("XH_Question")=request("XH_Question")
rs("XH_Answer")=request("XH_Answer")
rs("xh_sendok")=0
rs.update
rs.close
%>
<font color=red>添加成功</font><br>
<%
end if
rs.open "Select * from XH_Robot where XH_SendOk=1",conn,1,1
do while not rs.eof
%><form name=forms action="" method=post style="margin:0px">
<input name="id" value="<%=rs("id")%>" size=5> <input name="XH_Question" value="<%=rs("XH_Question")%>" size=50> <input name="XH_Answer" value="" size=50> <input type="submit" value="提交"></form><hr>
<%
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -