userrule.java

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

package Rule;

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


/**
 * <p>Title: 固定资产管理系统</p>
 *
 * <p>这是员工相关后台: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: HackCity</p>
 *
 * @author NightEagle
 * @version 1.0
 */
public class userRule {
    DateBase objDB;
    Vector objpesonelVector;
    public userRule() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        objDB = new DateBase();
        objpesonelVector = new Vector();
    }

    //查找部门编号是否存在.
    public boolean isPesonelIDChick(pesonelBean objpesonelBean) throws
            SQLException {
        String idChickSQL = " select * from usepesonel where pesonelID = '" +
                            objpesonelBean.getPesonelID() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(idChickSQL);
        if (objRS.next()) {
            return true;
        } else {
            return false;
        }
    }

    //添加新员工.
    public void addPesonel(pesonelBean objpesonelBean) throws SQLException {
        String addPesonelSQL = " insert into usepesonel values('" +
                               objpesonelBean.getPesonelID() + "','" +
                               objpesonelBean.getPesonelName() + "','" +
                               objpesonelBean.getPesonel() + "', '未借' ,'" +
                               objpesonelBean.getNotel() + "') ";
        objDB.objStatement.executeUpdate(addPesonelSQL);
    }


    //修改员工资料! 全都修改!
    public void updateAll(pesonelBean objpesonelBean) throws SQLException {
        String updateAllSQL = " update usepesonel set pesonelname = '" +
                              objpesonelBean.getPesonelName() + "',pesonel = '" +
                              objpesonelBean.getPesonel() + "', notes = '" +
                              objpesonelBean.getNotel() +
                              "' where pesonelID = '" +
                              objpesonelBean.getPesonelID() + "' ";
        objDB.objStatement.executeUpdate(updateAllSQL);
    }

    //读取员工部门信息
    public Vector isLoadPesonel() throws
            SQLException {
        String loadPesonelSQL = " select * from pesonelTable";
        ResultSet objRS = objDB.objStatement.executeQuery(loadPesonelSQL);
        objpesonelVector.addElement("--请选择--");
        while (objRS.next()) {
            objpesonelVector.addElement(objRS.getString("pesName"));
        }
        return objpesonelVector;
    }

    //读取员工编号
    public Vector isLoadPesonelName(pesonelBean objPesonelBean) throws
            SQLException {
        Vector loadNameVec = new Vector();
        String loadPesonelNameSQL =
                " select pesonelID from usepesonel where pesonel = '" +
                objPesonelBean.getPesonel() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(loadPesonelNameSQL);
        loadNameVec.addElement("--请选择--");
        while (objRS.next()) {
            loadNameVec.addElement(objRS.getString("pesonelID"));
        }
        return loadNameVec;
    }

    //读取员工姓名
    public Vector isLoadPesonelUseName(pesonelBean objPesonelBean) throws
            SQLException {
        Vector loadPesonelUserName = new Vector();
        String loadPesontelUseNameSQL =
                " select pesonelName from usepesonel where pesonelID = '" +
                objPesonelBean.getPesonelID() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(
                loadPesontelUseNameSQL);
        while (objRS.next()) {
            loadPesonelUserName.addElement(objRS.getString("pesonelName"));
        }
        return loadPesonelUserName;
    }

    //读取员工是否以借资产未还.
    public boolean ischickUsing() throws SQLException {
        String ischickUsingSQL = " select onuse from usepesonel where onuse = '已借' ";
        ResultSet objRS = objDB.objStatement.executeQuery(ischickUsingSQL);
        if (objRS.next()) {
            return true;
        } else {
            return false;
        }
    }

    //删除员工资料
    public void isDelUserPesonel(pesonelBean objPesonelBean) throws
            SQLException {
        String delUserPesonelSQL =
                " delete from usepesonel where pesonelID = '" +
                objPesonelBean.getPesonelID() + "' ";
        objDB.objStatement.executeUpdate(delUserPesonelSQL);
    }

