viewsysusermodule.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 ViewSysUserModule extends ActionInstance{
	public int execute(ActionForm af) throws Exception {
		Map funmap = new HashMap();
		String userid = af.getHttpRequest().getParameter("id");
		
		//用户角色功能
		DataForm roledf = new DataForm("SYS_USER_ROLE","ID");
		String rolesql = "select a.* from sys_user_role a right join sys_role b \n" +
				"on a.role_id=b.id where a.user_id='"+userid+"'";
		List rolelist = DaoUtil.select(af.getConnection(),rolesql, roledf);
		
		for(int i = 0;i < rolelist.size();i++)
		{
			DataForm userroledf = (DataForm)rolelist.get(i);	
			DataForm rolefundf = new DataForm("SYS_ROLE_MODULE","ID");
			String rolefunsql = "SELECT a.* FROM SYS_ROLE_MODULE a right join SYS_MODULE b \n" +
					"on a.module_id=b.id where a.role_id='"+userroledf.get("ROLE_ID")+"'";
			List tmplist = DaoUtil.select(af.getConnection(),rolefunsql,rolefundf);
			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 usergroupdf = new DataForm("SYS_USER_GROUP","ID");
		String usergroupsql = "select a.* from sys_user_group a right join sys_group b \n" +
				"on a.group_id=b.id where a.user_id='"+userid+"'";
		List uglist = DaoUtil.select(af.getConnection(),usergroupsql,usergroupdf);
		if(uglist.size()>0)
		{
			for(int i = 0;i < uglist.size();i++)
			{
				DataForm ugdf = (DataForm)uglist.get(i);
				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='"+ugdf.get("GROUP_ID")+"'";
				List glist = DaoUtil.select(af.getConnection(),groupfunsql,groupfundf);
				for(int j = 0;j<glist.size();j++)
				{
					DataForm tmpfundf = (DataForm)glist.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"));	
				}
			}	
		}	
		af.getHttpRequest().setAttribute("funmap",funmap);
		return 1;
	}

}