📄 jsgl0.asp
字号:
<!--#include file="pwd.asp" -->
<!--#include file="xmgl_conn.inc" -->
<%
if session("sxh")="" then
cxh=request.form("txh")
cbj=left(cxh,5)
ccxh=right(cxh,2)
sql="select * from bjk where bjdm='"&cbj&"'"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open sql, xmgl_Conn
if rs.eof then
response.write("<font color=""#FF0000"">班级代码“"&cbj&"”不存在!</font>")
%>
<p>
<a href="jsgl.asp">返回</a><p>
<%
rs.close
set rs=nothing
response.end
else
tbjmc=rs("bjmc") '返回班级名称
rs.close
end if
sql="select * from "&cbj&" where xh='"&ccxh&"'"
RS.Open sql, xmgl_conn
if rs.eof then
response.write("<font color=""#FF0000"">“"&tmc&"("&cbj&")”的学号“"&ccxh&"”不存在!</font>")
%>
<p>
<a href="jsgl.asp">返回</a><p>
<%
rs.close
set rs=nothing
response.end
else
txm=rs("xm") '返回姓名
end if
rs.close
set rs=nothing
session("sxh")=cxh
session("sxm")=txm
session("sbjmc")=tbjmc
end if
%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=gb_2312-80">
<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
<title>借书管理</title>
</head>
<body bgcolor="#C0C0C0">
<h3 align="center">“<%=session("sxm")%>(<%=session("sxh")%>)”借书</h3>
<hr width="80%">
<form action="jsgl1.asp" method="POST" name="myform">
<div align="center"><center><table border="0" cellpadding="2"
width="80%">
<tr>
<td align="right" width="33%">图书编号：</td>
<td width="33%"><input type="text" size="7"
name="tbh"></td>
<td width="20%"> </td>
</tr>
<tr>
<td align="right" width="33%">册数：</td>
<td width="33%"><input type="text" size="3"
name="tcs" value="1"></td>
<td width="20%"> </td>
</tr>
<tr>
<td align="right" width="33%">借书日期：</td>
<td width="33%"><u><input type="text" size="10"
name="trq" value=<%=date()%>></u></td>
<td width="20%"> </td>
</tr>
<tr>
<td width="33%"> </td>
<td width="33%"><p><input type="button" name="cmd"
value="借书"> <input type="reset" name="B2"
value="取消"> </p>
</td>
<td width="20%"><script language="VBScript">
sub cmd_onclick
set oform=document.myform
sbh=oform.tbh.value
scs=oform.tcs.value
srq=oform.trq.value
if trim(sbh)="" then
msgbox "必须输入编号!",,"借书管理"
elseif len(trim(sbh))<>7 then
msgbox "编号输入错误！",,"借书管理"
elseif not isnumeric(scs) or cint(scs)<1 then
msgbox "必须输入册数或册数错误!",,"借书管理"
elseif cint(scs)>1 then
msgbox "同一本书一次只能借一本!",,"借书管理"
elseif not isdate(srq) then
msgbox "日期输入错误!",,"借书管理"
else
oform.submit
end if
end sub
</script></td>
</tr>
</table>
</center></div>
</form>
<p align="center"><a href="jsgl.asp">返回</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -