goodsdynaction.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.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.actionform.GoodsDynForm;
import com.yxq.actionform.SearchForm;
import com.yxq.dao.DBO;
import com.yxq.tools.MyTools;

public class GoodsDynAction extends DispatchAction {
	public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		HttpSession session=request.getSession();
		session.setAttribute("selectmenu","goods_dyn");
		return super.execute(mapping,form,request,response);
	}
	public ActionForward Add(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");
		DBO db=new DBO();
		
		request.setAttribute("mainPage","/pages/goodsdyn/add.jsp");
		String actionType=request.getParameter("actionType");
		if(actionType==null||actionType.equals(""))	
			actionType="onlylink";
		
		if(!actionType.equals("doadd")){
			return forward;			
		}		
		else{
			GoodsDynForm goodsdynform=(GoodsDynForm)form;
			String title=goodsdynform.getTitle();
			String text=goodsdynform.getText();
			String issuer=goodsdynform.getIssuer();
			String today=MyTools.getNowTime();
			
			Map<String,Object> paramMap=new HashMap<String,Object>();
			
			paramMap.put("1",title);
			paramMap.put("2",text);
			paramMap.put("3",issuer);
			paramMap.put("4",today);
					
			String procName="{call goodsDynAdd(?,?,?,?)}";
			int i=db.goodsManageAdd(procName, paramMap);
			db.closed();
			if(i<=0){
				request.setAttribute("AddR","<li>发布失败！</li>");				
			}
			else{
				goodsdynform.clear();
				request.setAttribute("AddR","<li>发布成功！</li>");				
			}
		}
		return forward;
	}
	public ActionForward Delete(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");
		request.setAttribute("mainPage","/pages/goodsdyn/show.jsp");
		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 goodsDynDel(?)}";
		DBO db=new DBO();
		int i=db.goodsManageDel(procName, id);
		if(i<=0){
			System.out.println("删除失败！");
		}
		else{
			System.out.println("删除成功！");
			Search(mapping,form,request,response);
		}		
		return forward;
	}
	public ActionForward Modify(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");
		request.setAttribute("mainPage","/pages/goodsdyn/modify.jsp");
		
		String actionType=request.getParameter("actionType");
		if(actionType==null)
			actionType="";
		
		if(actionType.equals("onlylink")){
			String selectID=request.getParameter("id");
			if(selectID==null)selectID="-1";
			int id=-1;
			try{
				id=Integer.parseInt(selectID);
			}catch(Exception e){
				id=-1;
				e.printStackTrace();
			}
			String sql="select * from tb_goodsdyn where id = "+id;
			String procName="{call goodsManageSelect(?)}";
			DBO db=new DBO();
			ResultSet rs=db.goodsManageSelect(procName, sql);
            try{
            	if(rs!=null){
            		while(rs.next()){
            			GoodsDynForm goodsdynform=(GoodsDynForm)form;
            			goodsdynform.setId(id);
            			goodsdynform.setTitle(rs.getString("goodsdyn_title"));
            			goodsdynform.setText(rs.getString("goodsdyn_text"));
            			goodsdynform.setIssuer(rs.getString("goodsdyn_issuer"));
            			goodsdynform.setTime(rs.getString("goodsdyn_time"));            		
            		}
            	}            	
            }catch(Exception e){            	
            	e.printStackTrace();
            }
            db.closed();
		}		
		else if(actionType.equals("domodify")){
			GoodsDynForm goodsdynform=(GoodsDynForm)form;
			int id=goodsdynform.getId();
			String goodsdynTitle=goodsdynform.getTitle();
			String goodsdynText=goodsdynform.getText();
			String goodsdynIssuer=goodsdynform.getIssuer();
			Map<String,Object> paramMap=new HashMap<String,Object>();
			paramMap.put("1",goodsdynTitle);
			paramMap.put("2",goodsdynText);
			paramMap.put("3",goodsdynIssuer);
			paramMap.put("4",id);
			
			String procName="{call goodsDynModify(?,?,?,?)}";
			DBO db=new DBO();
			int i=db.goodsManageModify(procName, paramMap);
			db.closed();
			if(i<=0){
				request.setAttribute("ModifyR","<li>修改失败！</li>");			
			}
			else{
				request.setAttribute("ModifyR","<li>修改成功！</li>");
			}
		}
		return forward;
	}
	public ActionForward Search(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response){
		ActionForward forward=mapping.findForward("forward");
		HttpSession session=request.getSession();
		String sql="";
		String procName="{call goodsManageSelect(?)}";
		
		String actionType=request.getParameter("actionType");
		if(actionType==null)
			actionType="";
		if(actionType.equals("onlylink")){
			request.setAttribute("mainPage","/pages/goodsdyn/search.jsp");
		}
		else{			
			request.setAttribute("mainPage","/pages/goodsdyn/show.jsp");
			
			/*****************  确定查询的SQL语句 *****************/
			String searchType=request.getParameter("searchType");
			if(searchType==null)searchType="";				
			if(searchType.equals("condition")){           //条件查询
				String from=request.getParameter("from");
				if(from==null)from="";
				if(from.equals("form")){                         //单击表单的提交按钮
					SearchForm searchform=(SearchForm)form;
					String subsql=searchform.getSubsql();
					String sqlvalue=searchform.getSqlvalue();
					sql="select * from tb_goodsdyn where "+subsql+"='"+sqlvalue+"'";
					session.setAttribute("searchsql",sql);
				}
				else if(from.equals("linkpage"))               //单击分页链接
					sql=(String)session.getAttribute("searchsql");
			}
			else{                                         //查询所有
				sql="select * from tb_goodsdyn";
			}

			/*****************  获取当前页码 *****************/
			String strpage=request.getParameter("showpage");
			if(strpage==null||strpage.equals(""))
				strpage=(String)session.getAttribute("currentP");
			if(strpage==null||strpage.equals(""))
				strpage="1";
			int currentP=1;
			try{
				currentP=Integer.parseInt(strpage);
			}catch(Exception e){
				currentP=1;
				e.printStackTrace();
			}
			session.setAttribute("currentP",strpage);
			
			/*****************  获取当前页显示信息 *****************/
			DBO db=new DBO();
			List currentlist=db.getCurrentList(currentP, procName, sql);
			db.closed();
			request.setAttribute("currentlist",currentlist);
			request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
			request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("transport/goodsdyn.do?method=Search&from=linkpage&actionType=dosearch&searchType="+searchType));			
		}
		return forward;
	}
}