dspthreefeedbbean.java

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

    public void initSelect01()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement01 = new SelectStatement();
        selectStatement01.setConnection(connBean);
        statementmetadata = selectStatement01.getMetaData();
        statementmetadata.setSQL(getSelectSQL01());
        statementmetadata.addTable(getTableName());
        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);
        selectStatement01.setParameter("subareanumb", getSubAreaNumb());
        selectStatement01.setParameter("buildingnumb", getBuildingNumb());
        selectStatement01.setParameter("doornumb", getDoorNumb());
        selectStatement01.setParameter("floornumb", getFloorNumb());
        selectStatement01.setParameter("cellnumb", getCellNumb());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("basefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("otherfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("flag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("cashflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("startdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("enddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("paystartdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("payenddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
    }

    public void initSelect02()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement02 = new SelectStatement();
        selectStatement02.setConnection(connBean);
        statementmetadata = selectStatement02.getMetaData();
        statementmetadata.setSQL(getSelectSQL02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("basefeenum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement02.setParameter("basefeenum", getBaseFeeNum());
        statementmetadata.addColumn("basefeenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("itemfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect03()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement03 = new SelectStatement();
        selectStatement03.setConnection(connBean);
        statementmetadata = selectStatement03.getMetaData();
        statementmetadata.setSQL(getSelectSQL03());
        statementmetadata.addTable(getTableName());
        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);
        selectStatement03.setParameter("subareanumb", getSubAreaNumb());
        selectStatement03.setParameter("buildingnumb", getBuildingNumb());
        selectStatement03.setParameter("doornumb", getDoorNumb());
        selectStatement03.setParameter("floornumb", getFloorNumb());
        selectStatement03.setParameter("cellnumb", getCellNumb());
        statementmetadata.addColumn("tenement", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect04()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement04 = new SelectStatement();
        selectStatement04.setConnection(connBean);
        statementmetadata = selectStatement04.getMetaData();
        statementmetadata.setSQL(getSelectSQL04());
        statementmetadata.addTable(getTableName2());
        statementmetadata.addParameter("feename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement04.setParameter("feename", getFeeName());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("latefeerate", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("feeunit", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("feestandard", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("latefeedays", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
    }

    public String parseIndex(double d)
    {
        d = Math.round(d * 100D);
        String s = String.valueOf(d);
        s = s.substring(0, s.indexOf("."));
        switch(s.length())
        {
        case 0: // '\0'
            s = "0.0";
            break;

        case 1: // '\001'
            s = "0.0" + s;
            break;

        case 2: // '\002'
            s = "0." + s;
            break;

        default:
            s = s.substring(0, s.length() - 2) + "." + s.substring(s.length() - 2);
            break;
        }
        return s;
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusMessage("检索用户应缴纳的三表费用成功");
            setStatusCode(7601);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索用户应缴纳的三表基本费用时出错");
            setStatusCode(7607);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该缴纳的基本费用信息");
                setStatusCode(7608);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void select02()
        throws Exception
    {
        try
        {
            initSelect02();
            selectStatement02.execute();
            result = selectStatement02.getResult();
            result.firstRow();
            setStatusMessage("检索用户应缴纳的三表费用成功");
            setStatusCode(7601);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索用户应缴纳的三表附加费用时出错");
            setStatusCode(7610);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该缴纳的附加费用信息");
                setStatusCode(7611);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void select03()
        throws Exception
    {
        try
        {
            initSelect03();
            selectStatement03.execute();
            result = selectStatement03.getResult();
            result.firstRow();
            setStatusMessage("查询缴纳三表费用用户的姓名成功");
            setStatusCode(7601);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("查询缴纳三表费用用户的姓名时出错");
            setStatusCode(7603);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该缴纳三表费用用户的姓名");
                setStatusCode(7604);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void select04()
        throws Exception
    {
        try
        {
            initSelect04();
            selectStatement04.execute();
            result = selectStatement04.getResult();
            result.firstRow();
            setStatusMessage("查询滞纳收取标准成功");
            setStatusCode(7601);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("查询滞纳收取标准时出错");
            setStatusCode(7614);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有滞纳收取标准");
                setStatusCode(7615);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

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

    public void setBaseFeeNum(String s)
    {
        baseFeeNum = s;
    }

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

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

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

    public void setFeeName(String s)
    {
        feeName = s;
    }

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

    public void setItem(String s)
    {
        item = s;
    }

    public void setLateDays(int i)
    {
        Calendar calendar = Calendar.getInstance();
        calendar.add(2, 1);
        Calendar calendar1 = Calendar.getInstance();
        int j = 0;
        int k = 0;
        if(!((String)vecQ16.elementAt(0)).equals(""))
            k = Integer.parseInt((String)vecQ16.elementAt(0));
        String s = (String)vecQ14.elementAt(i);
        calendar1.set(Integer.parseInt(s.substring(0, 4)), Integer.parseInt(s.substring(5, 7)), Integer.parseInt(s.substring(8, 10)));
        calendar1.add(5, k);
        while(calendar1.before(calendar)) 
        {
            calendar1.add(5, 1);
            j++;
        }
        vecQ17.addElement(String.valueOf(j));
        double d = Double.parseDouble((String)vecQ12.elementAt(i)) * Double.parseDouble((String)vecQ15.elementAt(0)) * (double)j;
        vecQ18.addElement(parseIndex(d));
        d = Double.parseDouble((String)vecQ18.elementAt(i)) + Double.parseDouble((String)vecQ12.elementAt(i));
        vecQ19.addElement(parseIndex(d));
    }

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

    public void setOwnerName(String s)
    {
        ownerName = s;
    }

    public void setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }

    public void setSelectSQL02(String s)
    {
        selectSQL02 = s;
    }

    public void setSelectSQL03(String s)
    {
        selectSQL03 = s;
    }

    public void setSelectSQL04(String s)
    {
        selectSQL04 = s;
    }

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

    public void setTableName1(String s)
    {
        tableName1 = s;
    }

    public void setTableName2(String s)
    {
        tableName2 = s;
    }
}