?? main.jsp
字號:
color=#ff6600>|</FONT></u></DIV></TD>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=兒童文學(xué)&ToPage=<%=1%>">
<u>兒童文學(xué)</u></a></DIV></TD></TR>
<TR>
<TD width=70>
<DIV align=center>
<a href="sortList.jsp?sort=美術(shù)書法&ToPage=<%=1%>">
<u>美術(shù)書法</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=文學(xué)藝術(shù)其它&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>【英語學(xué)習(xí)】</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=輔導(dǎo)叢書&ToPage=<%=1%>">
<u>輔導(dǎo)叢書</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=英語學(xué)習(xí)其他&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=輔導(dǎo)光盤&ToPage=<%=1%>">
<u>輔導(dǎo)光盤</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=英語學(xué)習(xí)其他&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"; //對數(shù)據(jù)庫中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>
現(xiàn)在市場價：<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>
現(xiàn)在市場價：<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>
現(xiàn)在市場價：<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>
現(xiàn)在市場價：<DEL><%=price%>元</DEL><BR>
一星會員價：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星會員價：<FONT
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -