listsysmodule.java.svn-base

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.model.user;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 获取所有功能列表
 * @author baobao
 *
 */
public class ListSysModule extends ActionInstance{
	public int execute(ActionForm af) throws Exception {
		String userid=af.getHttpSession().getAttribute("USERID").toString();
		String roleid = af.getHttpRequest().getParameter("id");
		Map funmap = new HashMap();	
		List biglist = new ArrayList();
		DataForm roledf = new DataForm("SYS_MODULE","ID");
		//String sql = "SELECT m.* FROM SYS_MODULE m left join SYS_ROLE_MODULE rm on rm.MODULE_ID=m.ID where rm.ROLE_ID='"+roleid+"' ORDER BY m.PATER_CODE ASC,m.CODE ASC";
		String sql="select id,code,name,pater_code,grade,tag,remarks,url from view_userid_module where user_id='"+userid+"' ORDER BY PATER_CODE ASC,CODE ASC";
		List list = DaoUtil.select(af.getConnection(),sql,roledf);
		for(int i = 0 ;i<list.size();i++)
		{		
			DataForm tmpdf = (DataForm)list.get(i);
			if("0".equals(tmpdf.get("PATER_CODE")))
			{
				List tmplist = new ArrayList();
				tmplist.add(tmpdf);
				funmap.put(tmpdf.get("CODE"),tmplist);
				
				biglist.add(tmplist);
			}else{
				List tmpList = (List) funmap.get(tmpdf.get("PATER_CODE"));
				tmpList.add(tmpdf);				
			}
		}
		af.getHttpRequest().setAttribute("allfunlist", biglist);
		return 1;
	}

}