📄 goods_management.jsp
字号:
<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!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=gb2312">
<link rel=stylesheet type=text/css href="../lib/ware.css">
<title>欢迎光临网上商城</title>
<jsp:useBean scope="page" id="Ware" class="com.wssd.Ware" />
<jsp:useBean scope="page" id="User" class="com.wssd.User" />
<jsp:useBean scope="page" id="Goods" class="com.wssd.Goods" />
<jsp:useBean scope="page" id="pages" class="com.wssd.SplitPage" />
</head>
<% request.setCharacterEncoding("UTF-8");
//获取所有订单信息
ResultSet rs = Goods.show_all_goods();
//初始化分页显示类
pages.initialize(rs,5);
String strPage=null;
int showPage = 1;
//获取跳转到的目的页面
strPage=request.getParameter("showPage");
if (strPage==null)
{
showPage=1;
}
else
{
try
{
showPage=Integer.parseInt(strPage);
}
catch(NumberFormatException e)
{
showPage = 1;
}
if(showPage<1)
{
showPage=1;
}
if(showPage>pages.getPageCount())
{
showPage=pages.getPageCount();
}
}
//获取要显示的数据集合
Vector vData=pages.getPage(showPage);
%>
<body bgcolor="#F4FFFE">
<div align="center">
<form name="form1" action="delete_goods.jsp" method="post" target="_self">
<table width="95%" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066FF">
<td width="10%" height="20" align="center"><font color="#FFFFFF">选中</font></td>
<td width="10%" height="20" align="center"><font color="#FFFFFF">订单编号</font></td>
<td width="30%" height="20" align="center"><font color="#FFFFFF">商品名称</font></td>
<td width="15%" height="20" align="center"><font color="#FFFFFF">订购人</font></td>
<td width="15%" height="20" align="center"><font color="#FFFFFF">订购数量</font></td>
<td width="20%" height="20" align="center"><font color="#FFFFFF">订购时间</font></td>
</tr>
<%
//循环显示所有订单信息
for(int i=0;i<vData.size();i++)
{
//显示数据
String[] sData=(String[])vData.get(i);
long lUserID = Long.parseLong(sData[2]);
long lWareID = Long.parseLong(sData[3]);
User.setUserID(lUserID);
Ware.setWareID(lWareID);
if(User.init() && Ware.init())
{
%>
<tr>
<td width="10%" height="20" align="center"><input type="checkbox" name="DeleteID" value="<%=sData[0]%>"></td>
<td width="10%" height="20" align="center"> <%=sData[0]%></td>
<td width="30%" height="20" align="left"> <a href="../ware_detail.jsp?WareID=<%=Ware.getWareID()%>" target="_self"><font color="#0000FF"><%=Ware.getWareName()%></font></a></td>
<td width="15%" height="20" align="left"> <a href="user_detail.jsp?UserID=<%=User.getUserID()%>" target="_self"><font color="#0000FF"><%=User.getUserName()%></font></a></td>
<td width="10%" height="20" align="center"> <%=sData[1]%></td>
<td width="25%" height="20" align="left"> <%=sData[4]%></td>
</tr>
<%
}
}
%>
</table>
<p><a href="javascript:form1.submit()" target="_self"><font color="#0000FF">删除选中的订单信息</font></a></p>
</form>
<p>
<form action="goods_management.jsp" method="post" target="_self">
第<font color="#FF0000"><%=showPage%></font>页/共<font color=red><%=pages.getPageCount()%></font>页
<a href="goods_management.jsp?showPage=1" target="_self"><font color="#0000FF">[首页]</font></a>
<%
//判断"上一页"链接是否要显示
if(showPage > 1)
{
%>
<a href="goods_management.jsp?showPage=<%=showPage-1%>" target="_self"><font color="#0000FF">[上一页]</font> </a>
<%
}
else
{
%>
[上一页]
<%
}
//判断"下一页"链接是否要显示
if(showPage < pages.getPageCount())
{
%>
<a href="goods_management.jsp?showPage=<%=showPage+1%>" target="_self"><font color="#0000FF">[下一页]</font> </a>
<%
}
else
{
%>
[下一页]
<%
}
%>
<a href="goods_management.jsp?showPage=<%=pages.getPageCount()%>" target="_self"><font color="#0000FF">[尾页]</font> </a>
转到
<select name="showPage">
<%
for(int x=1;x<=pages.getPageCount();x++)
{
%>
<option value="<%=x%>" <%if(showPage==x) out.println("selected");%> ><%=x%></option>
<%
}
%>
</select>
页
<input type="submit" name="go" value="提交"/>
</form>
</p>
<%rs.close();%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -