orders_edit.jsp

来自「此小软件实现了小型超市的进销存系统,它展示了小型超市的进货和销售,还有库存的各种」· JSP 代码 · 共 27 行

<%@ page contentType="text/html; charset=gb2312"  errorPage="" %>
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<%@ page import="java.sql.*" %>
<%
if (session.getAttribute("name") == null) {
    response.sendRedirect("index.jsp");
  }else {

  String orderid =request.getParameter("orderid");

  Connection con=DBConn.GetConn();

  Statement st=con.createStatement();
  String sql="Update  Order_S set STATUS='已经发货' where ORDER_ID='"+orderid+"'";
  System.out.println(sql);
 

 int i= st.executeUpdate(sql);
if (i>0){
response.sendRedirect("orders_no.jsp");
}


  }
  %>