recordrule.java~27~

一个不错的固定资产管理系统,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);
    }
    //归还借出的资产!!
}