rel_books.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center" ID="Table42">
													<tr>
															<td><img src="pic/indexnew_22.gif" height="13" width="67"></td>
														</tr>
														<tr>
															<td background="../images/index14.gif" height="1" bgcolor="#E7DFD6"></td>
														</tr>
													
</table>
													<table width="98%" border="0" cellspacing="2" cellpadding="0" align="center" ID="Table43">
													<%
													String Bookid1=request.getParameter("Bookid");
						sql="select lieID from tushumingxi where shuID="+Bookid1;
													 ResultSet rs2=dbBean.exeSQL(sql);
													while(rs2.next()){
													String lieID=dbBean.getString(rs2,"lieID");
											sql="select top 10 shuID,shu_name,dingjia from tushumingxi where lieID="+lieID;
											rs=dbBean.exeSQL(sql);
													while(rs.next()){
													%>
														<tr>
															<td><table width="98%" border="0" cellspacing="0" cellpadding="3" align="center" ID="Table44">
																	<tr>
																		<td width="2%"><div align="center"><img src="pic/publish6.gif" width="7" height="7"></div>																		</td>
																		<td width="71%"><a href="Book_info.jsp?Bookid=<%=rs.getString("shuID")%>" target="_blank" >
																				<font color="#0066CC"><%=rs.getString("shu_name")%></font> </a>																	    </td>
																		<td width="17%">定价：<font color="#FF0000"><b>￥</b><%=rs.getString("dingjia")%></font>																	    </td>
																		<td width="10%"><a href="../shopcart/add.asp?lbbh=BB07977657" target="_blank">[<font color="#990000">购买</font>]</a>																	    </td>
																	</tr>
																	<tr>
																		<td bgcolor="#CCCCCC" height="1" colspan="4"></td>
																	</tr>
																</table>															</td>
														</tr>
														<%}
														}													
													%>
													</table>