new.jsp

网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询

<script>
  function openbag(id) { 
  window.open("basket.jsp?id="+id,"","height=420,width=460,left=190,top=10,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
  } 
</script>
<table width="600" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td width="83" height="1"></td>
    <td width="7"></td>
    <td width="13"></td>
    <td colspan="5" rowspan="3" valign="top"><div align="center"><a href="#">程序设计</a><img src="image/line.gif" width=1 height=13 hspace=7 vspace=5 align=absmiddle><a href="#">数据库管理</a><img src="image/line.gif" width=1 height=13 hspace=7 vspace=5 align=absmiddle><a href="#">图形处理</a><img src="image/line.gif" width=1 height=13 hspace=7 vspace=5 align=absmiddle><a href="#">网络工程</a><img src="image/line.gif" width=1 height=13 hspace=7 vspace=5 align=absmiddle><a href="#">计算机硬件</a><img src="image/line.gif" width=1 height=13 hspace=7 vspace=5 align=absmiddle><a href="#">更多内容>></a></div></td>
  </tr>
  <tr>
    <td rowspan="4" valign="middle" background="image/banner.jpg"><div align="right" class="style1">
      <div align="center"><span style="">图 书 展</span></div>
    </div></td>
    <td height="20" valign="top" bgcolor="#FF5F01"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td height="2"></td>
    <td></td>
  </tr>
  <tr>
    <td height=1 colspan="7" valign="top" background="image/dian.gif"><img src="images/blank.gif" width=1 height=1></td>
  </tr>
  <tr>
    <td height="1"></td>
    <td></td>
    <td width="87"></td>
    <td width="23"></td>
    <td width="181"></td>
    <td width="26"></td>
    <td width="183"></td>
  </tr>
  <tr>
    <td height="25"></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
  <td></td>
  <td></td>
  <td>&nbsp;</td>
  </tr>
  <tr>
  <%
	int i=0;
sql="select top 4 * from tushumingxi";
rs=stmt.executeQuery(sql);
while(rs.next())
{
i=i+1;
%>
    <td height="82" colspan="4" align="center" valign="middle">
		<table width="185" border="0" cellpadding="0" cellspacing="1">
        <!--DWLayoutTable-->
        <tr>
          <td width="60" rowspan="5" valign="top"><img src=<%=rs.getString("fengmian")%> width=60 height=80></td>
          <td width="122" height="2"></td>
        </tr>
        <tr>
          <td height="15" valign="middle">书名：<%=rs.getString("shu_name")%></td>
        </tr>
        <tr>
          <td height="15" valign="middle">ISBN：<%=rs.getString("ISBN")%></td>
        </tr>
        <tr>
          <td height="15" valign="middle">作者：<%=rs.getString("zhuozhe")%></td>
        </tr>
        <tr>
          <td height="29" align="right" valign="top">
		    <a href="javascript:openbag(<%=rs.getString("shuID")%>)"><img src="image/buy_ico.gif" width="60" height="26" border="0"></a></a></td>
        </tr>
    </table></td><td></td>
				
						<%
		if(i%2==0&i>=2)
		{
%>
  </tr>
 <tr>
               
                
                <%
         }
	   if(i>=10) {
	      break;
	   }
}
rs.close();
%>
</tr>
</table>