dealdeleteuser.jsp

此为一个网上购书系统的JSP代码,包括填加图书,定单等功能.

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:useBean id="conn2" class="dbBean.DBBean"/>
<%@ include file="checkadmin.jsp"%>
<%
	String delid="0";
	if(request.getParameter("delid")!=null)
		delid=request.getParameter("delid");
	String sql="delete from user where userid="+delid;
	conn.executeUpdate(sql);
	conn.close();
	sql="delete from orderinfo where userid="+delid;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("manageuser.jsp");	
%>