recordrule.java

一个不错的固定资产管理系统,jbuilder和SQL环境下制作

package Rule;

import Conn.DateBase;
import Bean.recordBean;
import Bean.assetBean;
import Bean.pesonelBean;
import java.util.Vector;
import java.sql.*;

/**
 * <p>Title: 固定资产管理系统</p>
 *
 * <p>这是借出/归还后台 </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: HackCity</p>
 *
 * @author NightEagle
 * @version 1.0
 */
public class recordRule {
    DateBase objDB;
    public recordRule() throws Exception {
        objDB = new DateBase();
    }

    //读出可用的资产编号
    public Vector isLoadassetID() throws SQLException {
        Vector loadAssetIDVec = new Vector();
        String isLoadassetIDSQL =
                "select assetID from asset where assetonuse = '正常'";
        ResultSet objRS = objDB.objStatement.executeQuery(isLoadassetIDSQL);
        loadAssetIDVec.addElement("--请选择--");
        while (objRS.next()) {
            //    Vector v = new Vector();
            loadAssetIDVec.addElement(objRS.getString("assetID"));
            // loadAssetIDVec.addElement(v);
        }
        return loadAssetIDVec;
    }

    //将借出的资产写入数据库
    public void isAssetLendToDB(recordBean objRecordBean) throws SQLException {
        String isAssetLendToDB_SQL =
                "insert into record (useID,assetID,useDate,useWay,adminName,notel) values ('" +
                objRecordBean.getUseID() +
                "','" + objRecordBean.getAssetID() + "' , getdate(),'" +
                objRecordBean.getUseWay() + "','" + objRecordBean.getAdminName() +
                "','" + objRecordBean.getNotel() + "') ";
        objDB.objStatement.executeQuery(isAssetLendToDB_SQL);
    }

    //将已借过的用户借还状态设为已借!
    public void isSetusepesonelUseing(pesonelBean objPesonelBean) throws
            SQLException {
        String isSetusepesonelUseingSQL =
                " update usepesonel set onuse = '已借' where pesonelID = '" +
                objPesonelBean.getPesonelID() + "' ";
        objDB.objStatement.executeUpdate(isSetusepesonelUseingSQL);
    }

    //将已借出的资产改为使用中!
    public void isSetAssetUsing(assetBean objAssetBean) throws SQLException {
        String isSetAssetUsingSQL =
                " update asset set assetonuse = '借出' where assetID = '" +
                objAssetBean.getAssetID() + "' ";
        objDB.objStatement.executeQuery(isSetAssetUsingSQL);
    }

    //将归还时间写入数据库
    public void setReturnTime(recordBean objRecordBean) throws
            SQLException {
        String setReturnTimeSQL =
                " update RECORD set returndate = getDate() where useid = '" +
                objRecordBean.getUseID() + "' and assetID = '" +
                objRecordBean.getAssetID() + "' ";
        objDB.objStatement.executeUpdate(setReturnTimeSQL);
    }


    //--------------------------归还借出的资产!!---------------------------------
    //将已借过的用户借还状态设为未借!
    public void isSetusepesonelReturn(pesonelBean objPesonelBean) throws
            SQLException {
        String isSetusepesonelReturnSQL =
                " update usepesonel set onuse = '未借' where pesonelID = '" +
                objPesonelBean.getPesonelID() + "' ";

        objDB.objStatement.executeUpdate(isSetusepesonelReturnSQL);
    }

    //将已借出的资产改为正常中!
    public void isSetAssetReturn(assetBean objAssetBean) throws SQLException {
        String isSetAssetReturnSQL =
                " update asset set assetonuse = '正常' where assetID = '" +
                objAssetBean.getAssetID() + "' ";

        objDB.objStatement.executeQuery(isSetAssetReturnSQL);
    }

    //查询借还记录
    public Vector isSelectLog() throws SQLException {
        Vector HeardVec = new Vector();
        String isSelectLogSQL = "select * from record";
        ResultSet objRS = objDB.objStatement.executeQuery(isSelectLogSQL);
        while (objRS.next()) {
            Vector v = new Vector();
            v.addElement(objRS.getString("useID"));
            v.addElement(objRS.getString("assetID"));
            v.addElement(objRS.getString("useDate"));
            v.addElement(objRS.getString("returnDate"));
            v.addElement(objRS.getString("useWay"));
            v.addElement(objRS.getString("adminName"));
            v.addElement(objRS.getString("notel"));
            HeardVec.addElement(v);
        }
        return HeardVec;
    }

    //首页表头
    public Vector df_TableHeard() {
        Vector V = new Vector();
        V.addElement("员工编号");
        V.addElement("资产编号");
        V.addElement("借出日期");
        V.addElement("归还日期");
        V.addElement("用途");
        V.addElement("管理员");
        V.addElement("备注");
        return V;
    }


}