//--------------------------以下均为员工查询相关方法-------------------------------
    //这是员工表的表头
    public Vector tableHeard() {
        Vector heardVector = new Vector();
        heardVector.addElement("部门编号");
        heardVector.addElement("员工姓名");
        heardVector.addElement("员工部门");
        heardVector.addElement("借还状态");
        heardVector.addElement("备注");
        return heardVector;
    }

    //查找方式
    public Vector isSecLike() {
        Vector selectLike = new Vector();
        selectLike.addElement("--请选择--");
        selectLike.addElement("按编号查询");
        selectLike.addElement("按部门查询");
        selectLike.addElement("按已借查询");
        return selectLike;
    }

    //模糊查询,列出所有员工资料.所有表内容
    public Vector SelectEveryoneInfo() throws
            SQLException {
        Vector allInfoVec = new Vector();
        String SelectEveryoneInfoSQL = " select * from usepesonel";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectEveryoneInfoSQL);
        while (objRS.next()) {
            Vector OneOfThelistVec = new Vector();
            OneOfThelistVec.addElement(objRS.getString("pesonelID"));
            OneOfThelistVec.addElement(objRS.getString("pesonelName"));
            OneOfThelistVec.addElement(objRS.getString("pesonel"));
            OneOfThelistVec.addElement(objRS.getString("onuse"));
            OneOfThelistVec.addElement(objRS.getString("notes"));
            allInfoVec.addElement(OneOfThelistVec);
        }
        return allInfoVec;
    }

    //按编号查询
    public Vector SelectAsID(pesonelBean objPesonelBean) throws SQLException {
        Vector secAsIDVec = new Vector();
        String SelectAsIDSQL = " select * from usepesonel where pesonelID = '" +
                               objPesonelBean.getPesonelID() + "'  ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAsIDSQL);
        while (objRS.next()) {
            Vector v = new Vector();
            v.addElement(objRS.getString("pesonelID"));
            v.addElement(objRS.getString("pesonelName"));
            v.addElement(objRS.getString("pesonel"));
            v.addElement(objRS.getString("onuse"));
            v.addElement(objRS.getString("notes"));
            secAsIDVec.addElement(v);
        }
        return secAsIDVec;
    }

    //按部门查询
    public Vector SelectAsPesonel(pesonelBean objPesonelBean) throws
            SQLException {
        Vector secAsPesonelVec = new Vector();
        String SelectAsPesonelSQL =
                " select * from usepesonel where pesonel = '" +
                objPesonelBean.getPesonel() + "' ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAsPesonelSQL);
        while (objRS.next()) {
            Vector v = new Vector();
            v.addElement(objRS.getString("pesonelID"));
            v.addElement(objRS.getString("pesonelName"));
            v.addElement(objRS.getString("pesonel"));
            v.addElement(objRS.getString("onuse"));
            v.addElement(objRS.getString("notes"));
            secAsPesonelVec.addElement(v);
        }
        return secAsPesonelVec;
    }

    //按已借状态查询
    public Vector SelectAsOnuse(pesonelBean objPesonelBean) throws
            SQLException {
        Vector secAsOnuseVec = new Vector();
        String SelectAsOnuseSQL =
                " select * from usepesonel where onuse = '"+objPesonelBean.getOnuse()+"' ";
        ResultSet objRS = objDB.objStatement.executeQuery(SelectAsOnuseSQL);
        while (objRS.next()) {
            Vector v = new Vector();
            v.addElement(objRS.getString("pesonelID"));
            v.addElement(objRS.getString("pesonelName"));
            v.addElement(objRS.getString("pesonel"));
            v.addElement(objRS.getString("onuse"));
            v.addElement(objRS.getString("notes"));
            secAsOnuseVec.addElement(v);
        }
        return secAsOnuseVec;
    }
}