zhandian_deletezhandianaction.java

java做的 公交车查询系统....毕业设计

//在zhandian.jsp页面中,进行删除站点的处理动作
package gongjiaochexitong.gongjiaoche.zhandian_pkg;

import gongjiaochexitong.gongjiaoche.*;
import gongjiaochexitong.gongjiaoche.main_pkg.*;

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 javax.servlet.ServletContext;
import javax.sql.DataSource;

public final class zhandian_deleteZhanDianAction extends Action{
	
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,  
			HttpServletResponse response) throws Exception {
				
	  zhandian_deleteZhanDianForm deletezhandianform = (zhandian_deleteZhanDianForm)form;
	  String zhandian_deleted = deletezhandianform.getZhandian_deleted().trim();
			
	  ServletContext context = servlet.getServletContext();
	  DataSource dataSource = (DataSource)context.getAttribute("db_gongjiaoche");
	  conn_Bus db = new conn_Bus(dataSource);
	  
	  HttpSession session = request.getSession();
	  ActionMessages actionMessages = new ActionMessages();
	  
	  String msg[]=new String[1];  //存放异常信息
	  msg[0]=null;
	  
	  if(zhandian_deleted!=null && !zhandian_deleted.equals("")){
		if(zhandian_procedure.deleteZhanDian(db, zhandian_deleted,msg)!=0){
            //重新加载车次列表
			try {				
				session.setAttribute(constants.ZHANDIAN_LIST_KEY,procedure.getZhanDian_List(db));
			} catch (Exception e) {
				e.printStackTrace();
			}
			
			actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
					new ActionMessage("label.zhandian_deletedSuccess"));
						
			if (!actionMessages.isEmpty()) {
						saveMessages(request, actionMessages);
			}
			
			db.conn_Close();     //close connection
			return mapping.findForward("zhandian_updateZhanDianSuccess");
		}
		else if(msg!=null){
			actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
					new ActionMessage(msg[0]));
						
			if (!actionMessages.isEmpty()) {
						saveMessages(request, actionMessages);
			}
			db.conn_Close();     //close connection
			return mapping.findForward("zhandian_updateZhanDianError");
		}
		else{
			actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
					new ActionMessage("label.zhandian_deletedFailure"));
						
			if (!actionMessages.isEmpty()) {
						saveMessages(request, actionMessages);
			}
			db.conn_Close();     //close connection
			return mapping.findForward("zhandian_updateZhanDianError");
		}
			
	  }
	  else{
	    actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
			new ActionMessage("label.zhandian_deletedFailure"));
						
		if (!actionMessages.isEmpty()) {
			saveMessages(request, actionMessages);
		}
		db.conn_Close();     //close connection
		return mapping.findForward("zhandian_updateZhanDianError");
	  }	
			
	}

}