groupupdatebean.java

eclipse java/jsp 航空管理系统

/** 
 * @(#)GroupUpdateBean.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.sql.DataSource;
import qujl.bean.DBConnectionBean;
import qujl.bean.SQLCommandBean;
import qujl.form.CommonGroupForm;
import qujl.LogWriter;
import zhangchunliang.model.AppMode;

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

    /** 连接数据库的Bean */
    private DBConnectionBean dbConnectionBean;
    
    /** 执行SQL语句的Bean */
    private SQLCommandBean sqlCommandBean;
    
    /** 权限组修改是否成功 */
    private boolean update;
    
    /**
     * 权限组修改是否成功的getter
     * 
     * @return 权限组修改是否成功
     */
    public boolean isUpdate() {
        return this.update;
    }
    
    /**
     * 权限组的信息的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());
    }
    
    /**
     * GroupUpdateBean的构造方法
     * 
     * @throws NamingException
     * @throws SQLException
     */
    public GroupUpdateBean() throws NamingException, SQLException {
        /** dbConnectionBean实例化 */
        this.dbConnectionBean  = new DBConnectionBean();
        
        /** SQLCommandBean实例化 */
        this.sqlCommandBean = new SQLCommandBean();
        
        /** 设置sqlCommandBean属性 */
        this.setSqlCommandBean();   
    }
    
    /**
     * 调用executeGroupUpdateSQL(HttpServletRequest request)方法修改权限组
     * 
     * @param request
     * @throws SQLException
     */
    public void executeGroupUpdateSQL(HttpServletRequest request) 
                                                throws SQLException {
    	
    	AppMode.registerUser();
    	
        /** SQL语句字符串缓冲 */
        StringBuffer sqlStrBuffer;
      
        /** SQL语句字符串 */
        String sqlStr;
        
        /** Values实例化 */
        List values = new ArrayList();
        
        /** SQL语句字符串缓冲实例化 */
        sqlStrBuffer = new StringBuffer(200);
        sqlStrBuffer.append("UPDATE  privgroup SET groupname = ?")
                    .append(", privselect = ?")
                    .append(", privadd = ?")
                    .append(", privdelete = ?")
                    .append(", privupdate = ?")
                    .append(", update_date = ?")
                    .append(", update_user_id= ?")
                    .append(" WHERE groupno = ?");
        
        /** SQL语句字符串实例化 */
        sqlStr = sqlStrBuffer.toString();
        
        /** 设置SqlValues 更新指定权限组*/
        this.sqlCommandBean.setSqlValue(sqlStr);
        
        /** 设置Values */
        values.add(this.commonGroupForm.getGroupName());
        /** 设置权限 */
        String select = "N";
        String add = "N";
        String delete = "N";
        String update = "N";
        for(int i = 0; i < commonGroupForm.getPrivilege().length; 
            i++) {
            if(this.commonGroupForm.
                    getPrivilege()[i].equals("select"))
                select = "Y";
            if(this.commonGroupForm.
                    getPrivilege()[i].equals("add"))
                add = "Y";
            if(this.commonGroupForm.
                    getPrivilege()[i].equals("delete"))
                delete = "Y";
            if(this.commonGroupForm.
                    getPrivilege()[i].equals("update"))
                update="Y";
        }
        values.add(select);
        values.add(add);
        values.add(delete);
        values.add(update);
        values.add(this.commonGroupForm.getDate());
        values.add((String)request.getSession().getAttribute("sid"));
        values.add(this.commonGroupForm.getGroupNo());
        sqlCommandBean.setValues(values);
        
        /** 执行修改权限组操作 */
        try {
             if(this.sqlCommandBean.executeUpdate() == 1) {
                 this.update = true;
             } else {
                 this.update = false;
             }
        } catch (SQLException e) { 
            this.update = false;
            
            /** 记录用户错误日志 */
            LogWriter.writeError(request, this.getClass().getName() 
                  + "."  + "executeGroupUpdateSQL(HttpServletRequest request)"
                  , e.toString());
        } finally {
        	
    		AppMode.loginoutUser();
        	
            /** 释放Connection */
            sqlCommandBean.releaseConn();
        }
    }
}