popedomdbmanager.java

此文档针对开发人员和测试人员。第二章对软件进行了全面的描述。第三章对接口进行了分析。第四章对软件实现的功能进行概述。第五章对软件后续开发实现提出的要求。第六章提出其他一些在软件开发过程中需要注意的问题

package com.ciash.bms.db.manager.popedom.impl;


import java.util.HashMap;
import java.util.Set;
import java.util.Collection;
import com.ciash.common.db.bean.MySqlDBSource;
import java.sql.SQLException;
import com.ciash.bms.config.AppSetting;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import com.ciash.common.db.bean.Parameter;
import java.util.LinkedList;
import com.ciash.bms.entity.Popedom;
import com.ciash.common.db.bean.ConnectionStringBean;
import com.ciash.bms.db.manager.popedom.PopedomDBEditManager;
import com.ciash.bms.db.manager.popedom.PopedomDBFindManager;


/**
 * <p>Title: BMS</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2009</p>
 * <p>Company: Cigarette Ash Inc.</p>
 * @author Cigarette Ash
 * @version 1.0
 */

public class PopedomDBManager
implements PopedomDBFindManager, PopedomDBEditManager {

    private MySqlDBSource dbSource;

	//pop = popedom
    private Parameter pop_pa = new Parameter("pop", null);

    //ceb = canEditBook
    private Parameter ceb_pa = new Parameter("ceb", null);
	//cab = canAddBook
    private Parameter cab_pa = new Parameter("cab", null);
	//cdb = canDelBook
    private Parameter cdb_pa = new Parameter("cdb", null);

	//ceu = canEditUser
    private Parameter ceu_pa = new Parameter("ceu", null);
	//cau = canAddUser
    private Parameter cau_pa = new Parameter("cau", null);
	//cdu = canDelUser
    private Parameter cdu_pa = new Parameter("cdu", null);

	//cep = canEditPop
    private Parameter cep_pa = new Parameter("cep", null);

    public PopedomDBManager(ConnectionStringBean connBean) {
        dbSource = MySqlDBSource.getInstance(connBean);
    }

    // ---------------------------------------------------------------------------------------------
    // 实现自 接口 PopedomEditManager
    /**
     * 添加权限值
     *
     * @param popedom 要添加的权限值对象
     */
    public void addPopedom(Popedom popedom) {
        //设置插入字符串
        dbSource.setInsertCommand("INSERT "
            + "INTO popedom ("
            + "popedom,"
            + "canEditBook, canEditUser,"
            + "canAddBook, canAddUser,"
            + "canDelBook, canDelUser,"
            + "canEditPop"
            + ") "
            + "VALUES ("
            + " @pop,"
            + " @ceb, @ceu,"
            + " @cab, @cau,"
            + " @cdb, @cdu,"
            + " @cep"
            + ")");
        //设置插入变量值
        pop_pa.setValue(popedom.getPopedom());
        ceb_pa.setValue(toTinyString(popedom.isCanEditBook()));
        ceu_pa.setValue(toTinyString(popedom.isCanEditUser()));
        cab_pa.setValue(toTinyString(popedom.isCanAddBook()));
        cau_pa.setValue(toTinyString(popedom.isCanAddUser()));
        cdb_pa.setValue(toTinyString(popedom.isCanDelBook()));
        cdu_pa.setValue(toTinyString(popedom.isCanDelUser()));
        cep_pa.setValue(toTinyString(popedom.isCanEditPop()));
        //设置变量
        dbSource.addInsertParameter(pop_pa);
        dbSource.addInsertParameter(ceb_pa);
        dbSource.addInsertParameter(ceu_pa);
        dbSource.addInsertParameter(cab_pa);
        dbSource.addInsertParameter(cau_pa);
        dbSource.addInsertParameter(cdb_pa);
        dbSource.addInsertParameter(cdu_pa);
        dbSource.addInsertParameter(cep_pa);
        //插入
        dbSource.insert();
    }

    /**
     * 删除指定权限
     *
     * @param popedom 指定的权限
     */
    public void deletePopedom(Popedom popedom) {
        dbSource.setDeleteCommand("DELETE FROM popedom WHERE popedom = @pop");
        pop_pa.setValue(popedom.getPopedom());
        dbSource.addDeleteParameter(pop_pa);
        dbSource.delete();
    }

    public void updatePopedomValue(String oldValue, String newValue) {
            dbSource.setUpdateCommand(
                "UPDATE popedom SET popedom = @newV WHERE popedom = @oldV");
            dbSource.addUpdateParameter(new Parameter("oldV", oldValue));
            dbSource.addUpdateParameter(new Parameter("newV", newValue));
            dbSource.update();
    }

    public void updatePopedom(Popedom popedom) {
        dbSource.setSelectCommand("SELECT * FROM popedom WHERE popedom = @pop");
        pop_pa.setValue(popedom.getPopedom());
        dbSource.addSelectParameter(pop_pa);
        ResultSet result = dbSource.select();
        try {
            if (result.next()) {
                Popedom.updatePopedom(result, popedom);
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    // ---------------------------------------------------------------------------------------------
    // 实现自 接口 PopedomFindManager

    /**
     * 通过权限值查找权限对象
     *
     * @param pop 权限值
     * @return 特定的对象
     */
    public Popedom findByPopedomValue(String pop) {
        dbSource.setSelectCommand("SELECT * FROM popedom WHERE popedom = @pop");
        pop_pa.setValue(pop);
        dbSource.addSelectParameter(pop_pa);
        ResultSet result = dbSource.select();
        try {
            if (result.next()) {
                return Popedom.toPopedom(result);
            }
            return null;
        }
        catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }
    }

    /**
     * 判断某个权限值是否已经存在,该比较在本地执行，并没有在数据库中进行查询
     *
     * @param popedom 要比较的权限对象
     * @return true 存在该权限值
     */
    public boolean isExist(Popedom popedom) {
        return isExist(popedom.getPopedom());
    }

    /**
     * 判断某个权限值是否已经存在,该比较在本地执行，并没有在数据库中进行查询
     *
     * @param pop 要比较的权限值
     * @return true 存在该权限值
     */
    public boolean isExist(String pop) {
        dbSource.setSelectCommand("SELECT * FROM popedom WHERE popedom = @pop");
        pop_pa.setValue(pop);
        dbSource.addSelectParameter(pop_pa);
        ResultSet result = dbSource.select();
        try {
            if (result.next()) {
                return true;
            }
            return false;
        }
        catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
    }

    /**
     * 在表中查找所有结果
     * @return 结果集
     */
    public Collection findAll() {
        dbSource.setSelectCommand("SELECT * FROM popedom");
        ResultSet result = dbSource.select();
        LinkedList resultList = new LinkedList();
        try {
            while (result.next()) {
                resultList.add(Popedom.toPopedom(result));
            }
            return resultList;
        }
        catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }
    }

    private static int toTinyInt(boolean bool){
        if(bool){
            return 1;
        }
        else{
            return 0;
        }
    }

    private static boolean toBoolean(int tinyint){
        if(tinyint == 0){
            return false;
        }
        else{
            return true;
        }
    }

    private static String toTinyString(boolean bool){
        return Integer.toString(toTinyInt(bool));
    }

    public void closeDBSource() {
        this.dbSource.close();
    }

    // ---------------------------------------------------------------------------------------------
    private static PopedomDBManager instance = new PopedomDBManager(AppSetting.connectionStringBean);

    //唯一实例
    //暂时性隐藏
    protected static PopedomDBManager getInstance() {
        return instance;
    }
}