articleoperateservlet.java

来自「这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架」· Java 代码 · 共 196 行

package servlet.article;

import java.io.IOException;
import java.sql.ResultSet;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.DealString;
import Bean.Pagination;

/**
 * Servlet implementation class for Servlet: ArticleOperateServlet
 *
 */
 public class ArticleOperateServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   String menu="";
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public ArticleOperateServlet() {
		super();
	}   	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		RequestDispatcher rd=null;
		//DC.getConnPool();
		String Id=request.getParameter("Id");
		String action=request.getParameter("action");
		String cur=request.getParameter("cur");
		 menu=request.getParameter("menu");
		String sql;
		db.DB dt=new db.DB();
		try{
			if(action.trim().equals("deleteR")){
				sql="update article set IsDel='1' where Id="+Id.trim();
				dt.executeUpdate(sql);//DC.ExecuteSQL(sql);
			}
			else if(action.trim().equals("deleteRs")){
				String[] Ids =request.getParameterValues("selected");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++)
						dt.executeUpdate("update article set IsDel='1' where Id="+Ids[i].trim());	
				}
			}
			else if(action.trim().equals("delete")){
				dt.executeUpdate("delete from article where Id="+Id.trim());
			}
			else if(action.trim().equals("deletes")){
				String[] Ids =request.getParameterValues("selected");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++)
						dt.executeUpdate("delete from article where Id="+Ids[i].trim());
				}
			}
			else if(action.trim().equals("move")){
				String[] Ids =request.getParameterValues("selected");
				String MenuId=request.getParameter("select");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++){
						dt.executeUpdate("update article set MenuID='"+MenuId.trim()+"' where Id="+Ids[i].trim());
					}
				}
			}
			else if(action.trim().equals("top")){
				dt.executeUpdate("update article set IsHead='1' where Id="+Id.trim());
			}
			else if(action.trim().equals("notop")){
				dt.executeUpdate("update article set IsHead='0' where Id="+Id.trim());
			}
			else if(action.trim().equals("commend")){
				dt.executeUpdate("update article set IsGood='1' where Id="+Id.trim());
			}
			else if(action.trim().equals("nocommend")){
				dt.executeUpdate("update article set IsGood='0' where Id="+Id.trim());
			}
			else if(action.trim().equals("aduit")){
				dt.executeUpdate("update article set IsShow='1' where Id="+Id.trim());
			}
			else if(action.trim().equals("aduits")){
				String[] Ids =request.getParameterValues("selected");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++){
						dt.executeUpdate("update article set IsShow='1' where Id="+Ids[i].trim());
					}
				}
			}
			else if(action.trim().equals("deleteRAduit")){
				dt.executeUpdate("update article set IsDel='1' where Id="+Id.trim());
			}else if(action.trim().equals("recycle")){
				dt.executeUpdate("update article set IsDel='0' where Id="+Id.trim());
			}else if(action.trim().equals("recycleall")){
				dt.executeUpdate("update article set IsDel='0' where IsDel='1'");
			}else if(action.trim().equals("recycelselected")){
				String[] Ids =request.getParameterValues("selected");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++){
						dt.executeUpdate("update article set IsDel='0' where Id="+Ids[i].trim());
					}
				}
			}
			else if(action.trim().equals("deleteselected")){
				String[] Ids =request.getParameterValues("selected");
				if(Ids!=null){
					for(int i=0;i<Ids.length;i++){
						dt.executeUpdate("delete from article where Id="+Ids[i].trim());
					}
				}
			}else if(action.trim().equals("recycleclear")){
				dt.executeUpdate("delete from article where IsDel='1'");
			}else if(action.trim().equals("recycledelete")){
				dt.executeUpdate("delete from article where IsDel='1' and Id="+Id.trim());
			}else if(action.trim().equals("Topicclear")){//专题清除
				if(Integer.valueOf(menu)>0){
					cleartopic(Id);
				}else{
					dt.executeUpdate("update article set TopicID='' where Id="+Id.trim());
				}
			}
			else if(action.trim().equals("topicclearselected")){
				String[] Ids =request.getParameterValues("selected");
				if(Integer.valueOf(menu)>0){
					if(Ids!=null){
						for(int i=0;i<Ids.length;i++){
							cleartopic(Ids[i].trim());
						}
					}
				}else{
					if(Ids!=null){
						for(int i=0;i<Ids.length;i++){
							dt.executeUpdate("update article set TopicID='' where Id="+Ids[i].trim());
						}
					}
				}
			}
			String PageType="manager";
			if(action.trim().equals("aduit") || action.trim().equals("aduits")|| action.trim().equals("deleteRAduit")){
				PageType="aduit";
			}else if(action.trim().equals("recycleall") || action.trim().equals("recycelselected") || action.trim().equals("deleteselected") || action.trim().equals("recycleclear") || action.trim().equals("recycle") || action.trim().equals("recycledelete")){
				PageType="recycle";
			}
			else if(action.trim().equals("Topicclear") || action.trim().equals("topicclearselected")){
				PageType="topic";
			}
			Pagination pagin=new Pagination("article",Integer.valueOf(cur),Integer.valueOf(menu),PageType);
			if(Integer.valueOf(cur)>pagin.getPagesnums())
				cur=String.valueOf(Integer.valueOf(cur)-1);
			pagin.CloseConn();

		}catch(Exception ex){
			System.out.println("在ArticleOperateServlet中出错："+ex);
		}finally{
			dt.close();
			if(action.trim().equals("aduit") || action.trim().equals("aduits")|| action.trim().equals("deleteRAduit")){
				rd=request.getRequestDispatcher("/jsjadmin/Article/article_aduit.jsp?menu="+menu.trim()+"&cur="+cur.trim());
			}else if(action.trim().equals("recycleall") || action.trim().equals("recycelselected") || action.trim().equals("deleteselected") || action.trim().equals("recycleclear") || action.trim().equals("recycle") || action.trim().equals("recycledelete")){
				rd=request.getRequestDispatcher("/jsjadmin/Article/article_recycle.jsp?menu="+menu.trim()+"&cur="+cur.trim());
			}else if(action.trim().equals("Topicclear") || action.trim().equals("topicclearselected")){
				rd=request.getRequestDispatcher("/jsjadmin/Article/article_topic.jsp?menu="+menu.trim()+"&cur="+cur.trim());
			}else{
				rd=request.getRequestDispatcher("/jsjadmin/Article/article_manager.jsp?menu="+menu.trim()+"&cur="+cur.trim());
			}rd.forward(request, response);
		}
	} 
	private void cleartopic(String ID){//清除指定ID的menu专题
		DealString dstr =new DealString();
		ResultSet rs =null;	
		String[] Topics;
		String NewTopicID="";
		db.DB dt=new db.DB();
		try{
			rs=dt.getRs("select TopicID from article where Id="+ID.trim());
			if(rs.next()){
				Topics=dstr.splitStr(rs.getString("TopicID"), '|');
				for(int i=0;i<Topics.length;i++){
					if(!Topics[i].trim().equals(menu.trim())){
						NewTopicID+=Topics[i].trim()+"|";
					}
				}if(!NewTopicID.trim().equals("")){
					NewTopicID=NewTopicID.substring(0,NewTopicID.length()-1);
				}
				dt.executeUpdate("update article set TopicID='"+NewTopicID+"' where Id="+ID.trim());
				dt.close();
			}
		}catch(Exception ex){
			System.out.print("在ArticleOperateServlet中出错清除专题："+ex);
		}
	}
}