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"/>
<jsp:setProperty name="conn2" property="connStr" value="jdbc:odbc:forum"/>
<%@ 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);
	sql="select id from article where reID=0 and authorID="+delid;
	ResultSet rs=conn.executeQuery(sql);
	ResultSet rs2=null;
	while(rs.next())
	{	
		String id=rs.getString(1);
		sql="select authorID from article where reID="+id;
		rs2=conn2.executeQuery(sql);
		while(rs2.next())
		{
			sql="update user set pubnum=pubnum-1 where userid="+rs2.getString(1);
			conn2.executeUpdate(sql);
		}
		rs2.close();
		sql="delete from article where reID="+id;
		conn.executeUpdate(sql);
	}
	rs.close();
	sql="select reID from article where reID<>0 and authorID="+delid;
	rs=conn.executeQuery(sql);
	while(rs.next())
	{
		sql="update article set reNum=reNum-1 where id="+rs.getString(1);
		conn.executeUpdate(sql);
	}
	rs.close();
	sql="delete from article where authorID="+delid;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("manage.jsp");	
%>