📄 booklist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="classlist" scope="page" class="leecong.javabean.BookClassList"/>
<jsp:useBean id="booklist" scope="page" class="leecong.javabean.BookList"/>
<%!
String admin="";
Enumeration listname=null;
Hashtable list=null;
int dipage=0;
String pages=null;
int countRecord=0;//记录条数
int countPageRecord=0;//每页记录条数
int countPage=0;//总页数
ResultSet rs=null;
int bookclass=0;
%>
<%
admin=(String)session.getAttribute("admin");
if (admin==null || admin.equals("")){
out.print("<script language='javascript'>alert('对不起，您还没有登陆，请先登陆!');</script>");
out.print("<script language='javascript'>location='login.jsp';</script>");
}
else
{
session.setAttribute("admin",admin);
}
if(!booklist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<%
//当前页码数默认为1
pages=request.getParameter("dipage");
if(pages==null)
{
pages="1";
}
try
{
dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
dipage=1;
}
%>
<%
if(request.getParameter("bookclass")==null)
{
rs=booklist.getBookList();
}
else
{
bookclass=Integer.parseInt(request.getParameter("bookclass"));
if(bookclass==0)
{
rs=booklist.getBookList();
}
else
{
rs=booklist.getBookList(bookclass);
}
}
countPageRecord=10;//每页8条记录
//得到记录的条数
try
{
rs.last();
countRecord=rs.getRow();
//得到总页数
if(countRecord/countPageRecord==0){
countPage=countRecord/countPageRecord;
}
else{
countPage=countRecord/countPageRecord+1;
}
//把记录指针移至当前页第一条记录之前
if((dipage-1)*countPageRecord==0){
rs.beforeFirst();
}
else{
rs.absolute((dipage-1)*countPageRecord);
}
}catch(Exception e){e.printStackTrace();}
%>
<html>
<head>
<title>LEE电子商务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function openScript(url,name, width, height){
window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
function checkform(){
if(document.form2.bookno.value=="")
{
alert("图书编号不能为空！");
form2.bookno.focus();
return false;
}
return true;
}
var msg=" 请使用IE5.5以上版本，800*600分辨率浏览 ";
var seq = 0;
function Scroll(){
window.status = msg.substring(msg.length,seq); seq++;
if (seq >= msg.length )
{ seq = 0 };
window.setTimeout("Scroll();", 300 );
}
</script>
<link rel="stylesheet" href="books.css" type="text/css">
<style type="text/css">
<!--
.style1 {
color: #996600;
font-weight: bold;
}
-->
</style>
</head>
<body text="#000000" onLoad="Scroll();">
<div align="center">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center" width="23%"><img src="../images/01247.jpg" width="96" height="114"></td>
<td align="center" width="77%"><img src="../images/baners.gif" width="512" height="80"></td>
</tr>
<tr>
<td align="center" width="23%" valign="top">
<table width="100%" border="0" cellspacing="4" cellpadding="2">
<tr>
<td align="center"><a href="main.jsp">管理首页</a></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td align="center"><a href="addbook.jsp">添加商品资料</a></td>
</tr>
<tr>
<td align="center"><a href="booklist.jsp?bookclass=0">商店商品查询</a><a href="orderlist.jsp"></a></td>
</tr>
<tr>
<td align="center"><a href="addbookclass.jsp">添加商品类别</a></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td align="center"><a href="login.jsp">退出</a></td>
</tr>
<%
if(!classlist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<tr>
<td align="center">
<form name="form1" method="post" action="booklist.jsp">
<select name="bookclass">
<%
if(classlist.classList()){
list=classlist.getClassList();
listname=list.keys();
while(listname.hasMoreElements()){
int ClassId=((Integer)listname.nextElement()).intValue();
String ClassName=(String)(list.get(new Integer(ClassId)));
%>
<option value="<%=ClassId%>"><%=ClassName%></option>
<%
}}
%>
</select>
<input type="submit" name="Submit" value="查询">
</form> </td>
</tr>
<tr>
<td align="center"><img src="../images/baobei[1].gif" width="120" height="60"></td>
</tr>
</table>
</td>
<td width="77%" valign="top">
<center><span class="style1"><font size="2">欢迎你登陆，LEE电子商务 商品管理员</font></span>...</center>
<form name="form2" action="showbook.jsp" method="post" onSubmit="return checkform();" target="_blank">
LEE 电子商务商品情况
图书编号：
<input type="text" name="bookno" size="20" maxlength="17">
<input type="submit" name="Submit2" value="查询">
</form>
<table width="98%" border="1" cellspacing="1" cellpadding="1" bordercolor="#336633">
<tr align="center">
<td width="22%">图书编号</td>
<td width="22%">图书名称</td>
<td width="16%">图书类别</td>
<td width="11%">总数量</td>
<td width="11%">销售量</td>
<td width="9%">详细</td>
<td width="9%">删除</td>
</tr>
<%
try{
int i=0;
while(rs.next())
{
%>
<tr>
<td><%=rs.getString(6)%></td>
<td><%=rs.getString(2)%></td>
<td align="center"><%=rs.getString(12)%></td>
<td align="center"><%=rs.getInt(9)%></td>
<td align="center"><%=rs.getInt(10)%></td>
<td align="center"><a href="javascript:openScript('showbook.jsp?bookno=<%=rs.getString(6)%>&bookid=<%=rs.getString(1)%>','showbooklist',600,500);">修改</a></td>
<td align="center">
<a href="deletebook?classid=<%=rs.getString(3)%>&bookid=<%=rs.getString(1)%>">删除</a>
</td>
</tr>
<%
i++;
if(i>=countPageRecord){
break; //当前页显示完，则退出循环
}
}
}catch(Exception ex){ex.printStackTrace();}
%>
</table><br>
<%
try{
if(dipage==1)//当前是首页
out.print("首页 上一页 ");
else//当前不是首页
{
out.print("<a href=booklist.jsp?dipage=1&bookclass="+bookclass+">首页 </a> ");
out.print("<a href=booklist.jsp?dipage="+(dipage-1)+"&bookclass="+bookclass+">上一页</a> ");
}
if(dipage==countPage || (dipage-1)==countPage)//当前是末页
out.print("下一页 末页 ");
else//当前不是末页
{
out.print("<a href=booklist.jsp?dipage="+(dipage+1)+"&bookclass="+bookclass+">下一页 </a> ");
out.print("<a href=booklist.jsp?dipage="+countPage+"&bookclass="+bookclass+">末页 </a> ");
}
}catch(Exception e2){e2.printStackTrace();}
%>
<br>
<%
out.print("共"+countRecord+"条记录,共"+countPage+"页，当前第"+dipage+"页，每页"+countPageRecord+"条记录");
%>
<p> </p> </td>
</tr>
</table>
<br>
<table width="70%" border="0" cellspacing="2" cellpadding="2" align="center">
<tr>
<td align="center">开发:LeeCong<br>
CopyRight@2006 <br>
Email:<a href="mailto:leecong@eyou.com">leecong@eyou.com</a></td>
</tr>
</table>
</div>
<%
classlist.close();
booklist.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -