assetrule.java

固定资产管理系统 （1）单用户系统

package Rule;

import java.util.Date;
import java.text.SimpleDateFormat;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.SQLException;
import Bean.assetBean;
import Bean.AtypeBBean;
import Bean.AtypeSBean;
import Conn.DateBase;

/**
 * <p>Title: 固定资产管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: HackCity</p>
 *
 * @author NightEagle
 * @version 1.0
 */
public class assetRule {
    DateBase objDB;
    public assetRule() throws Exception {
        objDB = new DateBase();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //读取系统的当前时间
    public String getIntoDdate() {
        Date BuyTime = new Date();
        SimpleDateFormat DateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
        String buytime = DateFormat.format(BuyTime);
        return buytime;
    }

    //显示资产使用状态
    public Vector onuseUpdate() {
        Vector onuseVec = new Vector();
        onuseVec.addElement("--请选择--");
        onuseVec.addElement("正常");
        onuseVec.addElement("借出");
        onuseVec.addElement("故障");
        onuseVec.addElement("损坏");
        return onuseVec;
    }

    //显示资产查询方式
    public Vector SelectAllComboBox() {
        Vector SelectAllVec = new Vector();
        SelectAllVec.addElement("--请选择--");
        SelectAllVec.addElement("按编号查询");
        SelectAllVec.addElement("按大类别查询");
        SelectAllVec.addElement("按状态查询");
        return SelectAllVec;
    }


    //读取资产大类别
    public Vector isloadAtypeB() throws SQLException {
        Vector loadAtypeBVec = new Vector();
        String loadAtypeBSQL = "select * from AtypeB";
        ResultSet objRS = objDB.objStatement.executeQuery(loadAtypeBSQL);
        loadAtypeBVec.addElement("--请选择--");
        while (objRS.next()) {
            loadAtypeBVec.addElement(objRS.getString("assTypeB"));
        }
        return loadAtypeBVec;
    }

    //读取资料小类别
    public Vector isloadAtypeS(AtypeSBean objAtypeSBean) throws SQLException {
        Vector loadAtypeSVec = new Vector();
        String loadAtypeSSQL = "select asstypes from AtypeS where asstypeb = '" +
                               objAtypeSBean.getAssTypeB() + "'";
        ResultSet objRS = objDB.objStatement.executeQuery(loadAtypeSSQL);
        loadAtypeSVec.addElement("--请选择--");
        while (objRS.next()) {
            loadAtypeSVec.addElement(objRS.getString("assTypeS"));
        }
        return loadAtypeSVec;
    }

    //检查资产编号是否存在
    public boolean isChickAssetID(assetBean objassetBean) throws SQLException {
        String chickAssetID = " select * from asset where assetID = '" +
                              objassetBean.getAssetID() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(chickAssetID);
        if (objRS.next()) {
            return true;
        } else {
            return false;
        }
    }


    //将新资料写入数据库
    public void isSetAsset(assetBean objassetBean) throws SQLException {
        String isSetAssetSQL = " insert into asset values('" +
                               objassetBean.getAssetID() + "','" +
                               objassetBean.getAssetName() + "','" +
                               objassetBean.getAssetTypeB() + "','" +
                               objassetBean.getAssetTypeS() + "','" +
                               objassetBean.getAssetPrice() +
                               "',getdate(),'正常','" +
                               objassetBean.getAssetNotel() + "')";
        objDB.objStatement.executeUpdate(isSetAssetSQL);
    }

    //将更新的资料写入数据库
    public void updateAsset(assetBean objassetBean) throws SQLException {
        String updateAssetSQL = " update asset set assetname = '" +
                                objassetBean.getAssetName() +
                                "',assettypeb = '" + objassetBean.getAssetTypeB() +
                                "',assettypes = '" + objassetBean.getAssetTypeS() +
                                "' ,assetprice = '" +
                                objassetBean.getAssetPrice() +
                                "' ,assetonuse = '" +
                                objassetBean.getAssetOnuse() +
                                "' , assetnotes= '" +
                                objassetBean.getAssetNotel() +
                                "' where assetid = '" + objassetBean.getAssetID() +
                                "' ";
        objDB.objStatement.executeUpdate(updateAssetSQL);
    }

    //资产的表头(通用)
    public Vector listTableHeard() {
        Vector listTableHeardVec = new Vector();
        listTableHeardVec.addElement("资产编号");
        listTableHeardVec.addElement("资产名称");
        listTableHeardVec.addElement("资产类别(大)");
        listTableHeardVec.addElement("资产类别(小)");
        listTableHeardVec.addElement("资产价格");
        listTableHeardVec.addElement("入库日期");
        listTableHeardVec.addElement("资产状态");
        listTableHeardVec.addElement("备注");
        return listTableHeardVec;
    }

    //列出已损坏的产品
    public Vector isChickBreak() throws SQLException {
        Vector BreakVec = new Vector();
        String isChickBreakSQL =
                " select * from asset where  assetonuse = '损坏' ";
        ResultSet objRS = objDB.objStatement.executeQuery(isChickBreakSQL);
        while (objRS.next()) {
            Vector V = new Vector();
            V.addElement(objRS.getString("assetID"));
            V.addElement(objRS.getString("assetName"));
            V.addElement(objRS.getString("assetTypeB"));
            V.addElement(objRS.getString("assetTypeS"));
            V.addElement(objRS.getString("assetPrice"));
            V.addElement(objRS.getString("assetBuydate"));
            V.addElement(objRS.getString("assetOnuse"));
            V.addElement(objRS.getString("assetNotes"));
            BreakVec.addElement(V);
        }
        return BreakVec;
    }

    //查找损坏的产品编号是否存在
    public boolean ischickBreakTure(assetBean objassetBean) throws SQLException {
        String ischickBreakTureSQL = " select * from asset where assetid = '" +
                                     objassetBean.getAssetID() +
                                     "' and assetonuse = '损坏' ";
        ResultSet objRS = objDB.objStatement.executeQuery(ischickBreakTureSQL);
        if (objRS.next()) {
            return true;
        } else {
            return false;
        }
    }

    //将已损坏的资产从数据库中删除
    public void delBreakAsset(assetBean objassetBean) throws SQLException {
        String delBreakAessetSQL = " delete from asset where assetid = '" +
                                   objassetBean.getAssetID() +
                                   "' AND ASSETONUSE = '损坏' ";
        objDB.objStatement.executeUpdate(delBreakAessetSQL);
    }

    //查询所有存在的资产,所有内容
    public Vector SelectAllAsset() throws SQLException {
        Vector SelectAllAssetVec = new Vector();
        String SelectAllAssetSQL = " select * from asset ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAllAssetSQL);
        while (objRS.next()) {
            Vector V = new Vector();
            V.addElement(objRS.getString("assetID"));
            V.addElement(objRS.getString("assetName"));
            V.addElement(objRS.getString("assetTypeB"));
            V.addElement(objRS.getString("assetTypeS"));
            V.addElement(objRS.getString("assetPrice"));
            V.addElement(objRS.getString("assetBuydate"));
            V.addElement(objRS.getString("assetOnuse"));
            V.addElement(objRS.getString("assetNotes"));
            SelectAllAssetVec.addElement(V);
        }
        return SelectAllAssetVec;
    }

    //按编号查询资产
    public Vector SelectAssetAsID(assetBean objassetBean) throws SQLException {
        Vector SelectAssetAsIDVec = new Vector();
        String SelectAssetAsIDSQL = " select * from asset where assetID = '" +
                                    objassetBean.getAssetID() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAssetAsIDSQL);
        while (objRS.next()) {
            Vector V = new Vector();
            V.addElement(objRS.getString("assetID"));
            V.addElement(objRS.getString("assetName"));
            V.addElement(objRS.getString("assetTypeB"));
            V.addElement(objRS.getString("assetTypeS"));
            V.addElement(objRS.getString("assetPrice"));
            V.addElement(objRS.getString("assetBuydate"));
            V.addElement(objRS.getString("assetOnuse"));
            V.addElement(objRS.getString("assetNotes"));
            SelectAssetAsIDVec.addElement(V);
        }
        return SelectAssetAsIDVec;
    }

    //按大类别查询资产
    public Vector SelectAssetAsTypeB(assetBean objassetBean) throws
            SQLException {
        Vector SelectAssetAsTypeB = new Vector();
        String SelectAssetAsTypeBSQL =
                " select * from asset where assetTypeB = '" +
                objassetBean.getAssetTypeB() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAssetAsTypeBSQL);
        while (objRS.next()) {
            Vector V = new Vector();
            V.addElement(objRS.getString("assetID"));
            V.addElement(objRS.getString("assetName"));
            V.addElement(objRS.getString("assetTypeB"));
            V.addElement(objRS.getString("assetTypeS"));
            V.addElement(objRS.getString("assetPrice"));
            V.addElement(objRS.getString("assetBuydate"));
            V.addElement(objRS.getString("assetOnuse"));
            V.addElement(objRS.getString("assetNotes"));
            SelectAssetAsTypeB.addElement(V);
        }
        return SelectAssetAsTypeB;
    }

    //按状态查询资产
    public Vector SelectAsOnuse(assetBean objassetBean) throws SQLException {
        Vector SelectAsOnuseVec = new Vector();
        String SelectAsOnuseSQL =
                " select * from asset where  assetonuse = '"+objassetBean.getAssetOnuse()+"' ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAsOnuseSQL);
        while (objRS.next()) {
            Vector V = new Vector();
            V.addElement(objRS.getString("assetID"));
            V.addElement(objRS.getString("assetName"));
            V.addElement(objRS.getString("assetTypeB"));
            V.addElement(objRS.getString("assetTypeS"));
            V.addElement(objRS.getString("assetPrice"));
            V.addElement(objRS.getString("assetBuydate"));
            V.addElement(objRS.getString("assetOnuse"));
            V.addElement(objRS.getString("assetNotes"));
            SelectAsOnuseVec.addElement(V);
        }
        return SelectAsOnuseVec;
    }


    private void jbInit() throws Exception {
    }


}