交易者可以查看到目前购买物品的订单情况:
<%
DataBaseHelper d = new DataBaseHelper();
ResultSet rs = d.query(“select * from orderindex where buyer=”+session.getAttribute(“id”));
while(rs.next()){
%>
<a href=“orders.jsp?orderid=<%=rs.getString(“orderid”)%>”><%=rs.getString(“orderid”) %>
<%if(rs.getString(“delivertype”).equals(“1”)) out.print(“平邮”);else out.println(“快递”);%>
<%if(rs.getString(“paytype”).equals(“1”)) out.print(“账户支付(已经支付)”);else out.println(“邮寄(未支付)”);%>
<a href=“CancelOrder?orderid=<%=rs.getString(“orderid”)%>” onClick=“return confirm(‘确定删除?’)”> 取消订单
<%} %>
运行结果:
交易者查看“交易成功的商品”可以查看到商品信息,点击购买用户的编号可以看到购买者的信息
![](https://img-blog.csdnimg.cn/20201225091046903.png#pic_center)