deleuser.jsp

一个 网上答疑系统 与大家分享 jsp+sql

<%@ page contentType="text/html; charset=GB2312" 
		language="java"
		import = "java.util.*, java.text.*"
		import = "java.sql.*,MyBean.dbcon"
%>

<%
  String userid=request.getParameter("userid");

  dbcon dbc =new dbcon();
  ResultSet rs=null;
  String userq=null;
   try{
   System.out.println("*******");
 try{
     rs=dbc.executeQuery("select * from topicinfo where topicuserid='"+userid+"'");
      }catch(Exception e){e.printStackTrace();}
     while(rs.next())
     {
     String topic = rs.getString("topicid");
     System.out.println("******"+topic+"*********");
     System.out.println("^^**^^^^****^^");
     dbcon dbc1 =new dbcon();
     dbc1.executeUpdate("delete from replyinfo where topicid='"+topic+"'");
     }
     dbcon dbc5 =new dbcon();
     dbc5.executeUpdate("delete from replyinfo where replyuseid='"+userid+"'");
     dbcon dbc2 =new dbcon();
     dbc2.executeUpdate("delete from topicinfo where topicuserid='"+userid+"'");
     dbcon dbc3 =new dbcon();
     dbc3.executeUpdate("delete from userinfo where userid='"+userid+"'");
    System.out.println("****####^^***^####***");
    }catch(Exception e){e.printStackTrace();}finally{rs.close();}

 
  

    %>
             <script language = "JavaScript">
                    alert("删除成功！");
                    location.href='manage.jsp';
             </script> 
    <%


%>