groupinfobean.java

eclipse java/jsp 航空管理系统

/** 
 * @(#)GroupInfoBean.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 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 GroupInfoBean implements Serializable {
    /** 权限组的信息 */
    private CommonGroupForm commonGroupForm;

    /** 连接数据库的Bean */
    private DBConnectionBean dbConnectionBean;
    
    /** 执行SQL语句的Bean */
    private SQLCommandBean sqlCommandBean;
    
    /** SQL语句操作的结果集 */
    Result result;
    
    /**
     * SQL语句操作的结果集的getter
     * 
     * @return result
     */
    public Result getResult() {
        return this.result;
    }
    
    /**
     * 权限组的信息的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());
    }
    
    /**
     * GroupInfoBean的构造方法
     * 
     * @throws NamingException
     * @throws SQLException
     */
    public GroupInfoBean() throws NamingException, SQLException {
        /** dbConnectionBean实例化 */
        this.dbConnectionBean  = new DBConnectionBean();
        
        /** SQLCommandBean实例化 */
        this.sqlCommandBean = new SQLCommandBean();
        
        /** 设置sqlCommandBean属性 */
        this.setSqlCommandBean();   
    }
    
    /**
     * 调用executeGroupInfoSQL(HttpServletRequest request)方法添加权限组
     * 
     * @param request
     * @param isGroupNoUsed 使用组号查询
     * @throws SQLException
     */
    public void executeGroupInfoSQL(HttpServletRequest request, 
                            boolean isGroupNoUsed) throws SQLException {
    	
    	AppMode.registerUser();
    	
        /** SQL语句字符串缓冲 */
        StringBuffer sqlStrBuffer;
        
        /** SQL语句字符串 */
        String sqlStr;
        
        /** Values实例化 */
        List values = new ArrayList();
  
        /** SQL语句字符串缓冲实例化 */
        sqlStrBuffer = new StringBuffer(200);
        sqlStrBuffer.append("SELECT * FROM privgroup WHERE ");
        
        /** 判断查询方式 */
        if(isGroupNoUsed) {
            sqlStrBuffer.append("groupNo=")
                        .append(this.commonGroupForm.getGroupNo());
        } else {
            sqlStrBuffer.append("groupNo NOT IN (0, 1, 2);");
        }
        
        /** SQL语句字符串实例化 */
        sqlStr = sqlStrBuffer.toString();
        
        /** 设置sqlValues 查询指定权限组*/
        this.sqlCommandBean.setSqlValue(sqlStr);
        
        /** 设置values */
        this.sqlCommandBean.setValues(values);
        
        /** 查询权限组信息 */
        try {
            this.result = sqlCommandBean.executeQuery();
        } catch(Exception e) {
            /** 记录用户错误日志 */
            LogWriter.writeError(request, this.getClass().getName() 
                  + "."  + "executeGroupInfoSQL(HttpServletRequest request)"
                  , e.toString());
        } finally {
        	
        	AppMode.loginoutUser();
        	
            /** 释放Connection */
            this.sqlCommandBean.releaseConn();
        }
    }
}