viewsysgroupallmodule.java.svn-base

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

package com.chis.model.user;

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 ViewSysGroupAllModule extends ActionInstance{


	public int execute(ActionForm af) throws Exception {
		Map funmap = new HashMap();
		String groupid = af.getHttpRequest().getParameter("id");			
		
		DataForm groupfundf = new DataForm("SYS_GROUP_MODULE","ID");
		String groupfunsql = "SELECT a.* FROM SYS_GROUP_MODULE a right join SYS_MODULE b \n" +
				"on a.module_id=b.id where a.group_id='"+groupid+"'";
		List tmplist = DaoUtil.select(af.getConnection(),groupfunsql,groupfundf);
		
		//群组的权限
		for(int j = 0;j<tmplist.size();j++)
		{
			DataForm tmpfundf = (DataForm)tmplist.get(j);			
			DataForm fundf = new DataForm("SYS_MODULE","ID");
			
			String funsql = "SELECT * FROM SYS_MODULE WHERE ID='"+tmpfundf.get("MODULE_ID")+"'";
			List funlist = DaoUtil.select(af.getConnection(),funsql,fundf);
			DataForm fun = (DataForm)funlist.get(0);				
			funmap.put(fun.get("ID"),fun.get("NAME"));	
		}			
		//角色权限
		DataForm grouproledf =  new DataForm("SYS_GROUP_ROLE","ID");
		String grouprolesql = "select a.* from sys_group_role a right join sys_role b \n" +
				"on a.role_id=b.id where a.group_id='"+groupid+"'";
		List grouprolelist = DaoUtil.select(af.getConnection(),grouprolesql,grouproledf);
		for(int i = 0;i<grouprolelist.size();i++)
		{
			DataForm roledf = (DataForm)grouprolelist.get(i);
			
			DataForm rolefuncdf = new DataForm("SYS_ROLE_MODULE","ID");
			String rolefuncsql = "SELECT a.* FROM SYS_ROLE_MODULE a right join SYS_MODULE b \n" +
					"on a.module_id=b.id where a.role_id='"+roledf.get("ROLE_ID")+"'";
			List funclist = DaoUtil.select(af.getConnection(),rolefuncsql,rolefuncdf);
			
			for(int k = 0;k<funclist.size();k++)
			{
				DataForm funciddf = (DataForm)funclist.get(k);
				
				DataForm funcdf = new DataForm("SYS_MODULE","ID");
				String funcsql = "SELECT * FROM SYS_MODULE WHERE ID='"+funciddf.get("MODULE_ID")+"'";
				List flist = DaoUtil.select(af.getConnection(),funcsql,funcdf);
				DataForm df = (DataForm)flist.get(0);
				funmap.put(df.get("ID"),df.get("NAME"));			
			}	
		}
/*		Set set = funmap.entrySet();
		Iterator it = set.iterator();	
		while(it.hasNext())
		{
			Map.Entry me = (Map.Entry)it.next();
			System.out.println(me.getKey()+" == "+me.getValue());	
		}*/
		af.getHttpRequest().setAttribute("funmap",funmap);
		return 1;
	}

}