wateroutdbbean.java

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

            result = selectStatement02.getResult();
            result.firstRow();
            setStatusMessage("统计水费缴纳清单成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索基本费用时出错");
            setStatusCode(8926);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有基本费用信息");
                setStatusCode(8927);
                break;

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

    public void select03()
        throws Exception
    {
        try
        {
            initSelect03();
            selectStatement03.execute();
            result = selectStatement03.getResult();
            result.firstRow();
            setStatusMessage("统计水费缴纳清单成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费周期时出错");
            setStatusCode(8922);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没检索到收费周期");
                setStatusCode(8923);
                break;

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

    public void select04()
        throws Exception
    {
        try
        {
            initSelect04();
            selectStatement04.execute();
            result = selectStatement04.getResult();
            result.firstRow();
            setStatusMessage("统计水费缴纳清单成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费周期时出错");
            setStatusCode(8922);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没检索到收费周期");
                setStatusCode(8923);
                break;

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

    public void select05()
        throws Exception
    {
        try
        {
            initSelect05();
            selectStatement05.execute();
            result = selectStatement05.getResult();
            result.firstRow();
            setStatusMessage("统计水费缴纳清单成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费周期时出错");
            setStatusCode(8922);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没检索到收费周期");
                setStatusCode(8923);
                break;

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

    public void select06()
        throws Exception
    {
        try
        {
            initSelect06();
            selectStatement06.execute();
            result = selectStatement06.getResult();
            result.firstRow();
            setStatusMessage("统计水费缴纳标准成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费周期时出错");
            setStatusCode(8922);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没检索到收费标准");
                setStatusCode(8923);
                break;

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

    public void select07()
        throws Exception
    {
        try
        {
            initSelect07();
            selectStatement07.execute();
            result = selectStatement07.getResult();
            result.firstRow();
            setStatusMessage("统计水表底数成功");
            setStatusCode(8921);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索水表底数时出错");
            setStatusCode(8922);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没检索到水表底数");
                setStatusCode(8923);
                break;

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

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

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

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

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

    public void setEndDate(String s)
    {
        endDate = s;
    }

    public void setFeeCycle(String s)
    {
        feeCycle = s;
    }

    public void setFeeStandard(String s)
    {
        feeStandard = s;
    }

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

    public void setMailContent(String s)
        throws Exception
    {
        try
        {
            File file = new File(s);
            FileWriter filewriter = new FileWriter(file);
            String s1 = "";
            s1 = getTemp();
            filewriter.write(s1);
            filewriter.flush();
        }
        catch(Exception exception)
        {
            throw new Exception("写文件时发生：" + exception.getMessage());
        }
    }

    public void setMeterData(String s)
    {
        meterData = s;
    }

    public void setPayEndDate(String s)
    {
        payEndDate = s;
    }

    public void setPayStartDate(String s)
    {
        payStartDate = 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 setStartDate(String s)
    {
        startDate = s;
    }

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

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

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

    public void setTemp(String s)
    {
        tmp = s;
    }
}