📄 book_type.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,bean.DBClass" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新书</title>
<link href="source/bookshop.css" rel="stylesheet" type="text/css">
<jsp:include page="/utility/scriptFunction.jsp" />
</head>
<body>
<%
String query="SELECT top 10 * FROM book WHERE ifNew = 'yes'";
DBClass db=new DBClass();
db.connect();
ResultSet resultset=db.executeQuery(query);
String name = "";
String type = "";
String author = "";
String publisher = "";
String price = "";
String pic = "";
String bookId = "";
String commentURL = "";
String cartURL = "";
%>
<div id="masthead">
<jsp:include page="/utility/siteName.jsp" />
<jsp:include page="/utility/navigation.jsp" />
</div>
<div id="pagecell1">
<div id="breadCrumb">
<table width="100%" border="0">
<tr>
<% String requestURL= request.getRequestURI();
String param=request.getQueryString();
String hidAddr="/bookshop/MenuHidden?jspURL=" + requestURL +"¶m="+ param ;
String showAddr="/bookshop/MenuShow?jspURL=" + requestURL +"¶m="+ param ; %>
<td width="211"><a href=<%= hidAddr %> align="left">隐藏</a> / <a href=<%= showAddr %>>显示</a> </td>
<td width="516"><div align="right"><a href="/bookshop/userLogin.jsp"align="right">登陆</a> | <a href="/bookshop/userRegister.jsp">新用户注册</a> | <a href="/bookshop/adminLogin.jsp">管理员入口</a></div></td>
</tr>
</table>
</div>
<table width="100%" border="0">
<tr valign="top">
<% if(session.getAttribute("hidden")==null){ %>
<jsp:include page="/utility/menu.jsp" />
<% } %>
<td width="81%" >
<div class="book">
<div align="center">
<table width="376" border="0" bordercolor="#FFFFFF">
<%
while (resultset.next()) {
bookId = resultset.getString("id");
name=resultset.getString("name");
type=resultset.getString("type");
author=resultset.getString("author");
publisher=resultset.getString("publisher");
price=resultset.getString("price");
pic="source/"+bookId+".JPG";
commentURL="/bookshop/bookComment.jsp?bookId="+bookId;
cartURL="/bookshop/addCart.jsp?bookId="+bookId;
%>
<tr>
<td height="103" colspan="2"><a href="#" onClick="window.open('<%= commentURL %>','s','width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes');"><img border="0" src=<%= pic %> width="270" height="350" align="baseline"> </a> <P class=style10>书名：<%= name%></P> <P class=style10>类别：<%= type%></P> <P class=style10>作者：<%= author%></P> <P class=style10>出版社：<%= publisher%></P> <P class=style10>价格：<%= price%></P>
<p><a href="#" onClick="window.open('<%= cartURL %>','s','width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes');"><img src="source/cart.gif" width="130" height="25" border="0"></a></p>
<hr></td>
<%
if (resultset.next()) {
bookId = resultset.getString("id");
name=resultset.getString("name");
type=resultset.getString("type");
author=resultset.getString("author");
publisher=resultset.getString("publisher");
price=resultset.getString("price");
pic="source/"+bookId+".JPG";
commentURL="/bookshop/bookComment.jsp?bookId="+bookId;
cartURL="/bookshop/addCart.jsp?bookId="+bookId;
%>
<td height="103" colspan="2"><a href="#" onClick="window.open('<%= commentURL %>','s','width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes');"><img border="0" src=<%= pic %> width="270" height="350" align="baseline"> </a> <P class=style10>书名：<%= name%></P> <P class=style10>类别：<%= type%></P> <P class=style10>作者：<%= author%></P> <P class=style10>出版社：<%= publisher%></P> <P class=style10>价格：<%= price%></P>
<p><a href="#" onClick="window.open('<%= cartURL %>','s','width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes');"><img src="source/cart.gif" width="130" height="25" border="0"></a></p>
<hr></td>
<% } else { %>
<td> </td> <% } %>
</tr>
<%
resultset.next();
}
%>
<%
db.closeConnection();
%>
<tr>
<td height="17" colspan="2"></td><td height="17" colspan="2"></td>
</tr>
</table>
</div>
</div>
<div>
<jsp:include page="/utility/copyRight.jsp" />
</div>
<br>
<jsp:include page="/utility/scriptMenuitem.jsp" />
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -