countwaterfeedbbean.java

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

            initSelect06();
            selectStatement06.execute();
            result = selectStatement06.getResult();
            result.firstRow();
            setStatusMessage("检索本单元水表编号成功");
            setStatusCode(8678);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索本单元水表编号出错");
            setStatusCode(8679);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有本单元水表编号");
                setStatusCode(8681);
                break;

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

    public void select07()
        throws Exception
    {
        try
        {
            initSelect07();
            selectStatement07.execute();
            result = selectStatement07.getResult();
            result.firstRow();
            setStatusMessage("检索水表抄表记录本单元抄表记录成功");
            setStatusCode(8683);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索水表抄表记录本单元抄表记录出错");
            setStatusCode(8684);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有本单元水表抄表记录");
                setStatusCode(8685);
                break;

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

    public void select08()
        throws Exception
    {
        try
        {
            initSelect08();
            selectStatement08.execute();
            result = selectStatement08.getResult();
            result.firstRow();
            setStatusMessage("检索水表抄表记录本周期抄表读数成功");
            setStatusCode(8688);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索水表抄表记录本周期抄表读数出错");
            setStatusCode(8689);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有水表抄表记录本周期抄表读数");
                setStatusCode(8691);
                break;

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

    public void select09()
        throws Exception
    {
        try
        {
            initSelect09();
            selectStatement09.execute();
            result = selectStatement09.getResult();
            result.firstRow();
            setStatusMessage("检索水表抄表记录本周期前水表抄表读数最大数成功");
            setStatusCode(8694);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索水表抄表记录本周期前水表抄表读数最大数出错");
            setStatusCode(8695);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有水表抄表记录本周期前水表抄表读数最大数");
                setStatusCode(8696);
                break;

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

    public void select10()
        throws Exception
    {
        try
        {
            initSelect10();
            selectStatement10.execute();
            result = selectStatement10.getResult();
            result.firstRow();
            setStatusMessage("检索分摊项目表成功");
            setStatusCode(8698);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索分摊项目表出错");
            setStatusCode(8699);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("本期没有水费分摊项目信息");
                setStatusCode(8701);
                break;

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

    public void select15()
        throws Exception
    {
        try
        {
            initSelect15();
            selectStatement15.execute();
            result = selectStatement15.getResult();
            result.firstRow();
            setStatusMessage("检索水费基本表成功");
            setStatusCode(8712);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索水费基本表出错");
            setStatusCode(8713);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有查询到信息");
                setStatusCode(8714);
                break;

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

    public void setAllfee(String s)
    {
        allfee = s;
    }

    public void setBasefee(String s)
    {
        basefee = s;
    }

    public void setBasefeenum(String s)
    {
        basefeenum = s;
    }

    public void setBuildingnumb(String s)
    {
        buildingnumb = s;
    }

    public void setCashflag(String s)
    {
        cashflag = s;
    }

    public void setCellnumb(String s)
    {
        cellnumb = s;
    }

    public void setCountby(int i)
    {
        countby = i;
    }

    public void setDelflag(String s)
    {
        delflag = s;
    }

    public void setDoornumb(String s)
    {
        doornumb = s;
    }

    public void setFeecycle(String s)
    {
        feecycle = s;
    }

    public void setFeename(String s)
    {
        feename = s;
    }

    public void setFlag1(String s)
    {
        flag1 = s;
    }

    public void setFloornumb(String s)
    {
        floornumb = s;
    }

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

    public void setInsertSQL02(String s)
    {
        insertSQL02 = s;
    }

    public void setInsertSQL03(String s)
    {
        insertSQL03 = s;
    }

    public void setItemfee(String s)
    {
        itemfee = s;
    }

    public void setItemnum(String s)
    {
        itemnum = s;
    }

    public void setMeterdata(String s)
    {
        meterdata = s;
    }

    public void setMeternum(String s)
    {
        meternum = s;
    }

    public void setOtherfee(String s)
    {
        otherfee = 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 setSelectSQL05(String s)
    {
        selectSQL05 = s;
    }

    public void setSelectSQL06(String s)
    {
        selectSQL06 = s;
    }

    public void setSelectSQL07(String s)
    {
        selectSQL07 = s;
    }

    public void setSelectSQL08(String s)
    {
        selectSQL08 = s;
    }

    public void setSelectSQL09(String s)
    {
        selectSQL09 = s;
    }

    public void setSelectSQL10(String s)
    {
        selectSQL10 = s;
    }

    public void setSelectSQL15(String s)
    {
        selectSQL15 = s;
    }

    public void setSubareanumb(String s)
    {
        subareanumb = s;
    }

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

    public void update01()
        throws Exception
    {
        try
        {
            initUpdate01();
            updateStatement01.execute();
            setStatusCode(8141);
            setStatusMessage("成功修改水费分摊合计和合计费用");
        }
        catch(DataException dataexception)
        {
            setStatusCode(8142);
            setStatusMessage("修改水费分摊合计和合计费用失败--" + dataexception.getMessage());
            throw new Exception(getStatusMessage());
        }
    }
}