📄 detailorder.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:useBean id="cart" class="cart.Cart" scope="session"/>
<html>
<link rel="stylesheet" type="text/css" href="style.css"/>
<body background="images/bg01.gif">
<p><center>
<table width="50%" cellpadding="3" cellspacing="0" border bordercolor="blue" bordercolorlight="#FFFFFF">
<tr>
<th colspan="2" align="center" background="images/bg04.gif" height="26">查看订单详细信息</th>
<tr>
<td colspan="2">您购买的书籍如下：
<ol>
<%
ResultSet rs=null;
String sql="";
String detailid="";
String userid="";
String username="";
String bookid="";
String orderdate="";
String orderstate="";
float sum=0.0f;
String logid=(String)session.getAttribute("id");
String rank=(String)session.getAttribute("rank");
if(request.getParameter("detailid")!=null)
detailid=request.getParameter("detailid");
sql="select * from orderinfo where orderid='"+detailid+"'";
rs=conn.executeQuery(sql);
if(rs.next())
{
userid=rs.getString("userid");
username=rs.getString("username");
bookid=rs.getString("bookid");
orderdate=(rs.getString("orderdate")).substring(0,10);
orderstate=rs.getString("orderstate");
}
rs.close();
if(rank.equals("0")&&!userid.equals(logid))
response.sendRedirect("error.jsp");
int len=0;
for(int i=0;i<bookid.length();i++)
{
if(bookid.charAt(i)==',')
len++;
}
String[] bid=new String[len];
for(int i=0;i<bid.length;i++)
bid[i]="";
int j=0;
for(int i=0;i<bookid.length();i++)
{
if(bookid.charAt(i)!=',')
bid[j]+=bookid.substring(i,i+1);
else
j++;
}
sum=0.0f;
for(int i=0;i<bid.length;i++)
{
sql="select * from book where bookid="+bid[i];
rs=conn.executeQuery(sql);
if(rs.next())
{
float p=rs.getFloat("price");
out.println("<li>"+rs.getString("bookname"));
out.println("["+rs.getString("author")+"]");
out.println(" "+rs.getString("pubhouse"));
out.println(" "+p+" 元");
sum+=p;
}
}
%>
</ol></td>
<tr align="center">
<td>共计金额</td>
<td><%=sum%> 元</td>
<tr align="center">
<td width="20%">订单号</td>
<td><%=detailid%></td>
<tr align="center">
<td>下单日期</td>
<td><%=orderdate%></td>
<tr align="center">
<td>订单状态</td>
<td><%=orderstate%></td>
<tr align="center">
<td colspan="2">
<%
String newstate="已交货";
if(rank.equals("1"))
{
if(orderstate.equals("已交货"))
newstate="未交货";
%>
要将订单状态更改为“<%=newstate%>”吗？
<a href="dealupdateorder.jsp?orderid=<%=detailid%>">确认</a>
<%
}
%>
<a href="listorder.jsp">返回</a>
</td>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -