bookrec_pic.jsp

JSP课件以及一个网上书店系统程序,带数据库

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" ID="Table8">
						<tr>
						<%
						i=0;
						sql="SELECT top 6  * FROM tushumingxi where commend=True order by date desc";
						rs=dbBean.exeSQL(sql);
						while(rs.next()){	
					    i=i+1;			
						%>
							<td width="35%">
								<table width="100%" border="0" cellspacing="0" cellpadding="2" ID="Table9">
									<tr>
										<td height="10"></td>
									</tr>
									<tr>
										<td rowspan="5" width="32%">
											<img src=<%=rs.getString("fengmian")%> width="60" height="80">
										</td>
										<td width="68%"><a href="Book_info.jsp?Bookid=<%=rs.getString("shuID")%>"><font color="#FF6600"><%=rs.getString("shu_name")%></font></a></td>
									</tr>
									<tr>
										<td width="68%" height="5"></td>
									</tr>
									<tr>
										<td width="68%">定价：￥<%=rs.getString("dingjia")%></td>
									</tr>
									<tr>
										<td width="68%">白金价：<font color="#FF0000">￥<%=rs.getString("huiyuanjia")%></font></td>
									</tr>
								</table>
							</td>
							<%
		if(i%3==0&i>=3)
		{
%>
  </tr>
 <tr>
                <%
         }
	   if(i>=10) {
	      break;
	   }
}
rs.close();
%>
			</tr>
		</table>