deluser.jsp

来自「这个主要是运用JAVA+JAVABEAN实现的网上投票调查系统」· JSP 代码 · 共 18 行

<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@include file="check.jsp"%>
<jsp:useBean id="MyBean" scope="session" class="myjsp.MyBean"/>
<jsp:setProperty name="MyBean" property="*"/>

<% Connection con = MyBean.getConnection(); 
  Statement smt = con.createStatement();
  %>
<%
 String deluser = request.getParameter("user");
 String sql = "delete from Admins where Admname= '"+deluser +"'";
 smt.executeUpdate(sql);
 response.sendRedirect("member.jsp");
 smt.close();
 MyBean.close();  //关闭Connection对象
%>