📄 orderlist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" errorPage="" %>
<%@ page import="barbershop.database.*"%>
<%@ page import="barbershop.*" %>
<html>
<head>
<title>main_03</title>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
if(session.getAttribute("admin")==null)
{
response.sendRedirect("adminLogin.jsp");
}
else
{
%>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" background="images/right.gif" width="709" height="992">
<tr><td height="80"><div align="center"><h1>预约订单管理</h1></div></td></tr>
<tr><td height="100">
<div align="center">
<table border="1">
<tr><td>订单编号</td><td>会员用户名</td><td>发型ID</td><td>理发师ID</td><td>订单价格</td><td>订单时间</td><td colspan="2">状态</td></tr>
<%
DBSQLManager dbsm = new DBSQLManager();
String sql="select * from tb_order";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
while(rs.next())
{
String orderID = rs.getString("ORDER_ID");
String vipUser = rs.getString("VIP_USER");
String hairID = rs.getString("HAIR_ID");
String barberID = rs.getString("BARBER_ID");
String orderPrice = rs.getString("ORDER_PRICE");
String orderDate = rs.getString("ORDER_DATE");
String doFlag = rs.getString("DO_FLAG");
%>
<tr>
<td><%=orderID%></td>
<td><%=vipUser%></td>
<td><%=hairID%></td>
<td><%=barberID%></td>
<td><%=orderPrice%></td>
<td><%=orderDate%></td>
<%
if(doFlag.equals("0"))
{
%>
<td>未执行</td><td><a href="doOrder.jsp?orderID=<%=orderID %>" onClick="return confirm('确定要设定为已执行吗?');">设为已执行</a></td>
<%
}
else
{
%>
<td>已执行</td>
<td><a href="delorder.jsp?orderID=<%=orderID %>" onClick="return confirm('确认要删除这条记录吗?');">删除</a></td>
<%
}
%>
</tr>
<%
}
%>
</table>
</div>
</td></tr>
<tr><td></td></tr>
</table>
</div>
<%} %>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -