?? 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 + -