pro_del.jsp

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

<%@ 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 proid=request.getParameter("proid");
    if( proid!=""){
	 Connection con;
    Statement st;
    con = DBConn.GetConn();
    st = con.createStatement();
    String  sql="select * from Product where PRO_ID='"+proid+"'";
    ResultSet rs1=   st.executeQuery(sql);
   
    if (rs1.next())
    {
      String filename= rs1.getString("PRO_PIC") ;
      String path=request.getRealPath("/");

path=path+"\\wshop\\admin\\propic\\";
      String file=path+filename;
      file=file.toString();
      java.io.File delfile=new java.io.File(file);
      delfile.delete();
      sql="delete * from Product where PRO_ID='"+proid+"'";

      st.executeUpdate(sql);
      
      sql="select * top 1 from Product";
       ResultSet rs2=   st.executeQuery(sql);
      
       response.sendRedirect("prochk.jsp");
      
    }
    }


    }
    %>