📄 user_xvjiebook.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>续借图书</title>
</head>
<body>
<%
if session("userno")<>""and session("userpassword")<>"" then
%>
<%end if%>
<%
set strconn=server.createobject("ADODB.CONNECTION")
connstr="DBQ="+server.mappath("bookstore.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
strconn.open connstr
set rst=server.createobject("adodb.recordset")
rst.open "select * from 借书表 where userno='"&session("userno")&"'",strconn,3,3
i=1
while not rst.EOF
rst("bookborrowtime")=date()
rst("bookbacktime")=dateadd("m",1,date())
rst.update
rst.movenext
i=i+1
wend
rst.close
response.Write "<center><b><font size=2 >续借成功<a href=user_booklook.asp>返回</a></font><b></center>"
set rst=nothing
strconn.close
set strconn=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -