📄 booklist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*"%>
<%@ page import="com.bookshop.bean.*"%>
<%@ page session="true"%>
<%@ page import="com.bookshop.bean.BookClass"%>
<jsp:useBean id="book" scope="page" class="com.bookshop.bean.Books" />
<jsp:useBean id="book_list" scope="page" class="com.bookshop.dao.Booksmn" />
<jsp:useBean id="classlist" scope="page"
class="com.bookshop.dao.BookclassList" />
<%
int pages = 1;
String mesg = "";
if (request.getParameter("page") != null
&& !request.getParameter("page").equals(""))
{
String requestpage = request.getParameter("page");
try
{
pages = Integer.parseInt(requestpage);
} catch (Exception e)
{
mesg = "你要找的页码错误!";
}
book_list.setPage(pages);
}
String classid = request.getParameter("classid");
String classname = "";
String keyword = request.getParameter("keyword");
if (classid == null)
classid = "";
if (keyword == null)
keyword = "";
keyword = book_list.getGbk(keyword);
%>
<html>
<head>
<title>51网上书店 选购图书</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>a{TEXT-DECORATION:none}a:hover{TEXT-DECORATION:underline}</style>
<script language="JavaScript">
setInterval("a.innerHTML=new Date().toLocaleString()+' 星期'+'日一二三四五六'.charAt(new Date().getDay());",1000);
</script>
<script language="javascript">
function openScript(url,name, width, height)
{
var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script>
<link rel="stylesheet" href="books.css" type="text/css">
<style type="text/css">
<!--
.style2 {color: #000000}
.style14 {color: #3366FF}
.style16 {font-size: 18px; color: #3366FF;}
-->
</style>
</head>
<body text="#000000">
<div align="center">
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><img src="images/title.jpg" width="750" height="100"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="1" cellpadding="1" >
<tr>
<td width="100" height="30" align="center" background="images/qntj.jpg"><a href="index.jsp" class="style14">首页</a></td>
<td width="100" align="center" background="images/qntj.jpg"><a href="booklist.jsp" class="style14">在线购物</a></td>
<td width="100" align="center" background="images/qntj.jpg"><a href="shoperlist.jsp" class="style14">我的购物车</a></td>
<td width="100" align="center" background="images/qntj.jpg"><a href="login.jsp" class="style14">用户登录</a></td>
<td width="100" align="center" background="images/qntj.jpg"><a href="manage/login.jsp" class="style14">网站管理</a></td>
<td width="250" align="center" background="images/qntj.jpg"><div id="a"><span class="style7"></span></div></td>
</tr>
</table>
<table width="750" height="414" border="0" cellpadding="0" cellspacing="0" bordercolor="#33CCFF">
<tr valign="top">
<td width="150" height="412">
<table width="150" class="style17" height="67" border="0" cellpadding="1" cellspacing="1" align="center">
<tr align="center">
<td width="123" height="44" background="images/qntj.jpg" align="center">
<span class="style16">本店图书分类</span>
</td>
</tr>
<%
if (classlist.excute())
{
for (int i = 0; i < classlist.getClasslist().size(); i++)
{
BookClass bc = (BookClass) classlist.getClasslist().elementAt(i);
%>
<tr>
<td height="20" align="center" background="images/qntj.jpg">
<a href="booklist.jsp?classid=<%=bc.getId()%>"><%=bc.getClassName()%>
</a>
</td>
</tr>
<%
}
}
%>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<form name=form1 method=POST action="booklist.jsp">
<tr>
<td height="28" align=center background="images/qntj.jpg">
<span class="style16">图书查询</span>
</td>
</tr>
<tr>
<td height="35">
<span class="style14">关键字 </span>
<input type="text" name="keyword" size="12" maxlength="40" value="<%=keyword%>">
</td>
</tr>
<tr>
<td height="36">
<span class="style14">类 别</span>
<SELECT NAME="classid">
<option value="">
所有类别
</option>
<%
for (int i = 0; i < classlist.getClasslist().size(); i++)
{
BookClass bc = (BookClass) classlist.getClasslist()
.elementAt(i);
%>
<option value="<%=bc.getId()%>">
<%=bc.getClassName()%>
</option>
<%
}
%>
</SELECT>
</td>
</tr>
<tr>
<td height="35" align="center">
<INPUT TYPE="submit" name="submit" value="查询">
</td>
</tr>
</table>
</td>
<td align="center">
<p>
<br>
<b class="style16"><font color="#0000FF">图书<%=classname%>列表</font> </b>
</p>
<%
if (!keyword.equals(""))
out.println("<p ><font color=#ff0000>你要查找关于 " + keyword
+ " 的图书如下</font></p>");
%>
<table width="100%" border="1" cellspacing="0" cellpadding="0"
bordercolor="#00CCFe">
<tr align="center" class="style14">
<td height="36">
图书名称
</td>
<td>
作者
</td>
<td>
图书类别
</td>
<td>
出版社
</td>
<td>
单价
</td>
<td width=110>
选择
</td>
</tr>
<%
if (book_list.execute(request))
{
if (book_list.getBooklist().size() > 0)
{
for (int i = 0; i < book_list.getBooklist().size(); i++)
{
Books bk = (Books) book_list.getBooklist().elementAt(i);
%>
<tr>
<td height="39">
<%=bk.getBookName()%>
</td>
<td align="center">
<%=bk.getAuthor()%>
</td>
<td align="center">
<%=bk.getClassname()%>
</td>
<td align="center">
<%=bk.getPublish()%>
</td>
<td align="center">
<%=bk.getPrince()%>
元
</td>
<td align="center">
<a href="#" onclick="openScript('purchase.jsp?bookid=<%=bk.getId()%>','pur',300,250)">购买</a>
<a href="#" onclick="openScript('showbook.jsp?bookid=<%=bk.getId()%>','show',400,450)">详细资料</a>
</td>
</tr>
<%
}
} else
{
if (keyword.equals(""))
{
out
.println("<tr><td align='center' colspan=6> 暂时没有此类图书资料</td></tr>");
} else
{
out
.println("<tr><td align='center' colspan=6> 没有你要查找的 "
+ keyword + " 相关图书</td></tr>");
}
}
} else
{
%>
<tr>
<td height="41" colspan=6 align="center">
数据库出错，请稍后
</td>
</tr>
<%
}
%>
</table>
<table width="93%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td height="34" align="right">
总计结果为
<%=book_list.getRecordCount()%>
条，当前页第
<%=book_list.getPage()%>
页
<a
href="booklist.jsp?classid=<%=classid%>&keyword=<%=keyword%>">首页</a>
<%
if (book_list.getPage() > 1)
{
%>
<a
href="booklist.jsp?page=<%=book_list.getPage() - 1%>&classid=<%=classid%>&keyword=<%=keyword%>">上一页</a>
<%
}
%>
<%
if (book_list.getPage() < book_list.getPageCount() - 1)
{
%>
<a
href="booklist.jsp?page=<%=book_list.getPage() + 1%>&classid=<%=classid%>&keyword=<%=keyword%>">下一页</a>
<%
}
%>
<a
href="booklist.jsp?page=<%=book_list.getPageCount()%>&classid=<%=classid%>&keyword=<%=keyword%>">未页</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
<hr width="750" color="#00CCFe"/>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" >
<div align="center" class="style11">06计算机科学与技术3班
<br>
CopyRight@2009<br>
E-mail: Jinlf112@163.com<a href="http://mail.163.com"></a>
</div></td>
</tr>
</table>
</div>
</body>
</html>
<%
book_list.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -