delsomecard.java

一个信息发布系统 基于jsp+servlet+tomcat 用户分管理员跟普通用户 普通用户有发布信息 查询信息 修改信息 回复信息 管理员拥有普通用户的功能 此外还具有删除信息 管理信息的回复的功能

package control;
import java.io.IOException;
import javax.servlet.http.*;
import javax.servlet.*;

import model.*;
import java.util.*;

public class DelSomeCard extends ShowCategory
{
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
    {
		String[] someCardID = req.getParameterValues("checkbox");
		int[] realCardID = new int[someCardID.length];
		
    	String UserName = req.getParameter("UserName");
    	int pagenum = Integer.parseInt(req.getParameter("pagenum"));
    	String Sort_Condition = (String)req.getParameter("sortcondition");      //2008.11.19修改  取得排序方式
    	System.out.println("DelSomeCard By: " + Sort_Condition);
    	int pagecount = 0;
    	int total = 0;
    	boolean result = false;
    	CardCom com = new CardCom("jdbc:mysql://localhost/mybbs","root", "root123");
    	/*for(int i=0;i < someCardID.length;++i)
		{
			realCardID[i] = Integer.parseInt(someCardID[i]);   //取得所选中的文章ID
			System.out.println(someCardID[i]);
			com.delCard(realCardID[i]);
		}*/

        if(((Boolean)req.getSession().getAttribute("AdminOrNot")).booleanValue())//如果是管理员
        {
        	for(int i=0;i < someCardID.length;++i)
    		{
    			realCardID[i] = Integer.parseInt(someCardID[i]);   //取得所选中的文章ID
    			System.out.println(someCardID[i]);
    			result = com.delCard(realCardID[i]);
    			if(result == false)
    				break;
    		}
        	Vector vc=com.getAllCard(pagenum,Sort_Condition);
    	   CategoryCom com2 = new CategoryCom("jdbc:mysql://localhost/mybbs","root", "root123");
    	   total = com2.getCCount("all");  
    	   if(total!=0 && vc.size()==0 && pagenum > 1)
    	   {
    		   pagenum = pagenum -1;
    		   vc = com.getAllCard(pagenum,Sort_Condition);
    	   }

       	   if(total % 8==0)
       		   pagecount  = total/8;
       	   else
       		   pagecount = ((int)total/8)+1;
       	   //req.setAttribute("Message","欢迎进入所搜结果页面");
       	   req.setAttribute("NewsCount",new Integer(total));
           req.setAttribute("allcard", vc);
           req.setAttribute("cname","all");
           req.setAttribute("cpath","all");
           req.setAttribute("pagenum",String.valueOf(pagenum));  //当前页数
       	   req.setAttribute("pagecount", String.valueOf(pagecount));//总共需要多少页面数
       	   req.setAttribute("command", "guanli");
       	   req.setAttribute("sortcondition", Sort_Condition);  //2008.11.19修改  取得排序方式
       	   if(result==true)
       		   req.setAttribute("Message","删除文章成功，页面已被刷新");   
       	   else
       		   req.setAttribute("Message","删除文章失败，页面已被刷新"); 	   
       	   tiaoZhuan(req,res,"/ShowAllCardList.jsp");
       }
       else if(((String)req.getSession().getAttribute("USER")).equals(UserName))
       {
    	   for(int i=0;i < someCardID.length;++i)
   			{
   				realCardID[i] = Integer.parseInt(someCardID[i]);   //取得所选中的文章ID
   				System.out.println(someCardID[i]);
   				result = com.delCard(realCardID[i]);
   				if(result==false)
   					break;
   			}
    	   Vector vc = com.getCardByUserName((String)req.getSession().getAttribute("USER"),pagenum,Sort_Condition);
    	   UserCom com3 = new UserCom("jdbc:mysql://localhost/mybbs","root", "root123");
    	   total = com3.getTieziShuliang(UserName);
    	   
    	   if(total != 0 && vc.size()==0 && pagenum > 1)
    	   {
    		   pagenum = pagenum -1 ;
    		   vc = com.getCardByUserName((String)req.getSession().getAttribute("USER"),pagenum,Sort_Condition);
    	   }
    	   if(total % 8==0)
       		   pagecount  = total/8;
       	   else
       		   pagecount = ((int)total/8)+1;
    	   req.setAttribute("NewsCount",new Integer(total));
           req.setAttribute("allcard", vc);
           req.setAttribute("pagenum",String.valueOf(pagenum));  //当前页数
       	   req.setAttribute("pagecount", String.valueOf(pagecount));//总共需要多少页面数
       	   req.setAttribute("command", "guanli");
       	   req.setAttribute("sortcondition", Sort_Condition);  //2008.11.19修改  取得排序方式
       	   if(result==true)
    		   req.setAttribute("Message","删除文章成功，页面已被刷新");   
    	   else
    		   req.setAttribute("Message","删除文章失败，页面已被刷新");
       	   tiaoZhuan(req,res,"/ShowMyCardList.jsp");
       }
       else
    	   ;
    }
}