📄 left.asp
字号:
<!--#include file="conn.asp"-->
<%
sql="select * from xhbooktype"
set rs=db.execute(sql)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</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;
}
-->
</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="xh_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"><font color="#FFFFFF">图 书 分 类</font></td>
</tr>
<%do while not rs.eof%>
<tr>
<td align="center" bgcolor="#FFFFFF" class="2"><a href="xh_look.asp?booktype=<%=rs("booktype")%>" target="right"><%=rs("booktype")%></a></td>
</tr>
<%
rs.movenext
loop
%>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="xh_add.asp" target="right">添加图书分类</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="xh_select.asp" target="right">查询书籍</a></td>
</tr>
<tr>
<td align="center" bgcolor="#006699" class="2"><a class=2 href="xh_qlook.asp" target="right">显示全部书籍</a></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('xh_qlook.asp')</script>"
end if
%>
<form name="form1" method="post" action=""><tr>
<td height="20" colspan="2" valign="top">
<br>
<table class=1 width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr bgcolor="#006699">
<td colspan="2" align="center"><font color="#FFFFFF">添 加 图 书</font></td>
</tr>
<tr align="center">
<td width="35%"><font color="#FFFFFF">书名:</font></td>
<td width="65%"><font color="#FFFFFF">
<input name="name" type="text" id="name" size="15">
</font></td>
</tr>
<tr align="center">
<td><font color="#FFFFFF">分类:</font></td>
<td><font color="#FFFFFF">
<select name="select">
<option value="不清楚" selected>不清楚</option>
<%
rs.movefirst
do while not rs.eof%>
<option value=<%=rs("booktype")%>><%=rs("booktype")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
</font></td>
</tr>
<tr align="center">
<td><font color="#FFFFFF">价格:</font></td>
<td><font color="#FFFFFF">
<input name="money" type="text" id="money" size="10">
元</font></td>
</tr>
<tr align="center">
<td><font color="#FFFFFF">出版社:</font></td>
<td><font color="#FFFFFF">
<input name="publishing" type="text" id="publishing" size="15">
</font></td>
</tr>
<tr align="center">
<td><font color="#FFFFFF">出版日期:</font></td>
<td><font color="#FFFFFF"> </font></td>
</tr>
<tr align="center">
<td colspan="2"><font color="#FFFFFF">
<select name="date1" id="date1">
<option value="95" selected>95</option>
<option value="96">96</option>
<option value="97">97</option>
<option value="98">98</option>
<option value="99">99</option>
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
</select>
年
<select name="date2" id="date2">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<select name="date3" id="date3">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
日</font></td>
</tr>
<tr align="center">
<td colspan="2"><font color="#FFFFFF">
<input type="submit" name="Submit3" value="添加">
<input type="reset" name="Submit22" value="重置">
<input name="active" type="hidden" id="active" value="yes">
</font></td>
</tr>
</table>
</td>
</tr></form>
</table>
<div align="center"><br>
e人图书录入V1.0教案系列</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -