godefaultaction.java

java web开发技术方案宝典

package com.yxq.action;

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

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.dao.DBO;
import com.yxq.menu.goodsMenuSingle;

public class goDefaultAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		HttpSession session=request.getSession();
		ActionForward forward=mapping.findForward("forward");
		List<goodsMenuSingle> menulist=new ArrayList<goodsMenuSingle>();
		
		String sql="select * from tb_GoodsMenu where goodsMenu_level=1";
		String procName="{call goodsManageSelect(?)}";
		DBO db=new DBO();
		
		ResultSet rs=db.goodsManageSelect(procName,sql);
		if(rs!=null){
			while(rs.next()){
				goodsMenuSingle menusingle=new goodsMenuSingle();
				menusingle.setId(rs.getInt("id"));
				menusingle.setMenuId(rs.getString("goodsMenu_id"));
				menusingle.setMenuName(rs.getString("goodsMenu_name"));
				menusingle.setMenuParrent("");
				menusingle.setMenuAction(rs.getString("goodsMenu_action"));
				menusingle.setMenuLevel((short)1);
				menusingle.setMenuOrder(rs.getShort("goodsMenu_order"));
				menusingle.setMenuPic(rs.getString("goodsMenu_pic"));
				menulist.add(menusingle);
			}			
		}
		session.setAttribute("menulist",menulist);		
		return forward;
	}
}