user_del.jsp

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

<%@ 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 userid=request.getParameter("userid");
    if( userid!=""){
	 Connection con;
    Statement st;
    con = DBConn.GetConn();
    st = con.createStatement();


   String    sql="delete * from Users where US_NAME='"+userid+"'";

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

    }
   response.sendRedirect("userchk.jsp");

    }
    %>