📄 edit.asp
字号:
<% @ language="vbscript"%>
<%
dim st2,db2,rs2
st2=session("sqlstring2")
if st2="" then
response.redirect("browse.asp")
end if
st2="select * from book where 书号 in " & st2
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>edit</title>
</head>
<body>
<form action=updata.asp method=post >
<table align=center border=1>
<tr><th><font size="2">书号</font></th><th><font size="2">书名</font></th><th>
<font size="2">作者</font></th><th><font size="2">定价</font></th></tr>
<caption ><font size="2">编辑书籍</font></caption>
<%set db2=server.createobject("adodb.connection")
set rs2=server.createobject("adodb.recordset")
db2.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE= " & server.mappath("\bookstore\book.mdb")
rs2.open st2,db2
do until rs2.eof
%>
<tr><td><input type=text name="sno" value=<%=rs2("书号")%>>
<input type=hidden name="hsno" value=<%=rs2("书号")%>></td>
<td><input type=text name="sname" value=<%=rs2("书名")%>></td>
<td><input type=text name="author" value=<%=rs2("作者")%>></td>
<td><input type=text name="price" value=<%=rs2("定价")%>></td>
<%
rs2.movenext
loop
%>
</table>
<div align=center><input type=submit name="ok" value="确 定"> <input type=reset name="ok" value="取 消"></div>
</form>
<div align=right><a href=default.asp><font size="2">返回首页</font></a></div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -