?? middle.jsp
字號:
<table><tr><td height="118">
<%
sql="select * from logo ";
rs=mdb.executeQuery(sql);
if(!rs.next())
{
out.print("暫且沒有廣告");
}else{
%>
<a href="<%=rs.getString("url")%>"target="_blank"><img src="<%=rs.getString("banner")%>" width="395" height="118" border="0"></a>
</p>
<%
}
%>
<!---產(chǎn)品顯示-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="60">
<tr>
<td colspan="2">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="151" id="AutoNumber1" height="20" background="img/fu.gif">
<tr>
<td align="center" width="82"><b>精品推薦</b></td>
<td align="center"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<tr>
<%
sql="select top 10 * from hw where tuijian=-1 order by hw_id DESC";
rs=mdb.executeQuery(sql);
if(!rs.next())
{
%>
<td width="128" valign="top" align="left" bgcolor="#FFFFFF"><div align="center">
暫且沒有推薦商品<br></div>
</td>
<%
}
i=0;
while(rs.next())
{
i=i+1;
%>
<td align="left" bgcolor="#FFFFFF">
<table width="147" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td valign="bottom" width="285">
<div align="center">
<table width="200" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td valign="bottom" align="center">商品名稱:<%=rs.getString("hw_name")%></td>
</tr>
<tr>
<td align="center"><a href="views.jsp?hw_id=<%=rs.getInt("hw_id")%>">
<img border="0" src="<%=rs.getString("hw_pic")%>" width="114" height="83" vspace="6"></a></td>
</tr>
<tr>
<td align="center">會員價:<%=rs.getInt("hw_cash")%>元</td>
</tr>
<tr>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="60">
<tr>
<td colspan="2">
<table border="0" cellpadding="0" cells <td valign="top" align="center">
<a target="_blank" href="views.jsp?hw_id=<%=rs.getInt("hw_id")%>">詳情</a>
<a href='javascript:openbag(<%=rs.getInt("hw_id")%>)'>定購<img border="0" src="img/order.gif"></a></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td height="1" width="285"></td>
</tr>
</table>
</td>
<%
if(i%2==0&i>=2)
{
%>
</tr>
<tr>
<%
}
if(i>=10) {
break;
}
}
%>
</tr>
</table>
<!- 產(chǎn)品顯示結(jié)束-->
</td>
</tr></table>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -