orders_del.jsp

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

<%@ page contentType="text/html; charset=gb2312"  %>

<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");
    if( orderid!=""){
	 Connection con;
    Statement st;
    con = DBConn.GetConn();
    st = con.createStatement();
    String  sql="";

      sql="delete * from Order_Pro where ORDER_ID='"+orderid+"'";

      st.executeUpdate(sql);
	  sql="delete * from Order_S where ORDER_ID='"+orderid+"'";
	int i=  st.executeUpdate(sql);
	  if (i>0){
	  response.sendRedirect("orders_yes.jsp");
	  }
     
    }
    }



    %>