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.menMenuSingle;

public class goDefaultAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		ActionForward forward=mapping.findForward("forward");
		HttpSession session=request.getSession();		
		List<menMenuSingle> menulist=new ArrayList<menMenuSingle>();
		
		String procName="{call menManageSelect(?)}";
		String sql="select * from tb_MenMenu where menMenu_level=1";
		DBO db=new DBO();
		ResultSet rs=db.menManageSelect(procName,sql);
		while(rs.next()){
			menMenuSingle menusingle=new menMenuSingle();
			menusingle.setId(rs.getInt("id"));
			menusingle.setMenuId(rs.getString("menMenu_id"));
			menusingle.setMenuName(rs.getString("menMenu_name"));
			menusingle.setMenuParrent("");
			menusingle.setMenuAction(rs.getString("menMenu_action"));
			menusingle.setMenuLevel((short)1);
			menusingle.setMenuOrder(rs.getShort("menMenu_order"));
			menulist.add(menusingle);
		}
		session.setAttribute("menulist",menulist);
		return forward;
	}
}