📄 main.jsp
字号:
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>
</TBODY></TABLE></TD></TR></TBODY></TABLE> <TABLE cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
<TBODY>
<%
rs.close(); //关闭查询链接
String sql1=new String();
sql1= "select * from book order by recentSale desc"; //对数据库中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=点击查看更多精品推荐 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>
现在市场价：<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="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>
现在市场价：<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="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>
现在市场价：<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="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>
现在市场价：<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>
</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"; //对数据库中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("数据库操作错误！");
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>版权所有 2003-2004 © All rights MagicTeam reseverd</TD></TR></TBODY></TABLE>
<DIV align=center></DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -