sysgroupmodifyinit.java

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

package com.chis.model.user;

import java.util.ArrayList;
import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 群组修改初始化
 * @author baobao
 *
 */
public class SysGroupModifyInit extends ActionInstance{

	public int execute(ActionForm af) throws Exception {
		
		String groupid = af.getHttpRequest().getParameter("id");
		
		//群组信息
		DataForm groupdf = new DataForm("SYS_GROUP","ID");
		String groupsql = "SELECT * FROM SYS_GROUP WHERE ID='"+groupid+"'";
		List grouplist = DaoUtil.select(af.getConnection(),groupsql,groupdf);
		
		//群组角色
		DataForm grouproledf = new DataForm("SYS_GROUP_ROLE","ID");
		String grouprolesql = "select c.* from sys_group_role c right join sys_group d on c.group_id=d.id WHERE GROUP_ID='"+groupid+"'";
		List grouprolelist = DaoUtil.select(af.getConnection(),grouprolesql,grouproledf);
		
		//群组用户
		DataForm groupuserdf = new DataForm("SYS_USER_GROUP","ID");
		String groupusersql= "SELECT a.* FROM SYS_USER_GROUP a right join SYS_USER b on a.user_id=b.id where a.group_id='"+groupid+"'";
		List tmplist = DaoUtil.select(af.getConnection(),groupusersql,groupuserdf);
		
		DataForm userdf = new DataForm("SYS_USER","ID");
		List groupuserlist = new ArrayList();
		for(int i = 0;i < tmplist.size();i++)
		{
			DataForm gudf = (DataForm)tmplist.get(i);
			String rusql = "SELECT * FROM SYS_USER WHERE ID='"+gudf.get("USER_ID")+"'";
			DataForm tmpuserdf = (DataForm)DaoUtil.select(af.getConnection(),rusql,userdf).get(0);
			groupuserlist.add(tmpuserdf);				
		}	
		
		//群组功能
		DataForm groupfuncdf = new DataForm("SYS_GROUP_MODULE","ID");
		String groupfuncsql = "SELECT a.* FROM SYS_GROUP_MODULE a right join SYS_MODULE b on a.module_id=b.id where a.group_id='"+groupid+"'";
		List groupfunclist = DaoUtil.select(af.getConnection(),groupfuncsql,groupfuncdf);
		
		af.getHttpRequest().setAttribute("groupinfo",(DataForm)grouplist.get(0));
		af.getHttpRequest().setAttribute("grouprolelist",grouprolelist);
		af.getHttpRequest().setAttribute("groupuserlist",groupuserlist);
		af.getHttpRequest().setAttribute("groupfunclist",groupfunclist);
		return 1;
	}
}