branchaction.java

java web开发技术方案宝典

package com.yxq.action;

import java.sql.ResultSet;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 com.yxq.actionform.BranchForm;
import com.yxq.actionform.SearchForm;
import com.yxq.dao.DBO;

public class BranchAction extends Action {

	public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception {
		HttpSession session=request.getSession();
		session.setAttribute("selectsubmenu","mngBranch");
		ActionForward forward=new ActionForward();
		String action=request.getParameter("op");
		if(action==null)
			action="";
		if(action.equals("search"))
			forward=Search(mapping,form,request,response);
		if(action.equals("add"))
			forward=Add(mapping,form,request,response);
		if(action.equals("modify"))
			forward=Modify(mapping,form,request,response);
		if(action.equals("delete"))
			forward=Delete(mapping,form,request,response);
		return forward;
	}
	public ActionForward Search(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception {
		HttpSession session=request.getSession();
		ActionForward forward=mapping.findForward("forward");
		String actiontype=request.getParameter("actiontype");
		if(actiontype==null)
			actiontype="";
		if(actiontype.equals("link")){
			request.setAttribute("mainPage","/pages/mngBranch/search.jsp");
			return forward;
		}
		
		request.setAttribute("mainPage","/pages/mngBranch/show.jsp");		
		String searchtype=request.getParameter("searchtype");
		if(searchtype==null||searchtype.equals(""))
			searchtype="all";
		String sql="";
		if(searchtype.equals("all")){                                            //查询全部
			sql="select * from tb_branch";
			session.setAttribute("conditionSQL",sql);
		}
		else if(searchtype.equals("condition")){                                //表单查询
			SearchForm searchform=(SearchForm)form;
			String subsql=searchform.getSubsql();
			String sqlvalue=searchform.getSqlvalue();
			sql="select * from tb_branch where "+subsql+" like '%"+sqlvalue+"%'";
			session.setAttribute("conditionSQL",sql);				
		}
		if(searchtype.equals("link")){                                          //分页查询
			sql=(String)session.getAttribute("conditionSQL");
		}
		
		String strpage=request.getParameter("showpage");
		if(strpage==null||strpage.equals(""))
			strpage=(String)session.getAttribute("strpage");
		if(strpage==null||strpage.equals(""))
			strpage="1";
		int currentP=1;
		try{
			currentP=Integer.parseInt(strpage);
		}catch(Exception e){
			currentP=1;
			e.printStackTrace();
		}
		session.setAttribute("strpage",Integer.toString(currentP));
		
		String procName="{call menManageSelect(?)}";
		DBO db=new DBO();
		List currentlist=db.getCurrentList(currentP, procName, sql);
		
		request.setAttribute("currentlist",currentlist);
		request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
		request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("mng/baseDate/mngBranch/search.do?op=search&actiontype=dosearch&searchtype=link"));
		return forward;
	}
	public ActionForward Add(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception {
		ActionForward forward=mapping.findForward("forward");
		ActionMessages messages=new ActionMessages();
		DBO db=new DBO();
		
		request.setAttribute("mainPage","/pages/mngBranch/add.jsp");
		String actiontype=request.getParameter("actiontype");
		if(actiontype==null||actiontype.equals(""))
			actiontype="link";
		
		if(actiontype.equals("link")){
			int branchNum=0;
			String sql="select max(id) as maxID from tb_branch";
			String procName="{call menManageSelect(?)}";
			ResultSet rs=db.menManageSelect(procName, sql);
			if(rs!=null&&rs.next()){
				branchNum=rs.getInt("maxID")+1;
			}
			else
				branchNum=1;
			BranchForm branchform=(BranchForm)form;
			branchform.setId(branchNum);
			return forward;			
		}		
		else if(actiontype.equals("doadd")){
			BranchForm branchform=(BranchForm)form;
			String branchName=branchform.getBranchName();
			String sql="select * from tb_branch where branch_name='"+branchName+"'";
			String procName="{call menManageSelect(?)}";
			ResultSet rs=db.menManageSelect(procName, sql);
			if(rs!=null&&rs.next()){
				messages.add("BranchNameE",new ActionMessage("branch.name.exist"));
				saveErrors(request,messages);
				return forward;
			}
			String branchInfo=branchform.getBranchInfo();
			String branchManager=branchform.getBranchManager();
			String branchAddr=branchform.getBranchAddr();
			String branchPhone=branchform.getBranchPhone();
			
			Map<String,Object> paramMap=new HashMap<String,Object>();
			
			paramMap.put("1",branchName);
			paramMap.put("2",branchInfo);
			paramMap.put("3",branchManager);
			paramMap.put("4",branchAddr);
			paramMap.put("5",branchPhone);
			
			procName="{call menBranchAdd(?,?,?,?,?)}";
			int i=db.menManageAdd(procName, paramMap);
			db.closed();
			if(i<=0){
				request.setAttribute("AddR","<li>添加失败！</li>");						
			}
			else{
				branchform.clear();
				request.setAttribute("AddR","<li>添加成功！</li>");
			}
		}
		return forward;
	}
	public ActionForward Modify(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception {
		ActionForward forward=mapping.findForward("forward");
		request.setAttribute("mainPage","/pages/mngBranch/modify.jsp");
		
		String actiontype=request.getParameter("actiontype");
		if(actiontype==null||actiontype.equals(""))	
			actiontype="link";
		
		if(actiontype.equals("link")){
			String selectID=request.getParameter("id");
			if(selectID==null)selectID="";
			int id=-1;
			try{
				id=Integer.parseInt(selectID);
			}catch(Exception e){
				id=-1;
				e.printStackTrace();
			}
			String sql="select * from tb_branch where id = "+id;
			String procName="{call menManageSelect(?)}";
			DBO db=new DBO();
			ResultSet rs=db.menManageSelect(procName, sql);
            if(rs!=null){
            	while(rs.next()){
            		BranchForm branchform=(BranchForm)form;
            		branchform.setId(id);
            		branchform.setBranchName(rs.getString("branch_name"));
        			branchform.setBranchInfo(rs.getString("branch_info"));
        			branchform.setBranchManager(rs.getString("branch_manager"));
        			branchform.setBranchAddr(rs.getString("branch_addr"));
        			branchform.setBranchPhone(rs.getString("branch_phone"));
            	}
            }
            db.closed();
			return forward;			
		}		
		else if(actiontype.equals("domodify")){
			BranchForm branchform=(BranchForm)form;
			String branchName=branchform.getBranchName();
			String branchInfo=branchform.getBranchInfo();
			String branchManager=branchform.getBranchManager();
			String branchAddr=branchform.getBranchAddr();
			String branchPhone=branchform.getBranchPhone();
			int id=branchform.getId();
			
			Map<String,Object> paramMap=new HashMap<String,Object>();
			paramMap.put("1",branchName);
			paramMap.put("2",branchInfo);
			paramMap.put("3",branchManager);
			paramMap.put("4",branchAddr);
			paramMap.put("5",branchPhone);
			paramMap.put("6",id);
			
			String procName="{call menBranchModify(?,?,?,?,?,?)}";
			DBO db=new DBO();
			int i=db.menManageModify(procName, paramMap);
			db.closed();
			if(i<=0){
				request.setAttribute("ModifyR","<li>更新失败！</li>");						
			}
			else{			
				request.setAttribute("ModifyR","<li>更新成功！</li>");
			}
		}
		return forward;
	}
	public ActionForward Delete(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws Exception {
		ActionForward forward=mapping.findForward("forward");
		String selectID=request.getParameter("id");
		if(selectID==null)selectID="";
		int id=-1;
		try{
			id=Integer.parseInt(selectID);
		}catch(Exception e){
			id=-1;
			e.printStackTrace();
		}
		String procName="{call menBranchDel(?)}";
		DBO db=new DBO();
		int i=db.menManageDel(procName, id);
		if(i<=0){
			System.out.println("删除失败！");
		}
		else{
			System.out.println("删除成功！");
			Search(mapping,form,request,response);
		}		
		return forward;
	}
}