这是订单完成页面
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>cxdd.jsp</title>
</head>
<body>
<% request.setCharacterEncoding("utf-8");
String upid="";
String name=request.getParameter("name");
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/jz?useSSL=false","root","root");
PreparedStatement pt=con.prepareStatement("select * from dd where name=?",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
pt.setString(1,name);
ResultSet rs=pt.executeQuery();
%>
<center><table border="1px">
<h3 class="panel-title text-center">您的订单</h3>
<br><tr><td>编号</td><td>账号</td><td>电话</td><td>地址</td><td>时间</td><td>类目</td><td>金额</td><td>备注</td><td>状态</td><td>操作</td></tr>
<% while(rs.next()){
upid=rs.getString(1);
%>
<tr><td><%=rs.getString(1) %></td><td><<%=rs.getString(2) %>"></td><td><<%=rs.getString(3) %>"></td><td><<%=rs.getString(4) %>"></td><td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td><td><%=rs.getString(7) %></td><td><%=rs.getString(8) %></td><td><%if(rs.getInt("zt")==0){out.print("未接单");}else{out.print("已接单");} %></td>
<td><a href="wc.jsp?upid=<%=upid%>">完成</a></td></tr>
<%}%>
</table></center>
<%
rs.close();
con.close();%>
</body>
</html>
这是执行订单完成页面
<%@ page language="java" import="java.util.*,java.sql.*,java.net.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'wc.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<% request.setCharacterEncoding("utf-8");
String a = request.getParameter("zt");
String i=request.getParameter("upid");
session.setAttribute("id",i);
Class.forName("com.mysql.jdbc.Driver");//加载驱动
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jz?useSSL=false","root","root");
PreparedStatement pStmt=conn.prepareStatement("select * from dd where id=?");
pStmt.setString(1, i);
ResultSet rs = pStmt.executeQuery();
PreparedStatement tmt = conn.prepareStatement("update dd set zt=3 WHERE id=?");
tmt.setString(1, i);
int rst=tmt.executeUpdate();
if (rst!= 0){
out.println("<script type='text/javascript'>alert('服务完成！');window.location.href='wcdd.jsp';</script>");
}
%>
</body>
</html>
```c
ResultSet rs=pt.executeQuery();
while(rs.next()){
String id=rs.getString("id");
String account=rs.getString("account");
String phone=rs.getString("phone");
String address=rs.getString("address");
String time=rs.getString("time");
String category=rs.getString("category");
out.println("<tr>");
out.println("<td>"+id+"</td>");
out.println("<td>"+account+"</
```