📄 main.jsp
字号:
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=儿童文学&ToPage=<%=1%>">
<u>儿童文学</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=美术书法&ToPage=<%=1%>">
<u>美术书法</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD><TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=文学艺术其它&ToPage=<%=1%>">
<u>其 他</u></a></DIV></TD>
</TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD colSpan=3>
<DIV align=center>【英语学习】</DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语教材&ToPage=<%=1%>">
<u>英语教材</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=辅导丛书&ToPage=<%=1%>">
<u>辅导丛书</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语考试&ToPage=<%=1%>">
<u>英语考试</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=考研英语&ToPage=<%=1%>">
<u>考研英语</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=高中英语&ToPage=<%=1%>">
<u>高中英语</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语学习其他&ToPage=<%=1%>">
<u>其他读物</u></a></DIV></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD colSpan=3>
<DIV align=center>【磁带光盘】</DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语磁带&ToPage=<%=1%>">
<u>英语磁带</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语MP3&ToPage=<%=1%>">
<u>英语MP3</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=辅导光盘&ToPage=<%=1%>">
<u>辅导光盘</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=电影VCD&ToPage=<%=1%>">
<u>电影VCD</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center><a href="sortList.jsp?sort=DVD光盘&ToPage=<%=1%>"><u>DVD光盘</u></a></DIV></TD>
<TD width=14>
<DIV align=center><u><FONT
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=英语学习其他&ToPage=<%=1%>">
<u>其 他</u></a></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</TD>
<%
String sql=new String();
sql= "select * from book order by pubDate desc"; //对数据库中pubDate中的值降序排列
ResultSet rs = stmt.executeQuery(sql);
rs.next();
//while(rs.next())
// out.println(rs.getString("bookName"));
%>
<TD vAlign=top width=457 height="15" rowspan="2">
<TABLE cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
<TBODY>
<TR>
<TD>
<DIV align=center><A href=newList.jsp?pubDate=1990/1/1&ToPage=1 ><IMG
height=32 alt=点击查看更多新书 src="images/xpsj.jpg"
width=436 border=0></A></DIV></TD></TR>
<TR>
<TD height=68>
<TABLE cellSpacing=2 cellPadding=2 width="100%" align=center
border=0>
<TBODY>
<TR>
<TD width="32%">
<TABLE cellSpacing=0 cellPadding=0 width="101%" style="border: 1px dotted #339999">
<TBODY>
<TR>
<TD style="PADDING-LEFT: 6px" vAlign=top
width="96%">
<font color="#FF6600">
</font>
<% String bookID=rs.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% double price=rs.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs.getString("bookName")%></font></a><BR>
现在市场价：<DEL><%=price%>元</DEL><BR>
一星会员价：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星会员价：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星会员价：<%=price*0.75%>元<BR>
<div align="center">
<TABLE cellSpacing=0 cellPadding=0 width="112">
<TBODY>
<TR>
<TD align=center width=62 height=22><INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('detailView.jsp?bookID=<%=bookID%>','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=查看 name=Submit2232>
</TD>
<TD width=50 height=22 align="center"> <INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('orderVIew.jsp?bookID=<%=bookID%> ','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=购买 name=Submit2232>
</TD></TR></TBODY></TABLE></div>
</font>
</TD>
</TR></TBODY></TABLE></TD>
<TD width="32%">
<TABLE cellSpacing=0 cellPadding=0 width="100%" id="table7" style="border: 1px dotted #008080">
<TBODY>
<% rs.next(); %>
<TR>
<TD style="PADDING-LEFT: 6px" vAlign=top
width="96%">
<font color="#FF6600">
</font>
<% bookID=rs.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs.getString("bookName")%></font></a><BR>
现在市场价：<DEL><%=price%>元</DEL><BR>
一星会员价：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星会员价：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星会员价：<%=price*0.75%>元<BR>
<div align="center">
<TABLE cellSpacing=0 cellPadding=0 width="112">
<TBODY>
<TR>
<TD align=center width=62 height=22><INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('detailView.jsp?bookID=<%=bookID%> ','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=查看 name=Submit2232>
</TD>
<TD width=50 height=22 align="center"> <INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('orderVIew.jsp?bookID=<%=bookID%> ','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=购买 name=Submit2232>
</TD></TR></TBODY></TABLE></div>
</font>
</TD>
</TR></TBODY></TABLE></TD>
</TR>
<TR>
<TD width="32%" height="126">
<TABLE cellSpacing=0 cellPadding=0 width="101%">
<TBODY>
<% rs.next(); %>
<TR>
<TD width="87%" style="border: 1px dotted #008080">
<font color="#FF6600"> </font>
<% bookID=rs.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs.getString("bookName")%></font></a><BR>
现在市场价：<DEL><%=price%>元</DEL><BR>
一星会员价：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星会员价：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星会员价：<%=price*0.75%>元<BR>
<div align="center">
<TABLE cellSpacing=0 cellPadding=0 width="112">
<TBODY>
<TR>
<TD align=center width=62 height=22><INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('detailView.jsp?bookID=<%=bookID%> ','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=查看 name=Submit2232>
</TD>
<TD width=50 height=22 align="center"> <INPUT style="BORDER-RIGHT: #000000 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #000000 1px solid; COLOR: #000000; LINE-HEIGHT: normal; BORDER-BOTTOM: #000000 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 16px; BACKGROUND-COLOR: #dbecee; FONT-VARIANT: normal" onclick="javascript:window.open('orderVIew.jsp?bookID=<%=bookID%> ','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;" type=button value=购买 name=Submit2232>
</TD></TR></TBODY></TABLE></div>
</font>
</TD></TR></TBODY></TABLE></TD>
<TD width="28%" height="126">
<TABLE cellSpacing=0 cellPadding=0 width="100%" id="table9" style="border: 1px dotted #008080">
<TBODY>
<% rs.next(); %>
<TR>
<TD width="85%">
<font color="#FF6600"> </font>
<% bookID=rs.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs.getString("bookName")%></font></a><BR>
现在市场价：<DEL><%=price%>元</DEL><BR>
一星会员价：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星会员价：<FONT
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -