showsubmenuaction.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 showSubMenuAction 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> submenulist=new ArrayList<menMenuSingle>();
		
		String selectID=request.getParameter("selectID");
		if(selectID==null)
			selectID="";
		session.setAttribute("selectmenu",selectID);
		session.setAttribute("selectsubmenu","");
		if(!selectID.equals("")){
			String procName="{call menManageSelect(?)}";
			String sql="select * from tb_MenMenu where menMenu_parrent='"+selectID+"' and menMenu_level=2";
			DBO db=new DBO();
			ResultSet rs=db.menManageSelect(procName, sql);
			while(rs.next()){
				menMenuSingle submenusingle=new menMenuSingle();
				submenusingle.setId(rs.getInt("id"));
				submenusingle.setMenuId(rs.getString("menMenu_id"));
				submenusingle.setMenuName(rs.getString("menMenu_name"));
				submenusingle.setMenuParrent(selectID);
				submenusingle.setMenuAction(rs.getString("menMenu_action"));
				submenusingle.setMenuLevel((short)2);
				submenusingle.setMenuOrder(rs.getShort("menMenu_order"));
				submenulist.add(submenusingle);
			}
			session.setAttribute("submenulist",submenulist);			
		}
		return forward;
	}
}