newbooks1.jsp

来自「网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询」· JSP 代码 · 共 30 行

<table  border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
  <% sql="SELECT TOP 4 tushumingxi.shuid,tushumingxi.date,tushumingxi.fengmian,tushumingxi.shu_name,tushumingxi.dingjia FROM tushumingxi ORDER BY tushumingxi.date DESC;";
 rs=stmt.executeQuery(sql);
%>
  <%
while(rs.next()){
%> 
    <td width="167" height="78" valign="top">
	    
	<table width="150" background="image/tonew3.gif">
  <tr>

<td width="154" height="115" align="center" valign="middle"><img src=<%=rs.getString("fengmian")%> width=100 height=120>
</td>
  </tr>
  <tr>
    <td height="13" align="center" valign="top"> <a href="bookinfo.jsp?id=<%=rs.getString("shuid")%>"><%=rs.getString("shu_name")%></a> </td>
  </tr>
  <tr>
    <td height="13" align="center" valign="top">&#23450;&#20215;&#65306;￥<%=rs.getString("dingjia")%>元</td>
  </tr>
</table>

</td><% }
%>
  </tr>
</table>