sysgroupdel.java.svn-base

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

package com.chis.model.user;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 删除群组数据
 * @author baobao
 *
 */
public class SysGroupDel extends ActionInstance{


	public int execute(ActionForm af) throws Exception {
		
		String groupid = af.getHttpRequest().getParameter("id");
		try{
			//群组角色
			DataForm grouproledf = new DataForm("SYS_GROUP_ROLE","ID");
			String grouprolesql = "DELETE FROM SYS_GROUP_ROLE WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),grouprolesql);
	
			//群组用户
			DataForm groupuserdf = new DataForm("SYS_USER_GROUP","ID");	
			String roleusersql = "DELETE FROM SYS_USER_GROUP WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),roleusersql);	
			
			//群组功能
			DataForm groupfuncdf = new DataForm("SYS_GROUP_MODULE","ID");
			String rolefuncsql = "DELETE FROM SYS_GROUP_MODULE WHERE GROUP_ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),rolefuncsql);
			
			//群组
			DataForm groupdf = new DataForm("SYS_GROUP_MODULE","ID");
			String groupsql = "DELETE FROM SYS_GROUP WHERE ID='"+groupid+"'";
			DaoUtil.execute(af.getConnection(),groupsql);
			
			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();
			return 0;
		}	
	}

}