addotherfeedbbean.java

JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的借鉴。

    protected void initInsert01()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        insertStatement01 = new SQLStatement();
        insertStatement01.setConnection(connBean);
        statementmetadata = insertStatement01.getMetaData();
        statementmetadata.setSQL(getInsertSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("nubmer", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 1);
        statementmetadata.addParameter("feenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        if(getCycleFlag().equals("1"))
            statementmetadata.addParameter("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("payname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("optionname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("paydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("paytime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
        statementmetadata.addParameter("basefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("otherfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("latefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        if(Integer.parseInt(getItemNum()) > 3 && Integer.parseInt(getItemNum()) <= 6)
        {
            statementmetadata.addParameter("salerate", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
            statementmetadata.addParameter("salefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        }
        statementmetadata.addParameter("note", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        insertStatement01.setParameter("nubmer", new Integer(getNumber()));
        insertStatement01.setParameter("feenum", new Integer(getItemNum()));
        if(getCycleFlag().equals("1"))
            insertStatement01.setParameter("cyclenum", new Integer(getCycleNum()));
        insertStatement01.setParameter("subareanumb", getSubAreaNumb());
        insertStatement01.setParameter("buildingnumb", getBuildingNumb());
        insertStatement01.setParameter("doornumb", getDoorNumb());
        insertStatement01.setParameter("floornumb", getFloorNumb());
        insertStatement01.setParameter("cellnumb", getCellNumb());
        insertStatement01.setParameter("payname", getPayName());
        insertStatement01.setParameter("optionname", getOptionName());
        insertStatement01.setParameter("paydate", Date.valueOf(getPayDate()));
        insertStatement01.setParameter("paytime", Time.valueOf(getPayTime()));
        insertStatement01.setParameter("basefee", new Double(getBaseFee()));
        insertStatement01.setParameter("otherfee", new Double(getOtherFee()));
        insertStatement01.setParameter("latefee", new Double(getLateFee()));
        insertStatement01.setParameter("allfee", new Double(getRealFee()));
        if(Integer.parseInt(getItemNum()) > 3 && Integer.parseInt(getItemNum()) <= 6)
        {
            insertStatement01.setParameter("salerate", new Double(getSaleRate()));
            insertStatement01.setParameter("salefee", new Double(getSaleFee()));
        }
        insertStatement01.setParameter("note", getNote());
        insertStatement01.setParameter("delflag", getDelFlag());
    }

    protected void initUpdate01()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement01 = new SQLStatement();
        updateStatement01.setConnection(connBean);
        statementmetadata = updateStatement01.getMetaData();
        statementmetadata.setSQL(getUpdateSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("cashflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("feeunits", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 4);
        statementmetadata.addParameter("fee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("latedays", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("latefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        updateStatement01.setParameter("cashflag", getCashFlag());
        updateStatement01.setParameter("feeunits", new Double(getFeeUnits()));
        updateStatement01.setParameter("fee", new Double(getBaseFee()));
        updateStatement01.setParameter("latedays", new Integer(getLateDays()));
        updateStatement01.setParameter("latefee", new Double(getLateFee()));
        updateStatement01.setParameter("allfee", new Double(getRealFee()));
        updateStatement01.setParameter("number", new Integer(getFeeLogNum()));
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusMessage("成功支付其他费用");
            setStatusCode(7661);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("支付其他费用写日志时出错");
            setStatusCode(7664);
            throw dataexception;
        }
    }

    public void setAllBaseFee(String s)
    {
        allBaseFee = s;
    }

    public void setAllFee(String s)
    {
        allFee = s;
    }

    public void setAllLateFee(String s)
    {
        allLateFee = s;
    }

    public void setBaseFee(String s)
    {
        fee = s;
    }

    public void setBuildingNumb(String s)
    {
        buildingNumb = s;
    }

    public void setCashFlag(String s)
    {
        cashFlag = s;
    }

    public void setCellNumb(String s)
    {
        cellNumb = s;
    }

    public void setCycleFlag(String s)
    {
        cycleFlag = s;
    }

    public void setCycleNum(String s)
    {
        cycleNum = s;
    }

    public void setDelFlag(String s)
    {
        delFlag = s;
    }

    public void setDoorNumb(String s)
    {
        doorNumb = s;
    }

    public void setFeeLogNum(String s)
    {
        feeLogNum = s;
    }

    public void setFeeUnits(String s)
    {
        feeUnits = s;
    }

    public void setFloorNumb(String s)
    {
        floorNumb = s;
    }

    public void setInsertSQL01(String s)
    {
        insertSQL01 = s;
    }

    public void setItemNum(String s)
    {
        itemNum = s;
    }

    public void setLateDays(String s)
    {
        lateDays = s;
    }

    public void setLateFee(String s)
    {
        lateFee = s;
    }

    public void setNote(String s)
    {
        note = s;
    }

    public void setOptionName(String s)
    {
        optionName = s;
    }

    public void setOtherFee(String s)
    {
        otherFee = s;
    }

    public void setPayDate(String s)
    {
        payDate = s;
    }

    public void setPayName(String s)
    {
        payName = s;
    }

    public void setPayTime(String s)
    {
        payTime = s;
    }

    public void setRealFee(String s)
    {
        realFee = s;
    }

    public void setSaleFee(String s)
    {
        saleFee = s;
    }

    public void setSaleRate(String s)
    {
        saleRate = s;
    }

    public void setSubAreaNumb(String s)
    {
        subAreaNumb = s;
    }

    public void setUpdateSQL01(String s)
    {
        updateSQL01 = s;
    }

    public void update01()
        throws Exception
    {
        try
        {
            initUpdate01();
            updateStatement01.execute();
            setStatusMessage("成功支付其他费用");
            setStatusCode(7661);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("支付其他费用时出错");
            setStatusCode(7662);
            throw dataexception;
        }
    }
}