📄 book_publish.jsp
字号:
<%@ page contentType="text/html;charset=gbk"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<LINK href="../images/style.css" type=text/css rel=stylesheet>
<title>出版社搜索</title>
<style type="text/css">
.style1 {
color: #4F7FC7
}
.STYLE2 {
font-size: 14px;
color: #020986;
}
.STYLE3 {
color: #E30072
}
</style>
</head>
<body>
<TABLE width=760 border=1 align="center"
style="BORDER-BOTTOM: #4f7fc7 3px solid; BORDER-COLLAPSE: collapse">
<jsp:include page="top_book.jsp" />
</table>
<%
String publish = request.getParameter("id");
%>
<table align="center" width="700" border="0" valign="top">
<tr>
<td align="center">
<font face="华文行楷" size="+3" color="#00CCFF"> 《<%
out.print(publish);
%>出版社》所出版图书
</font>
</td>
</tr>
</table>
<%
ResultSet rs = null;
int PageSize = 4;
int CurPage = 1;
int TotalPage = 0;
int total = 0;
String strsql = "select count(*) as recordcount from bookinfo where Publish like '"
+ publish + "%'";
rs = databean.executeQuery(strsql);
rs.next();
total = rs.getInt("recordcount");
if (total == 0) {
out
.print("<script language=\"JavaScript\">alert(\"对不起，位搜索到此类图书！\");location.href=\"../logindindex.jsp\"</script>");
}
if (total % PageSize == 0) {
TotalPage = total / PageSize;
} else {
TotalPage = (total / PageSize) + 1;
}
ResultSet rset = null;
if (request.getParameter("CurPage") != null) {
CurPage = Integer.parseInt(request.getParameter("CurPage"));
}
try {
String sql = "select * from bookinfo where Publish like '"
+ publish + "%'";
rset = databean.executeQuery(sql);
} catch (Exception e) {
out.println(e.toString());
}
%>
<TABLE align="center" valign="top"
style="BORDER-BOTTOM: #4f7fc7 1px solid; BORDER-COLLAPSE: collapse"
cellPadding=3 width="699" height="6">
<tr>
<td>
<%
out.println("<font color=\"#0066ff\">当前为第</font>" + CurPage
+ "<font color=\"#0066ff\">页</font>");
out.println("<font color=\"#0066ff\">共</font>" + TotalPage
+ "<font color=\"#0066ff\">页</font>");%>
</td>
</tr>
</TABLE>
<%
int count = 0;
int Start = (CurPage - 1) * PageSize;
if (Start != 0)
rset.absolute(Start);
while (rset.next()) {
String buy1 = null;
String id = rset.getString("BookNo");
String bookname=rset.getString("BookName");
String au=rset.getString("Author");
String pub=rset.getString("Publish");
String pic=rset.getString("Pictrue");
String content=rset.getString("Content");
%>
<TABLE align="center" valign="top"
style="BORDER-BOTTOM: #4f7fc7 3px solid; BORDER-COLLAPSE: collapse"
cellPadding=3 width="699" height="188">
<tr>
<td>
<img src="../upload/<%out.print(pic);%>" border=0>
</td>
<td>
<font color="#0066FF" face="华文行楷" size="+1">书名：</font>
<%
out.print(bookname);
%>
<br>
<font color="#0066FF" face="华文行楷" size="+1">作者：</font>
<%
out.print(au);
%>
<br>
<font color="#0066FF" face="华文行楷" size="+1">出版：</font>
<%
out.print(pub);
%>
<br>
<font color="#0066FF" face="华文行楷" size="+1">介绍：</font>
<%
out.print(content);
%>
<br>
<font color="#FF9999" face="华文行楷" size="+1">原价：</font>
<%
out.print(rset.getString("Price"));
%>
<font color="#FF0000" face="华文行楷" size="+1">半岛价：￥</font>
<%
out.print(rset.getString("SalePrice"));
%>
<div align="right">
<%
out.print("<a href='../shopping/look.jsp?buy1=" + id
+ "'>购买</a>");
%>
</div>
</td>
</tr>
<%
count++;
if (count == PageSize) {
break;
}
}
%>
</table>
<table width="700" align="center" bgcolor="#00CCFF" border="0"
valign="top">
<TR>
<TD align="center">
<%
if (CurPage > TotalPage) {
out
.print("<script language=\"JavaScript\">alert(\"已是末页！\");parent.window.location.href=\"book.jsp\"</script>");
} else {
if (CurPage == 1) {
if (CurPage == TotalPage) {
out.println("首页 上一页 下一页 尾页");
} else {
out.println("首页 上一页 <a href='bookinfo.jsp?CurPage="
+ (CurPage + 1)
+ "'>下一页</a> <a href='bookinfo.jsp?CurPage="
+ (TotalPage) + "'>尾页</a>");
}
} else {
if (CurPage == TotalPage) {
out
.println(" <a href='computer.jsp?CurPage=1'>首页</a> <a href='bookinfo.jsp?CurPage="
+ (CurPage - 1)
+ "'>上一页</a> <a href='bookinfo.jsp?CurPage="
+ (CurPage + 1)
+ "'>下一页</a> <a href='bookinfo.jsp?CurPage="
+ (TotalPage) + "'>尾页</a>");
} else {
out
.println(" <a href='computer.jsp?CurPage=1'>首页</a> <a href='bookinfo.jsp?CurPage="
+ (CurPage - 1)
+ "'>上一页</a> <a href='bookinfo.jsp?CurPage="
+ (CurPage + 1)
+ "'>下一页</a> <a href='bookinfo.jsp?CurPage="
+ (TotalPage) + "'>尾页</a>");
}
}
}
out.print(" 跳转到第 ");
out.println("<select size=1 onChange=\"gotoPage(this.value)\">");
for (int i = 1; i <= TotalPage; i++) {
String selectAdd = (i == CurPage) ? " selected" : "";
out.println("<option value='" + i + "' " + selectAdd + "> " + i
+ " </option>");
}
out.println("<select>");
out.print("页");
%>
<input type="button" value="返回"
onclick="javascript:location.href='../logindindex.jsp';">
</TD>
</TR>
</TABLE>
<script>
function gotoPage(topage){
location.href="book_publish.jsp?CurPage="+topage+"&id=<%=publish%>";
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -