new_booksrec.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<table width="100%" border="0" align="center" cellspacing="1" ID="Table20">
														<tr>
															<td height="36"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table21">
																	<tr>
																		<td height="30" bgcolor="#E8E8E8" class="m"><div align="center"><font color="#CE0005"><img src="pic/hc_info_08.gif" width="11" height="11">
																					<strong><font color="#CE0005">新书推荐</font></strong></div>																		</td>
																	</tr>
																</table>															</td>
														</tr>
													
</table>
													
							<table width="100%" border="0" cellspacing="2" cellpadding="0" align="center" ID="Table22">
							<%	sql="SELECT top 5 shuID,shu_name,fengmian,dingjia,huiyuanjia FROM tushumingxi order by date desc";
						rs=dbBean.exeSQL(sql);
						while(rs.next()){	%>	
																	<tr>
																		<td><table width="100%" border="0" cellspacing="0" cellpadding="2" ID="Table23">
																				<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>
																				<tr>
																					<td height="15"></td>
																				</tr>
																			</table>																		</td>
																	</tr>
																	<tr>
																		<td height="1" bgcolor="#000000"></td>
																	</tr>
																	<%}%>
</table>