⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 book_info.jsp

📁 JSP课件以及一个网上书店系统程序,带数据库
💻 JSP
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
		<title>图书详细信息</title>
		<link href="style1.css" rel="stylesheet" type="text/css" />
	</head>
<body><%@ include file="inc/format.jsp"%>
		<%@ include file="inc/conn.jsp"%>
		<!--首页上部分-->
		<%@ include file="index_Top.jsp"%> <!--用户登录表单开始-->
		<table width="900" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table1">
			<tr>
				<td height="50" align="right">
					<iframe border="0" name="main_trg" marginWidth="0" marginHeight="0" src="mem_Login.jsp"						frameBorder="0" width="900" height="45" >浏览器不支持嵌入式框架,或被配置为不显示嵌入式框架。</iframe>
				</td>
			</tr>
		</table>
		<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table2">
			<tr>
				<td height="1" bgcolor="#DFE1E7"></td>
			</tr>
		</table>
		<br /><%@ include file="book_form.jsp"%>
		<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table5">
					<tr>
						<td height="28">
							所在位置:<font color="#003399"> <a href="Book_Leis.jsp?Cateid=1" target="_blank">软件与程序设计</a>
								-&gt; <a href="Book_Leis.jsp?Cateid=17" target="_blank">JAVA</a></font>					    </td>
					</tr>
					<tr>
						<td>
						<%
						String Bookid=request.getParameter("Bookid");
						stmt.executeUpdate("update tushumingxi set hits=hits+1 where shuID="+Bookid);
						sql="select * from tushumingxi where shuID="+Bookid;
						ResultSet rs1=dbBean.exeSQL(sql);
						while(rs1.next()){
						//String bookis=rs.getString("shuID");
						//String bookname=rs.getString("shu_name");
						//String lie=rs.getString("lieID");
						//String commend=rs.getString("commend");
						String bookname=dbBean.getString(rs1,"shu_name");
						String commend=dbBean.getString(rs1,"commend");
						%>						
						<table width="100%" border="0" cellspacing="0" cellpadding="0" ID="Table6">
								<tr>
									<td width="25%" valign="top"><table width="220" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table7">
											<tr>
												<td>
												<table width="170" border="0" align="center" cellpadding="0" cellspacing="3" bgcolor="#CCCCCC"						ID="Table8">
														<tr>
															<td height="240" bgcolor="#FFFFFF"><div align="center">
<img src="<%=dbBean.getString(rs1,"fengmian")%>" width="170" height="240" border="0">
																</div>															</td>
														</tr>
													</table>												</td>
											</tr>
											<tr>
												<td valign="middle">
													<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table9">
														<tr>
															<td height="3" valign="middle"></td>
														</tr>
												    </table>												</td>
											</tr>
											<tr>
												<td>
												<table width="168" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table10">
														<tr>
															<td><img src="pic/hc_info_02.gif" width="168" height="7"></td>
														</tr>
														<tr>
															<td background="pic/hc_info_03.gif">
															<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table11">
																	<tr>
																		<td width="13%" height="22"><div align="center"><img src="pic/publish6.gif" width="7" height="7"></div>																		</td>
																		<td width="87%">定 价:¥<%=rs1.getString("dingjia")%></td>
																	</tr>
																	<tr>
																		<td height="1" bgcolor="#C6D7DE"></td>
																		<td bgcolor="#C6D7DE"></td>
																	</tr>
																	<tr>
																		<td height="22"><div align="center"><img src="pic/publish6.gif" width="7" height="7"></div>																		</td>
																		<td>会 员:<font color="#990000">¥</font><font color="#FF0000"><%=rs1.getString("huiyuanjia")%></font></td>
																	</tr>
																	<tr>
																		<td height="1" bgcolor="#C6D7DE"></td>
																		<td bgcolor="#C6D7DE"></td>
																	</tr>
																</table>															</td>
														</tr>
														<tr>
															<td><img src="pic/hc_info_07.gif" width="168" height="7"></td>
														</tr>
													</table>												</td>
											</tr>
										</table>
										<table height="70" border="0" align="center" cellpadding="0" cellspacing="1" ID="Table12">
											<tr>
												<td height="36"><a href="../hcjg/index.asp" target="_blank"><img src="ad/aspnet.gif" width="180" height="60" border="0"></a></td>
											</tr>
									    </table>
										<table border="0" align="center" cellpadding="0"
												ID="Table13">
											<tr>
											  <td bgcolor="#FFFFFF">		<!--显示系统的最新新闻动态-->
					<%@ include file="news_Dynamic.jsp"%>											</td>
											</tr>
								      </table>
										<br>
										<table width="220" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#B7B7B7"
												ID="Table19">
											<tr>
												<td bgcolor="#FFFFFF">	<%@ include file="New_BooksRec.jsp"%>											</td>
											</tr>
								      </table>									</td>
									<td width="67%" valign="top">
									<table width="100%" border="0" cellspacing="0" cellpadding="0" ID="Table27">
											<tr>
												<td width="9%"><img src="pic/hc_info_01.gif" width="62" height="28"></td>
											  <td width="91%">
											  <strong> <font color="#990000">《 
												<%=bookname%> 》</font></strong> 
												<%if(commend.equals("1")){%>	[ <font color="#FF0000">推荐</font> ]<%}%>												</td>
											</tr>
											<tr>
												<td height="4" colspan="2"></td>
											</tr>
											<tr>
												<td height="1" colspan="2" bgcolor="#E7DFD6"></td>
											</tr>
											<tr>
												<td height="2" colspan="2"></td>
											</tr>
											<tr>
												<td height="8" colspan="2"></td>
											</tr>
											<tr>
												<td colspan="2"><table width="95%" border="0" align="center" cellpadding="4" cellspacing="0" ID="Table28">
														<tr>
															<td width="49%" valign="top">
															<table width="100%" border="0" cellspacing="0" cellpadding="3" ID="Table29">
																	<tr>
																		<td height="20"><font color="#FF6600">出版社:
																		<font color="#CC0000"><%=dbBean.getString(rs1,"banshe")%></font></font></td>
																	</tr>
																	<tr>
																		<td height="20"><font color="#FF6600">系列名:<font color="#CC0000"></font><%=dbBean.getString(rs1,"shu_xm")%></font></td>
																	</tr>
																	<tr>
																		<td height="20"><font color="#FF6600">作 者:</font>
																						<%=dbBean.getString(rs1,"zhuozhe")%>
																							    等</a>/								</td>
																	</tr>
																	<tr>
																		<td height="20"><font color="#FF6600">浏览次数:</font><%=dbBean.getString(rs1,"hits")%>次</td>
																	</tr>
																	<tr>
																		<td height="20"><font color="#FF6600">出版日期:</font><%=dbBean.getString(rs1,"date")%></td>
																	</tr>
																	
																</table>															</td>
															<td width="51%" valign="bottom"><table width="100%" border="0" cellspacing="0" cellpadding="3" ID="Table31">						
																	<tr>
																		<td><font color="#FF6600">综合评价:</font> 
																		<%
							String sqla="select count(book_id) as books from comment where book_id="+request.getParameter("Bookid");
							ResultSet rsa=dbBean.exeSQL(sqla);
							String cmts="0";
							while(rsa.next()){cmts=rsa.getString("books");}
							rsa.close();
							if(Cint(cmts)>0){							%>
							<a href='ShowMoreComment.asp?Newsid='><font color="#000000">评论共<font color="#ff0000"><%=cmts%></font>条</font></a>
							<%}else{%>
																		
																		暂无评价 &nbsp;&nbsp;<a href="../shuping/shuping_list.asp?lbbh=10008936" target="_blank"><u><font color="#000000">(<font color="#FF0000">0</font>)条评论</font></u></a>			<%}%>																		   </td>
																	</tr>
																	
																	<tr>
																		<td height="20"><font color="#FF6600">条形码 :</font>ISBN<%=dbBean.getString(rs1,"ISBN")%> </td>
																	</tr>
																	
																	<tr>
																		<td height="20"><font color="#FF6600">印数 :</font>1-5000 <font color="#FF6600">页数:</font><%=dbBean.getString(rs1,"yeshu")%></td>
																	</tr>
																	<tr>
																		<td height="20"><font color="#FF6600">开 本:</font><%=dbBean.getString(rs1,"kaiben")%></td>
																	</tr>
																</table>															</td>
														</tr>
													</table>												</td>
											</tr>
											<tr>
												<td colspan="2"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table32">
														<tr>
															<td>
																<div align="center">
																	<a href="../shopcart/add.asp?lbbh=10008936" target="_blank"><img src="pic/cart8.gif" width="115" height="36" border="0"></a></div>															</td>
															<td width="100" valign="bottom"><a href="../2003/tuangou.htm" target="_blank"></a></td>
															<td width="110" valign="bottom"><a href="#" onClick='AddToMyBook("mybookproc.asp?lbbh=10008936")'><img src="pic/hc_info_06.gif" width="89" height="19" border="0"></a></td>
															<td width="110" valign="bottom">
																<a href="../bbs/announce_qh.asp?boardid=5&lbbh=10008936&book_qh=0" target="_blank"><img src="pic/queshu.gif" width="25" height="23" border="0">
																	缺货登记</a>														    </td>
															<td width="10"></td>
														</tr>
													</table>												</td>
											</tr>
											
											
										</table>
										<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" ID="Table39">
											<tr>
												<td height="4"></td>
											</tr>
											<tr>
												<td>											    </td>
											</tr>
											<tr>
												<td>
													<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table40">
														<tr>
															<td><img src="pic/indexnew_12.gif" height="13" width="68"></td>
														</tr>																												<tr>
															<td  height="1" bgcolor="#E7DFD6">															
															</td>
														</tr>
												
												    </table>												</td>
											</tr>
											<tr>
												<td>
													<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center" class="s"
															ID="Table41">
														<tr>
															<td>
																&nbsp;&nbsp;&nbsp;&nbsp;	<%=dbBean.getString(rs1,"shu_jian")%>														</td>
														</tr>
												    </table>												</td>
											</tr>
											<tr>
												<td><%@ include file="rel_Books.jsp"%></td>
											</tr>
											<tr>
												<td>
													<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" background="pic/body_line1.jpg"
															ID="Table54">
														<tr>
															<td height="37" align="left" valign="middle">&nbsp;&nbsp; 图书目录															</td>
														</tr>
														<tr>
															<td valign="middle">
																<table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC" bgcolor="#FFFFFF"
																		ID="Table55">
																	<tr>
																		<td>
							<textarea name="textarea" cols="80" rows="20" wrap="physical" ID="Textarea1">	
								<%=dbBean.getString(rs1,"shu_mu")%>	
								</textarea>																	    </td>
																	</tr>
															    </table>															</td>
														</tr>
											      </table>												</td>
											</tr>
											<tr>
												<td>											    </td>
											</tr>
									    </table>	
										<%@ include file="CommentForm.jsp"%>
																					</td>
								</tr>
							</table>	
							<%}%>
												</td>
					</tr>
	</table>
		<%@ include file="index_Endb.jsp"%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -