delete2.jsp

来自「一个人员信息管理系统的源代码」· JSP 代码 · 共 21 行

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%
     String name=request.getParameter("name");
   try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection Conn=DriverManager.getConnection("jdbc:odbc:shop");
      Statement Stmt=Conn.createStatement();
      Stmt.executeUpdate("delete from member_info where name="+name);
      out.print("删除成功！");
   Stmt.close();
   Conn.close();
      
     }
    catch(SQLException e)
     {  out.print("<font color=red>发生错误！</font>");
     }
%>
<a href="main.jsp">返回菜单</a>