pcardaction.java

java web开发宝典源代码

package com.yxq.ModuleB.action;

import java.sql.ResultSet;
import java.util.ArrayList;

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

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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;
import org.apache.struts.actions.DispatchAction;

import com.yxq.ModuleB.actionform.PcardActionForm;
import com.yxq.share.dao.DBO;
import com.yxq.share.tools.MyTools;

public class PcardAction extends DispatchAction {
	public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception{
        HttpSession session=request.getSession();
        session.setAttribute("selectmenu","pcard");
        return super.execute(mapping,form,request,response);
	}
	public ActionForward Search(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		request.setAttribute("mainPage","/ModuleB/pcardShow.jsp");
		ActionForward forward=mapping.findForward("forward");
		ArrayList<PcardActionForm> pcardlist=new ArrayList<PcardActionForm>();
		String sql="";
		String searchType=request.getParameter("searchType");
		
		if(searchType==null||searchType.equals(""))
			searchType="all";
		if(searchType.equals("all")){
			sql="select * from tb_pcard order by pcard_time desc";
		}
		else{
			sql="";
			request.setAttribute("mainPage","/ModuleB/prompt.jsp");
		}
		
		int currentP=1;
		String strCurrentP=request.getParameter("showpage");		
		if(strCurrentP==null||strCurrentP.equals(""))
			strCurrentP="1";
		try{
			currentP=Integer.parseInt(strCurrentP);
		}catch(Exception e){
			currentP=1;
			e.printStackTrace();
		}
		
		int i=1;
		DBO db=new DBO(); 
		ResultSet rs=db.getCurrentRS(currentP, sql);
		if(rs!=null){
			try {
				while(rs.next()&&i<=db.getCreatepage().getPerR()){
					PcardActionForm pcardsingle=new PcardActionForm();
					pcardsingle.setId(rs.getInt("id"));
					pcardsingle.setPcardSubject(rs.getString("pcard_subject"));
					pcardsingle.setPcardContent(rs.getString("pcard_content"));
					pcardsingle.setPcardIssuer(rs.getString("pcard_issuer"));
					pcardsingle.setPcardTime(rs.getString("pcard_time"));
					pcardlist.add(pcardsingle);
					i++;
				}
				request.setAttribute("pcardlist",pcardlist);
				request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
				request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("ModuleB/office/pcard.do?method=Search&searchType="+searchType));
			} catch (Exception e) {
				e.printStackTrace();
			}
			db.closed();
		}
		return forward;
	}
	public ActionForward Add(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		request.setAttribute("mainPage","/ModuleB/pcardAdd.jsp");
		ActionForward forward=mapping.findForward("forward");
		
		String actionType=request.getParameter("actionType");		
		if(actionType==null)
			actionType="";
		if(actionType.equals("doOP")){
			ActionMessages message=new ActionMessages();			
			PcardActionForm pcardform=(PcardActionForm)form;
			String subject=pcardform.getPcardSubject();
			String issuer=pcardform.getPcardIssuer();
			String content=pcardform.getPcardContent();			
			
			String time=MyTools.getNowTime();
			String sql="insert into tb_pcard values('"+subject+"','"+issuer+"','"+time+"','"+content+"')";
			DBO db=new DBO();
			int i=db.Insert(sql);
			db.closed();
			if(i<=0){
				message.add("AddR",new ActionMessage("offic.pcard.add.E"));
				saveErrors(request,message);
			}
			else{
				pcardform.clear();
				message.add("AddR",new ActionMessage("offic.pcard.add.S"));
				saveErrors(request,message);
			}			
		}
		return forward;
	}
	public ActionForward Modify(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		request.setAttribute("mainPage","/ModuleB/prompt.jsp");
		ActionForward forward=mapping.findForward("forward");		
		return forward;
	}
	public ActionForward Delete(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		request.setAttribute("mainPage","/ModuleB/prompt.jsp");
		ActionForward forward=mapping.findForward("forward");		
		return forward;
	}
}