sysrolemodifyinit.java.svn-base

用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 zxh
 *
 */
public class SysRoleModifyInit extends ActionInstance {

	public int execute(ActionForm af) throws Exception {
		String roleid = af.getHttpRequest().getParameter("id");
		//角色信息
		DataForm roledf = new DataForm("SYS_ROLE","ID");
		String rolesql = "SELECT * FROM SYS_ROLE WHERE ID='"+roleid+"'";
		List rolelist = DaoUtil.select(af.getConnection(),rolesql,roledf);
		
		//角色群组信息
		DataForm rolegroupdf = new DataForm("SYS_GROUP_ROLE","ID");
		String rolegroupsql = "select c.* from sys_group_role c right join sys_group d on c.group_id=d.id where c.role_id='"+roleid+"'";
		List rolegrouplist = DaoUtil.select(af.getConnection(),rolegroupsql,rolegroupdf);		

		
		//角色初始用户
		DataForm roleuserdf = new DataForm("SYS_USER_ROLE","ID");
		String roleusersql = "SELECT a.* FROM SYS_USER_ROLE a right join SYS_USER b on a.user_id=b.ID where a.role_id='"+roleid+"'";
		List tmplist = DaoUtil.select(af.getConnection(),roleusersql,roleuserdf);
		
		DataForm userdf = new DataForm("SYS_USER","ID");
		List roleuserlist = new ArrayList();	
		for(int i = 0;i<tmplist.size();i++)
		{
			DataForm rudf = (DataForm)tmplist.get(i);
			String rusql = "SELECT * FROM SYS_USER WHERE ID='"+rudf.get("USER_ID")+"'";
			DataForm tmpuserdf = (DataForm)DaoUtil.select(af.getConnection(),rusql,userdf).get(0);
			roleuserlist.add(tmpuserdf);
		}	
		
		//角色功能
		DataForm rolefuncdf = new DataForm("SYS_ROLE_MODULE","ID");
		String rolefuncsql = "SELECT a.* FROM SYS_ROLE_MODULE a right join SYS_MODULE b on a.module_id=b.id where a.role_id='"+roleid+"'";
		List rolefunclist = DaoUtil.select(af.getConnection(),rolefuncsql,rolefuncdf);
		
		af.getHttpRequest().setAttribute("roleinfo",(DataForm)rolelist.get(0));
		af.getHttpRequest().setAttribute("rolegrouplist",rolegrouplist);
		af.getHttpRequest().setAttribute("roleuserlist",roleuserlist);
		af.getHttpRequest().setAttribute("rolefunclist",rolefunclist);
		return 1;
	}

}