shopshow.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<script language="JavaScript">
function show(a)
{
  window.open("wareshow.jsp?action="+a,"body","scrollbars=yes,width=434,height=500");
}
</script>
<table width="564" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><img src="images/commendware.gif" width="564" height="30" border="0" usemap="#Map"></td>
  </tr>
  <tr> 
    <td background="/images/main_new_bg.gif">
	<table align="center" cellpadding="0" cellspacing="0" border="0" width="540">
    <%
	String sql="select top 16 * from ware where censor_yes='"+"1"+"' and nominate='"+"1"+"' and dustbin='"+"0"+"' and habitus='"+"0"+"' order by id desc";
	ResultSet rs=data.executeQuery(sql);
	int i=0;
	int picid=0;
	String warename="";
	int marketprice=0;
	int managerprice=0;
	int vipprice=0;
	String small_pic="";
	while(rs.next())
	{
	i++;
	picid=rs.getInt("id");
	warename=rs.getString("warename");
	marketprice=rs.getInt("marketprice");
	managerprice=rs.getInt("managerprice");
	vipprice=rs.getInt("vipprice");
	small_pic=rs.getString("small_pic");
	%>
	<%if(i%4==1){%>
	<tr bgcolor="#FFFFFF">
	<%}%>
	<td width="150">
	<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
	<td height="15"></td>
	</tr>
	<tr>
	<td height="135"><div align="center"> 
      <table width="100" border="0" cellpadding="0" cellspacing="2" bgcolor="#E6E6E6">
        <tr> 
           <td bgcolor="#FFFFFF"><a href="javascript:show(<%=picid%>)"><img src="upload/<%=small_pic%>" alt="点击查看<%=warename%>" width="100" height="100" border="0"></a></td>
        </tr>
      </table>
     </div></td>
	</tr>
	<tr>
	<td height="18"><div align="center"><s>市场价:<font color="#999999"><%=marketprice%></font></s></div></td>
	</tr>
	<tr>
	<td height="18"><div align="center">会员价:<font color="#999999"><%=managerprice%></font></div></td>
	</tr>
	<tr>
	<td height="18"><div align="center">VIP价:<font color="#999999"><%=vipprice%></font></div></td>
	</tr>
	<tr>
	<td height="20"><div align="center"><a href="javascript:show(<%=picid%>)"><font color="#FF0000"><%=warename%></font></a></div></td>
	</tr>
	<tr>
	<td height="20"><div align="center"><a href="addware.jsp?add=<%=picid%>"><img src="images/buy.gif" width="78" height="20" border="0"></a></div></td>
	</tr>
	<tr>
	<td height="15"></td>
	</tr>
	</table>
	</td>
	<%if(i%4==0){%>
	</tr>
	  <tr height="1"> 
    <td height="1" bgcolor="#E3E2E2" colspan="4"></td>
  </tr>
	<%}}%>
	</table>
	</td>	
  </tr>
</table>
<map name="Map">
  <area shape="rect" coords="288,4,412,28" href="hotware.jsp">
  <area shape="rect" coords="427,4,560,29" href="newware.jsp">
</map>