groupdeletebean.java

eclipse java/jsp 航空管理系统

/** 
 * @(#)GroupInsertBean.java 2.0 2005/04/30  
 * <p>copyright:    Copyright 东软 国际合作事业部版权所有</p>
 * <p>company:      neusoft</p>
 * <p>time:         2005.04.30</p>
 */
package qujl.bean;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.StringTokenizer;
import javax.naming.NamingException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.jstl.sql.Result;
import javax.sql.DataSource;
import qujl.bean.DBConnectionBean;
import qujl.bean.SQLCommandBean;
import qujl.LogWriter;
import qujl.form.CommonGroupForm;
import zhangchunliang.model.AppMode;

/**
 * 处理删除组的Bean.
 * 
 * @author    曲金龙 [e-mail]    
 * @version   2.0， 2005/04/30
 */
public class GroupDeleteBean implements Serializable {
    /** 权限组的信息 */
    private CommonGroupForm commonGroupForm;

    /** 连接数据库的Bean */
    private DBConnectionBean dbConnectionBean;
    
    /** 执行SQL语句的Bean */
    private SQLCommandBean sqlCommandBean;
    
    /** 权限组是否还有成员 */
    private boolean empty;
    
    /** 权限组是否删除成功 */
    private boolean delete;
    
    /**
     * 权限组是否还有成员的getter
     * 
     * @return 权限组是否还有成员
     */
    public boolean isEmpty() {
        return this.empty;
    }
    
    /**
     * 权限组是否删除成功的getter
     * 
     * @return 权限组是否删除成功
     */
    public boolean isDelete() {
        return this.delete;
    }
    
    /**
     * 权限组的信息的setter
     * 
     * @param commonGroupForm 添加权限组的信息
     */
    public void setCommonGroupForm(CommonGroupForm commonGroupForm) {
        this.commonGroupForm = commonGroupForm;
    }
    
    /**
     * 执行SQL语句的Bean的setter
     * 
     * @throws SQLException
     */
    private void setSqlCommandBean() throws SQLException {
        /** 从连接池中取得一个连接 */
        DataSource dataSource = this.dbConnectionBean.getDataSource();
        
        /** 设置Connection */
        this.sqlCommandBean.setConnection(dataSource.getConnection());
    }
    
    /**
     * GroupDeleteBean的构造方法
     * 
     * @throws NamingException
     * @throws SQLException
     */
    public GroupDeleteBean() throws NamingException, SQLException {
        /** dbConnectionBean实例化 */
        this.dbConnectionBean  = new DBConnectionBean();
        
        /** SQLCommandBean实例化 */
        this.sqlCommandBean = new SQLCommandBean();
        
        /** 设置sqlCommandBean属性 */
        this.setSqlCommandBean();   
    }
    
    /**
     * 调用executeGroupDeleteSQL(HttpServletRequest request)方法删除权限组
     * 
     * @param request
     * @throws SQLException
     */
    public void executeGroupDeleteSQL(HttpServletRequest request) 
                                                throws SQLException {
    	
    	AppMode.registerUser();

    	
        /** SQL语句字符串缓冲 */
        StringBuffer sqlStrBuffer;
        
        /** SQL语句字符串 */
        String sqlStr;

        /** 对从stuff表中取出的权限串分解的StringTokenizer变量 */
        StringTokenizer analysis;
        
        /** SQL语句操作的结果集 */
        Result result = null;
        
        /** Values实例化 */
        List values = new ArrayList();
        
        try {
            /** 设置SqlValues 查询指定权限组*/
            this.sqlCommandBean.setSqlValue("SELECT groupstring FROM stuff");
            
            /** 取得查询结果集 */
            result = this.sqlCommandBean.executeQuery();  
            
            /** 取得结果行数 */
            int lineNum = result.getRowCount();
            
            /** 查询权限组内是否有成员 */
            for(int index = 0; index < lineNum; index++) {
                analysis = new StringTokenizer(
                        result.getRowsByIndex()[index][0].toString(), ";");
                while(analysis.hasMoreTokens()) {
                    if(analysis.nextToken()
                            .equals(this.commonGroupForm.getGroupNo())) {
                        this.empty = false;
                        return;
                    } 
                }
            }
            
            this.empty = true;
            
            /** SQL语句字符串缓冲实例化 */
            sqlStrBuffer = new StringBuffer(200);
            sqlStrBuffer.append("DELETE FROM privgroup WHERE groupno=?");
            
            /** SQL语句字符串实例化 */
            sqlStr = sqlStrBuffer.toString();
            
            /** 设置sqlValues */
            this.sqlCommandBean.setSqlValue(sqlStr);
            
            /** 设置Values */
            values.add(this.commonGroupForm.getGroupNo());
            this.sqlCommandBean.setValues(values);
            
            /** 执行删除组操作 */
            if(sqlCommandBean.executeUpdate() == 1) {
                this.delete = true;
            } else {
                this.delete =false;
            }
        
        } catch (SQLException e) {
            this.delete = false;
            
            /** 记录用户错误日志 */
            LogWriter.writeError(request, this.getClass().getName() 
                    + "."  + "executeGroupDeleteSQL(HttpServletRequest request)"
                    , e.toString());
        } finally {
        	
        	AppMode.loginoutUser();
        	
            /** 释放Connection */
            this.sqlCommandBean.releaseConn();
        }
    }
}