这是点完成可以获取订单的id的页面
<%@ 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>
<base href="<%=basePath%>">
<title>My JSP 'pc2.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">
</head>
<body>
<% request.setCharacterEncoding("utf-8");
String pcid="";
String title=request.getParameter("title");
Class.forName("com.mysql.jdbc.Driver"); //加载驱动程序类
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jz?useSSL=false","root","root");
Statement pstmt=conn.createStatement();
ResultSet rs=pstmt.executeQuery("select * from dd where zt=1 ");%>
<center> <table border="1px"> <br>
<span><button style="float:right"><a href="pc1.jsp">查看</a></button></span>
<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()){
pcid=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="sc.jsp?pcid=<%=pcid%>">完成</a></td> </tr>
<%}%>
</table></center>
<%
rs.close();
conn.close();
%>
</body>
</html>
这是sc.jsp
<body>
<% request.setCharacterEncoding("utf-8");
String pcid="";
%>
<FORM METHOD="post" ACTION="sc1.jsp">
商 品 图片：<INPUT TYPE="file" NAME="image">
<INPUT TYPE="submit" value="提交"></form>
<% session.setAt
```java
这是后台操作页面连接数据库添加记录到表
<body>
<%
request.setCharacterEncoding("utf-8");
String id=request.getParameter("id");
String i=(String)session.getAttribute("pcid");
String filename=request.getParameter("image");
FileInputStream str= new FileInputStream(filename);
Class.forName("com.mysql.jdbc.Driver"); //加载驱动程序类
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/jz?useSSL=false","root","root");
PreparedStatement pstmt=con.prepareStatement("insert into pc values(?,?,?)");
pstmt.setString(1,id);
pstmt.setString(2,i);
pstmt.setBinaryStream(3,str,str.available());
int a=pstmt.executeUpdate();
//将数据存入数据库
if(a!=0){
request.getRequestDispatcher("pc1.jsp?title="+id+"").forward(request,response);
}
%>
</body>
</html>
