viewsysgroupmodule.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 ViewSysGroupModule 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"));	
		}	
		af.getHttpRequest().setAttribute("funmap",funmap);
		return 1;
	}

}