📄 left.asp
字号:
<!--#include file="conn.asp"-->
<%
sql="select * from booktype"
set rs=db.execute(sql)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>2Fly图书管理系统 Left</title>
<style type="text/css">
<!--
.1 {
font-size: 9pt;
text-decoration: none;
border: 1px solid #000000;
}
-->
</style>
<style type="text/css">
<!--
.2 {
font-size: 9pt;
color: #FFFFFF;
text-decoration: none;
}
-->
</style>
<style type="text/css">
<!--
div {
font-size: 9pt;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
</head>
<body bgcolor="#0099CC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="216" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#0099CC">
<tr>
<td height="51" colspan="2" valign="top"> <a class=2 href="2fly_qlook.asp" target="right">
</a><br>
<table class=1 width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="center" bgcolor="#006699"><a href="2fly_book_class.asp" target="right"><font color="#FFFFFF"><br>
图 书 分 类 管理</font></a> </td>
</tr>
<%do while not rs.eof%>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_look.asp?booktypeid=<%=rs("booktypeid")%>" target="right"><%=rs("booktype")%></a></td>
</tr>
<%
rs.movenext
loop
%>
<tr>
<td align="center" bgcolor="#006699"><a href="#"><br>
<font color="#FFFFFF">图书借阅 管理</font></a> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_boroow_in.asp" target="right">会员借阅</a></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_borrow.asp" target="right">会员归还</a></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_borrow.asp" target="right">借阅列表</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699"><a href="#"><br>
<font color="#FFFFFF">会员 管理</font></a> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_reader_look.asp" target="right">会员列表</a></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="2fly_reader.asp" target="right">添加会员</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="2fly_book_read.asp" target="right"><br>
添加图书</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="2fly_select.asp" target="right">查询书籍</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="2fly_look.asp" target="right">显示全部书籍</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="2fly_look.asp?feiqi=feiqi" target="right">废弃图书统计</a><br> </td>
</tr>
</table></td>
<%
if request.form("active")="" then
else
set rs2=server.createobject("adodb.recordset")
date1=request.form("date1")
date2=request.form("date2")
date3=request.form("date3")
insertsql="select * from xhbook"
rs2.open insertsql,db,1,3
rs2.addnew
rs2("bookname")=trim(request.form("name"))
rs2("booktype")=trim(request.form("select"))
rs2("bookmoney")=trim(request.form("money"))
rs2("publishing")=trim(request.form("publishing"))
rs2("xhdate")=date1&"-"&date2&"-"&date3
rs2.update
response.write "<script>parent.right.location.href('2fly_qlook.asp')</script>"
end if
%>
</table>
<div align="center"><br>
2FlyWorkroom</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -