📄 bookmanage.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<jsp:directive.page import="ss06.sl.pj3.DBUtil;"/>
<!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=UTF-8">
<link href="style.css" rel="stylesheet" type="text/css" />
<%
if(session.getAttribute("username") == null){
response.sendRedirect("index.jsp");
return;
}
if(!session.getAttribute("role").equals("admin")){
response.sendRedirect("userIndex.jsp");
return;
}
%>
<title>图书管理</title>
</head>
<body>
<body>
<%! int currentpage; %>
<%
if(request.getParameter("page") != null)
currentpage = Integer.parseInt(request.getParameter("page"));
else
currentpage = 0;
%>
<%!
public boolean isNextPage(int sum){
if(sum > 4)
return true;
else
return false;
}
%>
<table align="center" width="776" cellspacing="0">
<tr>
<td align="center"><a href="picture/title.jpg"><img src="picture/title.jpg" border="0" /></a></td>
<td align="left"><a href="picture/title2.jpg"><img src="picture/title2.jpg" border="0" /></a></td>
<td>
<div class="top1"><span><a href="#">设为首页</a></span></div>
<div class="top1"><span><a href="#">加入收藏</a></span></div>
<div class="top2"><span><a href="#">会员专区</a></span></div>
</td>
</tr>
</table>
<table cellspacing="0" width="776" align="center">
<tr>
<td class="td1">
<div id="newcard">
<a href="adminIndex.jsp"><img class="choose2" src="picture/user-n.bmp" /></a>
<img class="newdirect" src="picture/book-c.bmp" />
<a href="adminmessage.jsp"><img class="newdirect2" src="picture/self-n.bmp" /></a>
</div>
</td>
</tr>
<tr>
<td class="newtd4">
<span class="link_id"><a href="linksearch.jsp?name=Computer">计算机</a></span>
<span class="link_id"><a href="linksearch.jsp?name=Economics">经济学</a></span>
<span class="link_id"><a href="linksearch.jsp?name=ForeignLanguage">外语</a></span>
<span class="link_id"><a href="linksearch.jsp?name=Literature">文学</a></span>
</td>
</tr>
</table>
<table align="center" cellspacing="0" width="776">
<tr>
<td colspan="2" class="td3"><img src="picture/line.jpg" /></td>
</tr>
<tr>
<!--左边区域的大td-->
<td class="td5" width="174" valign="top">
<div class="div1">
<div><img src="picture/login.jpg" /></div>
<br>
<div align="center"><b><%= session.getAttribute("username") %></b> 您好!</div>
<div align="center">您的身份是:<b><%= session.getAttribute("role") %></b></div>
<br>
<div align="center"><a href="test.jsp">注销登录</a></div>
<br>
</div>
<div class="div1">
<div><img src="picture/booksearch.jpg" /></div>
<div class="div2">
<ul class="ul1">
<li><a href="linksearch.jsp?name=Computer">计算机</a></li>
</ul>
<div class="div4">
<table border="0" width="170">
<tr>
<td class="td6" width="70"><a href="likesearch.jsp?name=0">操作系统</a></td><td class="td6"><a href="likesearch.jsp?name=1">应用软件</a></td>
</tr>
<tr>
<td class="td6"><a href="likesearch.jsp?name=2">程序设计</a></td><td class="td6"><a href="likesearch.jsp?name=3">网络技术</a></td>
</tr>
</table>
</div>
</div>
<div class="div2">
<ul class="ul1">
<li><a href="linksearch.jsp?name=Economics">经济学</a></li>
</ul>
<div class="div4">
<table border="0" width="170">
<tr>
<td class="td6" width="70"><a href="likesearch.jsp?name=4">宏观经济学</a></td><td class="td6"><a href="likesearch.jsp?name=5">微观经济学</a></td>
</tr>
<tr>
<td class="td6"><a href="likesearch.jsp?name=6">经济学原理</a></td>
</tr>
</table>
</div>
</div>
<div class="div2">
<ul class="ul1">
<li><a href="linksearch.jsp?name=ForeignLanguage">外语</a></li>
</ul>
<div class="div4">
<table border="0" width="170">
<tr>
<td class="td6" width="70"><a href="likesearch.jsp?name=7">英语</a></td><td class="td6"><a href="likesearch.jsp?name=8">法语</a></td>
</tr>
<tr>
<td class="td6"><a href="likesearch.jsp?name=9">日语</a></td><td class="td6"><a href="likesearch.jsp?name=10">俄语</a></td>
</tr>
</table>
</div>
</div>
<div class="div2">
<ul class="ul1">
<li><a href="linksearch.jsp?name=Literature">文学</a></li>
</ul>
<div class="div4">
<table border="0" width="170">
<tr>
<td class="td6" width="70"><a href="likesearch.jsp?name=11">纪实文学</a></td><td class="td6"><a href="likesearch.jsp?name=12">现当代随笔</a></td>
</tr>
<tr>
<td class="td6"><a href="likesearch.jsp?name=13">中国古诗词</a></td><td class="td6"><a href="likesearch.jsp?name=14">现当代诗词</a></td>
</tr>
</table>
</div>
</div>
</div>
</td>
<td class="td4" valign="top" width="600">
<form action="search.jsp">
<select id="bookcategory" name="category">
<option value="Computer">计算机</option>
<option value="Economics">经济学</option>
<option value="ForeignLanguage">外语</option>
<option value="Literature">文学</option>
</select>
<input id="searchimg" type="image" src="picture/search.BMP">
<a href="newbook.jsp"><img style="{border-width:0px;}" src="picture/newbook.gif"></a>
</form>
<br>
<div align="center"><h3>图书列表</h3></div>
<table class="booktable" border="1" width="550" cellspacing="0" align="center">
<tr class="maintr">
<th align="left">封面图片</th>
<th align="left" width="50">ISBN</th>
<th align="left">图书名</th>
<th align="left">出版社</th>
<th align="left">类别</th>
<th align="left" width="30">售价</th>
<th align="left" width="60"> </th>
</tr>
<%
DBUtil dbutil = DBUtil.getInstance();
dbutil.connect2DB();
int start = currentpage * 4;
int restbook = dbutil.getAllBooks() - start;
int end;
if(isNextPage(restbook))
end = start + 4;
else
end = dbutil.ISBN.length;
for(int i = start; i < end; i++){
String pic = dbutil.pic[i];
String picroot = "picture/" + pic;
%>
<tr>
<td><img src=<%= picroot %>></td>
<td><%= dbutil.ISBN[i] %></td>
<td><%= dbutil.bookname[i] %></td>
<% if(!dbutil.bookpress[i].equals("")){ %>
<td><%= dbutil.bookpress[i] %></td>
<% }else{ %>
<td> </td>
<% } %>
<td><%= dbutil.category[i] %></td>
<td><%= dbutil.price[i] %></td>
<td><a href="adminbookdetail.jsp?name=<%= dbutil.ISBN[i] %>">点击进入</a></td>
</tr>
<%
}
%>
</table>
<div align="center">
<%
if(currentpage > 0){
%>
<a href="bookmanage.jsp?page=<%= currentpage - 1 %>">上一页</a>
<%
}else{
%>
上一页
<%
}
%>
<%
if(isNextPage(restbook)){
%>
<a href="bookmanage.jsp?page=<%= currentpage + 1 %>">下一页</a>
<%
}else{
%>
下一页
<%
}
%>
</div>
</td>
</tr>
</table>
<table align="center" width="776">
<tr>
<td id="last_td1" colspan="2" align="center">
<span class="list3"><a href="#">关于我们</a></span>
<span class="list3"><a href="#">联系我们</a></span>
<span class="list3"><a href="#">付款方式</a></span>
<span class="list4"><a href="#">客户反馈</a></span>
</td>
</tr>
<tr>
<td id="last_td2" colspan="2" align="center">
<div id="last_div">网上书店版权所有</div>
<div>Copyright ?2002 - 2004 NETSTAR CO,LTD. All Rights Reserved</div>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -