?? main.jsp
字號:
color=#ff6600><%=price*0.85%>元<br>
三星會員價(jià)：<%=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>
</TBODY></TABLE></TD></TR></TBODY></TABLE> <TABLE cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
<TBODY>
<%
rs.close(); //關(guān)閉查詢鏈接
String sql1=new String();
sql1= "select * from book order by recentSale desc"; //對數(shù)據(jù)庫中recentSale中的值降序排列
ResultSet rs1 = stmt.executeQuery(sql1);
rs1.next();
%>
<TR>
<TD>
<DIV align=center><A href=commendList.jsp?limitNum=1&ToPage=1 ><IMG
height=32 alt=點(diǎn)擊查看更多精品推薦 src="images/jptj.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="30%">
<TABLE cellSpacing=0 cellPadding=0 width="101%" id="table15" style="border: 1px dotted #008080">
<TBODY>
<TR>
<TD width="92%">
<font color="#FF6600">
</font>
<% bookID=rs1.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs1.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs1.getString("bookName")%></font></a><BR>
現(xiàn)在市場價(jià)：<DEL><%=price%>元</DEL><BR>
一星會員價(jià)：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星會員價(jià)：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星會員價(jià)：<%=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="30%">
<TABLE cellSpacing=0 cellPadding=0 width="99%" id="table19" style="border: 1px dotted #008080">
<TBODY>
<% rs1.next(); %>
<TR>
<TD width="92%">
<font color="#FF6600"> </font>
<% bookID=rs1.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs1.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs1.getString("bookName")%></font></a><BR>
現(xiàn)在市場價(jià)：<DEL><%=price%>元</DEL><BR>
一星會員價(jià)：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星會員價(jià)：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星會員價(jià)：<%=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="30%">
<TABLE cellSpacing=0 cellPadding=0 width="101%" id="table25" style="border: 1px dotted #008080">
<TBODY>
<% rs1.next(); %>
<TR>
<TD width="92%">
<font color="#FF6600">
</font>
<% bookID=rs1.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs1.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs1.getString("bookName")%></font></a><BR>
現(xiàn)在市場價(jià)：<DEL><%=price%>元</DEL><BR>
一星會員價(jià)：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星會員價(jià)：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星會員價(jià)：<%=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="30%">
<TABLE cellSpacing=0 cellPadding=0 width="99%" id="table29" style="border: 1px dotted #008080">
<TBODY>
<% rs1.next(); %>
<TR>
<TD width="92%">
<font color="#FF6600">
</font>
<% bookID=rs1.getString("bookID");%>
<a href="detailView.jsp?bookID=<%=bookID%>">
<% price=rs1.getDouble("bookPrice");%>
<font color="#FF6600"><%=rs1.getString("bookName")%></font></a><BR>
現(xiàn)在市場價(jià)：<DEL><%=price%>元</DEL><BR>
一星會員價(jià)：<FONT
color=#ff6600><%=price*0.90%>元</FONT> <br>
二星會員價(jià)：<FONT
color=#ff6600><%=price*0.85%>元<br>
三星會員價(jià)：<%=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>
</TBODY></TABLE></TD></TR>
</TBODY></TABLE>
<p> </TD>
<TD vAlign=top width=158 height="1" rowspan="2">
<TABLE cellSpacing=1 cellPadding=0 width="100%" bgColor=#a5ced4
border=0 height="51"><TBODY>
<TR>
<TD background="images/cxph.gif" height=24>
<DIV align=center></DIV></TD></TR>
<TR>
<TD bgColor=#deefef>
<%
rs1.close();
int i;
String SQL=new String();
SQL = "select * from book order by currentSale desc"; //對數(shù)據(jù)庫中CurrentSale中的值降序排列
ResultSet rs2 = stmt.executeQuery(SQL);
%>
<%
for(i=0;i<23;i++)
{
if(rs2.next()){
%>
·<a href="detailView.jsp?bookID=<%=rs2.getString("bookID")%>"><%=rs2.getString("bookName")%></a><BR>
<%
}
else
{
out.println("數(shù)據(jù)庫操作錯(cuò)誤！");
break;
}
}
rs2.close();
stmt.close();
con.close();
%>
<br>
<DIV align=right>
<a href="topList.jsp?limitNum=1&ToPage=1"">更多排行>></a> </DIV></TD></TR></TBODY></TABLE><BR>
</TD></TR>
<tr>
<TD vAlign=top width=160 height="28">
<p> </p>
</TD>
</tr>
</TBODY></TABLE>
<%}
catch(Exception e)
{
out.println(e.toString());
}
%>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=1 cellPadding=0 width="100%" align=center
bgColor=#89bec6 border=0>
<TBODY>
<TR bgColor=#aacfd5>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 26px"> </TD></TR>
</TBODY></TABLE>
<DIV align=center></DIV></TD></TR>
<TR>
<TD height=6></TD></TR>
</TBODY></TABLE>
<HR align=center width=776 color=#339999 SIZE=1>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD align=middle>版權(quán)所有 2003-2004 © All rights MagicTeam reseverd</TD></TR></TBODY></TABLE>
<DIV align=center></DIV></BODY></HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -