genusdbmanager.java

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

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

import com.ciash.bms.db.manager.genus.GenusDBEditManager;
import com.ciash.bms.db.manager.genus.GenusDBFindManager;
import com.ciash.bms.entity.BookGenus;
import com.ciash.common.db.bean.MySqlDBSource;
import com.ciash.bms.config.AppSetting;
import com.ciash.common.db.bean.ConnectionStringBean;
import com.ciash.common.db.bean.Parameter;
import java.util.Collection;
import java.sql.ResultSet;
import java.sql.*;
import java.util.Vector;

/**
 * <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 GenusDBManager
implements GenusDBEditManager,GenusDBFindManager{

	MySqlDBSource dbSource;
	// ---------------------------------------------------------------------------------------------
    // 插入语句块
    private String inserCommand = "INSERT INTO book_genus ("
        + "book_genus"
        + ")"
        + "VALUES ("
        + "@desc"
        + ")";
    // ---------------------------------------------------------------------------------------------
    // 变量块
    Parameter desc_pa = new Parameter("desc", null);

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

    public Collection findByDesc(String desc) {
        dbSource.setSelectCommand("SELECT * FROM book_genus WHERE book_genus_info = @desc");
        desc_pa.setValue(desc);
        ResultSet result = dbSource.select();
        Vector v = new Vector();
        try {
            while (result.next()) {
                v.add(BookGenus.toGenus(result));
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }
        return v;
    }

    public Collection findAll(){
        dbSource.setSelectCommand("SELECT * FROM book_genus");
        ResultSet result = dbSource.select();
        Vector v = new Vector();
        try {
            while (result.next()) {
                v.add(BookGenus.toGenus(result));
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }
        return v;
    }

    public void add(BookGenus g) {
        dbSource.setInsertCommand(inserCommand);
        desc_pa.setValue(g.getDescription());
        dbSource.addInsertParameter(desc_pa);
        dbSource.insert();
    }

    public void delete(BookGenus g) {
    	dbSource.setDeleteCommand("DELETE FROM book_genus WHERE book_genus = @desc");
        desc_pa.setValue(g.getDescription());
        dbSource.addDeleteParameter(desc_pa);
        dbSource.delete();
    }

    public void update(BookGenus g) {
    	delete(g);
    	add(g);
    }

    /**
    * 检查数据库中是否有指定的图书类别信息
    *
    * @param book 指定的图书
    * @return true 数据库中没有该类别的信息
    */
    public boolean isExist(BookGenus g){
        return isExist(g.getDescription());
    }

    private boolean isExist(String v) {
        dbSource.setSelectCommand("SELECT * FROM book_genus WHERE book_genus = @desc");
        desc_pa.setValue(v);
        dbSource.addSelectParameter(desc_pa);
        ResultSet result = dbSource.select();
        try {
            if (result.next()) {
                return true;
            }
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }
        return false;
    }
    // ---------------------------------------------------------------------------------------------
    // 获得书籍类别管理器的唯一实例
    private static GenusDBManager instance = new GenusDBManager(AppSetting.connectionStringBean);
    /**
     * 获得书籍类别管理器的唯一实例
     *
     * @return 书籍类别管理器的唯一实例
     */
    public static GenusDBManager getInstance(){
        return instance;
    }
    // ---------------------------------------------------------------------------------------------
}