sysgroupadd.java.svn-base

用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 SysGroupAdd extends ActionInstance{
	public int execute(ActionForm af) throws Exception {
		
		//群组信息
		try{
			DataForm groupdf = new DataForm("SYS_GROUP","ID");
			groupdf.setValues(af.getHttpRequest());
			groupdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
			String groupname = groupdf.get("NAME").toString().trim();
			
			//群组名是否存在
			String checksql = "SELECT * FROM SYS_GROUP WHERE NAME='"+groupname+"'";
			if(DaoUtil.select(af.getConnection(),checksql,groupdf).size()>0)
			{
				af.getHttpRequest().setAttribute("result","该群组名已经存在!");
				return 0;
			}	
			groupdf.set("NAME",groupname);
			
			//群组角色	
			String[] grouprole = af.getHttpRequest().getParameterValues("grouprole");
			if(grouprole != null && !"".equals(grouprole))
			{
				for(int i = 0;i<grouprole.length;i++)
				{
					DataForm grouproledf = new DataForm("SYS_GROUP_ROLE","ID");
					grouproledf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
					grouproledf.set("GROUP_ID",groupdf.get("ID"));
					grouproledf.set("ROLE_ID",grouprole[i]);
					DaoUtil.insert(af.getConnection(), grouproledf);
				}		
			}			
			//群组用户
/*			String groupuser = af.getHttpRequest().getParameter("userarray");
			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()));
							
					String usql = "SELECT * FROM SYS_USER WHERE LOGON_NAME='"+userarray[i]+"'";
					DataForm[] udf = DaoUtil.getDFListBySQL(af.getConnection(),usql);	
					
					groupuserdf.set("GROUP_ID",groupdf.get("ID"));
					groupuserdf.set("USER_ID", udf[0].get("ID"));
					
					DaoUtil.insert(af.getConnection(),groupuserdf);
				}
			}*/
			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[] groupfunc = af.getHttpRequest().getParameterValues("groupfunc");
			if(groupfunc != null && !"".equals(groupfunc))
			{
				for(int i = 0;i < groupfunc.length;i++)
				{
					DataForm groupfuncdf = new DataForm("SYS_GROUP_MODULE","ID");
					groupfuncdf.set("ID",GUIDKeyGen.getGUIDKey(af.getConnection()));
					groupfuncdf.set("GROUP_ID",groupdf.get("ID"));
					groupfuncdf.set("MODULE_ID",groupfunc[i]);
					DaoUtil.insert(af.getConnection(),groupfuncdf);
				}
			}
			//群组
			DaoUtil.insert(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;
		}
	}

}