articleaction.java

用于银行全面掌控公司及各个部门的员工信息与设备资料

package com.bank.struts.action;

import java.sql.Date;
import java.util.List;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.bank.hibernate.dao.AddArticleDAO;
import com.bank.hibernate.dao.QueryDAO;
import com.bank.hibernate.dao.UpdateArticle;
import com.bank.hibernate.factory.BaseDAO;
import com.bank.hibernate.pojo.Article;
import com.bank.hibernate.pojo.ArticleDAO;
import com.bank.struts.form.ArticleForm;


public class ArticleAction extends Action {
	
	
	int time1,time2;
	
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ArticleForm articleForm = (ArticleForm) form;// TODO Auto-generated method stub
		
		int code = Integer.parseInt(request.getParameter("code"));
		
		if(code == 1){
			
			String artTitle = articleForm.getArtTitle();                             
			String artTitles = articleForm.getArtTitles();
			String artBrief = articleForm.getArtBrief();
			String artAuthorId = articleForm.getArtAuthorId(); 
			String artAuthorName = articleForm.getArtAuthorName();
			Date artDeliverTime = Date.valueOf(articleForm.getArtDeliverTime());
			String artContent = articleForm.getArtContent();
			
			Article article = new Article(artTitle,artTitles,artBrief,artAuthorId,artAuthorName,artDeliverTime,artContent);
			
			AddArticleDAO dao = new AddArticleDAO();
			dao.addArticle(article);
			
			ArticleDAO daos = new ArticleDAO();
			
			List list = daos.findAll();
			request.setAttribute("list", list);
			
			return mapping.findForward("showArticle");
		}else if(code == 2){
			
			ArticleDAO daos = new ArticleDAO();
			
			List list = daos.findAll();
			request.setAttribute("list", list);
			
			return mapping.findForward("showArticle");
		}else if(code == 3){
			
			return mapping.findForward("addArticle");
		}else if(code == 4){
			
			String id = articleForm.getArtAuthorId();
			String name = articleForm.getArtAuthorName();
			String title = articleForm.getArtTitle();
			
			String timefrom = request.getParameter("usetime1");
			String timeto = request.getParameter("usetime2");
			
			String sql = "from Article where 1=1";
			
			if(id!=null && id.length()>0)
		    	sql += " and artAuthorId like '%"+id+"%'";
		    if(name!=null && name.length()>0)
		    	sql += " and artAuthorName like '%"+name+"%'";
		    if(title!=null && title.length()>0)
		    	sql += " and artTitle like '%"+title+"%'";
		    
		    if(timefrom!=null && timefrom.length()>0 && timeto!=null && timeto.length()>0){
		    	
		    	String s1 = timefrom.substring(0, 4)+timefrom.substring(5, 7)+timefrom.substring(8, 10);
		    	time1 = Integer.parseInt(s1);
		    	
		    	String s2 = timeto.substring(0, 4)+timeto.substring(5, 7)+timeto.substring(8, 10);
		    	time2 = Integer.parseInt(s2);
		    }
		    
		    if(time1!=0 && time2!=0){
		    	
		    	sql +=" and artDeliverTime >"+time1+" and artDeliverTime <"+time2;
		    }
		    
		    QueryDAO dao = new QueryDAO();
		    
		    List list = dao.findByProperties(sql);
		    request.setAttribute("list", list);
		    
			return mapping.findForward("showArticle");
		}else if(code == 5){
			String[] artIds = request.getParameterValues("artId");
			
			if(artIds!=null){
				
				BaseDAO dao = new BaseDAO();
				dao.delete("Article", "artId", artIds);
			}
			
			ArticleDAO daos = new ArticleDAO();
			
			List list = daos.findAll();
			request.setAttribute("list", list);
			
			return mapping.findForward("showArticle");
		}else if(code == 6){
			
			int artId = Integer.parseInt(request.getParameter("artId"));
			
			ArticleDAO dao = new ArticleDAO();
			Article article = dao.findById(artId);
			
			request.setAttribute("article", article);
			
			return mapping.findForward("view");
		}else if(code == 7){
			
			int artId = Integer.parseInt(request.getParameter("artId"));
			
			ArticleDAO dao = new ArticleDAO();
			Article article = dao.findById(artId);
			
			request.setAttribute("article", article);
			
			return mapping.findForward("update");
			
		}else if(code == 8){
			
			ArticleDAO daos = new ArticleDAO();
			
			List list = daos.findAll();
			request.setAttribute("list", list);
			return mapping.findForward("showArticle");
		}else if(code == 9){
			
			int artId = articleForm.getArtId();
			
			String artTitle = articleForm.getArtTitle();                             
			String artTitles = articleForm.getArtTitles();
			String artBrief = articleForm.getArtBrief();
			String artAuthorId = articleForm.getArtAuthorId(); 
			String artAuthorName = articleForm.getArtAuthorName();
			
			String time = articleForm.getArtDeliverTime();
			Date artDeliverTime = Date.valueOf(time);
			String artContent = articleForm.getArtContent();
			
			Article articles = new Article(artId,artTitle,artTitles,artBrief,artAuthorId,artAuthorName,artDeliverTime,artContent);
			
			UpdateArticle updates = new UpdateArticle();
			updates.updateArticles(articles);
			
			ArticleDAO daos = new ArticleDAO();
			
			List list = daos.findAll();
			request.setAttribute("list", list);
			return mapping.findForward("showArticle");
		}

		return null;
	}
}