meetaction.java

java web开发宝典源代码

package com.yxq.ModuleA.action;

import java.sql.ResultSet;
import java.sql.SQLException;
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 com.yxq.ModuleA.actionform.MeetActionForm;
import com.yxq.share.dao.DBO;

public class MeetAction extends Action {
	public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception{
        ActionForward forward=new ActionForward();
		HttpSession session=request.getSession();
        session.setAttribute("selectmenu","meet");
		String op=request.getParameter("op");
		if(op==null)
			op="";
		if(op.equals("search"))
			forward=doSearch(mapping,form,request,response);
		if(op.equals("add"))
			forward=doAdd(mapping,form,request,response);
		if(op.equals("modify"))
			forward=doModify(mapping,form,request,response);
		if(op.equals("delete"))
			forward=doDelete(mapping,form,request,response);
		return forward;
	}
	public ActionForward doSearch(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		request.setAttribute("mainPage","/ModuleA/meetShow.jsp");
		ActionForward forward=mapping.findForward("forward");
		ArrayList<MeetActionForm> meetlist=new ArrayList<MeetActionForm>();
		String sql="";
		String searchType=request.getParameter("searchType");
		
		if(searchType==null||searchType.equals(""))
			searchType="all";
		if(searchType.equals("all")){
			sql="select * from tb_meet";
		}
		else{
			sql="";
		}
		
		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()){
					MeetActionForm meetsingle=new MeetActionForm();
					meetsingle.setId(rs.getInt("id"));
					meetsingle.setMeetSubject(rs.getString("meet_subject"));
					meetsingle.setMeetContent(rs.getString("meet_content"));
					meetsingle.setMeetSpeaker(rs.getString("meet_speaker"));
					meetsingle.setMeetListener(rs.getString("meet_listener"));
					meetsingle.setMeetTime(rs.getString("meet_time"));
					meetsingle.setMeetAddress(rs.getString("meet_address"));
					meetlist.add(meetsingle);
					i++;
				}
				request.setAttribute("meetlist",meetlist);
				request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
				request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("ModuleA/office/meet.do?op=search&searchType="+searchType));
			} catch (SQLException e) {
				e.printStackTrace();
			}
			db.closed();
		}
		return forward;
	}
	public ActionForward doAdd(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");		
		return forward;
	}
	public ActionForward doModify(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");		
		return forward;
	}
	public ActionForward doDelete(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");		
		return forward;
	}
}