sysgroupmodify.java

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

package com.chis.model.user;

import com.chis.util.GUIDKeyGen;
import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 修改群组信息
 * @author baobao
 *
 */
public class SysGroupModify extends ActionInstance{


	public int execute(ActionForm af) throws Exception {
		
		String groupid = af.getHttpRequest().getParameter("ID");		
		DataForm groupdf = new DataForm("SYS_GROUP","ID");
		StringBuffer sbsql = new StringBuffer();
		try{
			groupdf.setValues(af.getHttpRequest());	
			String groupname = groupdf.get("NAME").toString().trim();
			
			//群组名是否存在
			sbsql.append("select * from sys_group where ");
			sbsql.append("name in(select name from sys_group where id not in('"+groupid+"'))");
			sbsql.append(" and name='"+groupname+"'");
			
			if(DaoUtil.select(af.getConnection(),sbsql.toString(),groupdf).size()>0)
			{
				af.getHttpRequest().setAttribute("result","该群组名已经存在!");
				return 0;
			}
			
			groupdf.set("NAME",groupname);
			
			//群组角色
			String grouprolesql = "DELETE FROM SYS_GROUP_ROLE WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),grouprolesql);
			
			String[] newgrouprole = af.getHttpRequest().getParameterValues("grouprole");
			if(newgrouprole!=null && !"".equals(newgrouprole))
			{
				for(int i =0;i<newgrouprole.length;i++)
				{
					DataForm newrolegroupdf = new DataForm("SYS_GROUP_ROLE","ID");
					newrolegroupdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
					newrolegroupdf.set("ROLE_ID", newgrouprole[i]);
					newrolegroupdf.set("GROUP_ID", groupdf.get("ID"));
					DaoUtil.insert(af.getConnection(), newrolegroupdf);
				}
			}
			
			//群组用户
			String roleusersql = "DELETE FROM SYS_USER_GROUP WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),roleusersql);	
			
/*			String newgroupuser = af.getHttpRequest().getParameter("userarray");
			if(newgroupuser!=null && !"".equals(newgroupuser))
			{
				String[] userarray = newgroupuser.split(";");
				for(int i = 0;i<userarray.length;i++)
				{
					DataForm newgroupuserdf = new DataForm("SYS_USER_GROUP","ID");
					newgroupuserdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
					
					String usql = "SELECT * FROM SYS_USER WHERE LOGON_NAME='"+userarray[i]+"'";
					DataForm[] udf = DaoUtil.getDFListBySQL(af.getConnection(),usql);
					
					newgroupuserdf.set("GROUP_ID", groupdf.get("ID"));
					newgroupuserdf.set("USER_ID", udf[0].get("ID"));			
					DaoUtil.insert(af.getConnection(), newgroupuserdf);				
				}	
			}*/
			String groupuser = af.getHttpRequest().getParameter("hid_");
			if(groupuser!=null&&!"".equals(groupuser))
			{
				String[] userarray = groupuser.split(",");
				for(int i = 0;i < userarray.length;i++)
				{
					DataForm groupuserdf = new DataForm("SYS_USER_GROUP","ID");
					groupuserdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));		
					groupuserdf.set("GROUP_ID",groupdf.get("ID"));
					groupuserdf.set("USER_ID", userarray[i]);					
					DaoUtil.insert(af.getConnection(),groupuserdf);
				}
			}	
			
			//群组功能
			String rolefuncsql = "DELETE FROM SYS_GROUP_MODULE WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),rolefuncsql);
			
			String[] newgroupfunc = af.getHttpRequest().getParameterValues("groupfunc");
			if(newgroupfunc!=null&&!"".equals(newgroupfunc))
			{
				for(int i = 0;i<newgroupfunc.length;i++){
					DataForm newgroupfuncdf = new DataForm("SYS_GROUP_MODULE","ID");
					newgroupfuncdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
					newgroupfuncdf.set("GROUP_ID", groupdf.get("ID"));
					newgroupfuncdf.set("MODULE_ID",newgroupfunc[i]);
					DaoUtil.insert(af.getConnection(), newgroupfuncdf);								
				}
			}		
			DaoUtil.update(af.getConnection(),groupdf);
			af.getHttpRequest().setAttribute("result","更新群组信息");
			af.getHttpRequest().setAttribute("goto","Selevet.do?action=BASE_SYSGROUP_LIST");
			af.getHttpRequest().setAttribute("CMD",af.getHttpRequest().getParameter("CMD"));
			return 1;
		}catch(Exception e)
		{
			e.printStackTrace();
			af.getHttpRequest().setAttribute("result","更新群组信息");
			return 0;
		}
	}

}