deluser.jsp

大学JSP课程大作业

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

<%@ page import="java.sql.*" %>
<%@ page import="my.shop.db.*" %>

<%-- 会话过滤 --%>
<%@ include file="sessionfilter.jsp" %>

<%
	String id = request.getParameter("id") ;
	String table = request.getParameter("table") ;
	String sql = "delete from "+table+" where id=?" ;
	Connection conn = DBConnection.getInstance().getConnection() ;
	PreparedStatement pstmt = conn.prepareStatement(sql) ;
	pstmt.setString(1,id) ;
	pstmt.executeUpdate() ;
	out.println("<div align='center'><font color=blue>指定用户成功删除！</font></div><br><a href='addadministrator.jsp'>返回</a>") ;
	pstmt.close() ;
	conn.close() ;
%>