📄 bookinfo.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
}
</style>
</head>
<body>
<%
String sort = request.getParameter("id");
if (sort == null) {
sort = "jsj";
}
ResultSet rs1 = null;
String strsql1 = "select * from booksort where ID='" + sort + "'";
rs1 = databean.executeQuery(strsql1);
while (rs1.next()) {
String sortname = rs1.getString("SortName");
%>
<table align="center" border="0">
<tr>
<td align="center">
<font face="华文行楷" size="+3" color="#00CCFF"> <%
out.print(sortname);
}
%>图书
</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 ID='"
+ sort + "'";
rs = databean.executeQuery(strsql);
rs.next();
total = rs.getInt("recordcount");
if (total == 0) {
out
.print("<script language=\"JavaScript\">alert(\"对不起，还未添加此类图书！\");parent.window.location.href=\"book.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 ID='" + sort + "'";
rset = databean.executeQuery(sql);
} catch (Exception e) {
out.println(e.toString());
}
out.println("<font color=\"#0066ff\">当前为第</font>" + CurPage
+ "<font color=\"#0066ff\">页</font>");
out.println("<font color=\"#0066ff\">共</font>" + TotalPage
+ "<font color=\"#0066ff\">页</font>");
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"
style="BORDER-BOTTOM: #4f7fc7 3px solid; BORDER-COLLAPSE: collapse"
cellPadding=3 width="600" height="188">
<tr>
<td width="188">
<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='bookinfo.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='bookinfo.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("页");
%>
<script>
function gotoPage(topage){
location.href="bookinfo.jsp?CurPage="+topage+"&id=<%=sort%>";
}
</script>
</TD>
</TR>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -