countelectricfeedbbean.java

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

            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult08()
        throws Exception
    {
        try
        {
            vecM1.removeAllElements();
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecM1.addElement(result.getColumnValueToString("meterdata").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8847);
            setStatusMessage("从电表抄表记录获取本周期抄表记录时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult09()
        throws Exception
    {
        try
        {
            vecZ1.removeAllElements();
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecZ1.addElement(result.getColumnValueToString("meterdata"));
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8853);
            setStatusMessage("从电表抄表记录获取本周期前电表抄表读数最大数时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult10()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecS1.addElement(result.getColumnValueToString("number").trim());
                vecS4.addElement(result.getColumnValueToString("name").trim());
                vecS2.addElement(result.getColumnValueToString("flag2").trim());
                vecS3.addElement(result.getColumnValueToString("value1").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8857);
            setStatusMessage("从分摊项目表获取本期电费分摊项目信息时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult11()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecA1.addElement(result.getColumnValueToString("meternum").trim());
                vecA2.addElement(result.getColumnValueToString("flag1").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8881);
            setStatusMessage("保存检索分摊设置表结果数据时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult12()
        throws Exception
    {
        try
        {
            vecP1.removeAllElements();
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecP1.addElement(result.getColumnValueToString("lmeternum").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8885);
            setStatusMessage("保存检索分摊设置表结果数据时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult13()
        throws Exception
    {
        try
        {
            vecF.removeAllElements();
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecF.addElement(result.getColumnValueToString("flag1").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8889);
            setStatusMessage("保存检索分摊设置表结果数据时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult14()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecB.addElement(result.getColumnValueToString("lmeternum").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8894);
            setStatusMessage("保存检索分摊设置表结果数据时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult15()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecCount.addElement(result.getColumnValueToString("number").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(8901);
            setStatusMessage("保存检索电费基本表结果数据时出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
        finally
        {
            closeResultSet();
        }
    }

    public String getDelflag()
    {
        return delflag;
    }

    public String getDoornumb()
    {
        return doornumb;
    }

    public String getFeecycle()
    {
        return feecycle;
    }

    public String getFeename()
    {
        return feename;
    }

    public String getFlag1()
    {
        return flag1;
    }

    public String getFloornumb()
    {
        return floornumb;
    }

    public String getInsertSQL01()
    {
        return insertSQL01;
    }

    public String getInsertSQL02()
    {
        return insertSQL02;
    }

    public String getInsertSQL03()
    {
        return insertSQL03;
    }

    public String getItemfee()
    {
        return itemfee;
    }

    public String getItemnum()
    {
        return itemnum;
    }

    public String getMeterdata()
    {
        return meterdata;
    }

    public String getMeternum()
    {
        return meternum;
    }

    public String getOtherfee()
    {
        return otherfee;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public String getSelectSQL02()
    {
        return selectSQL02;
    }

    public String getSelectSQL03()
    {
        return selectSQL03;
    }

    public String getSelectSQL04()
    {
        return selectSQL04;
    }

    public String getSelectSQL05()
    {
        return selectSQL05;
    }

    public String getSelectSQL06()
    {
        return selectSQL06;
    }

    public String getSelectSQL07()
    {
        return selectSQL07;
    }

    public String getSelectSQL08()
    {
        return selectSQL08;
    }

    public String getSelectSQL09()
    {
        return selectSQL09;
    }

    public String getSelectSQL10()
    {
        return selectSQL10;
    }

    public String getSelectSQL11()
    {
        return selectSQL11;
    }

    public String getSelectSQL12()
    {
        return selectSQL12;
    }

    public String getSelectSQL13()
    {
        return selectSQL13;
    }

    public String getSelectSQL14()
    {
        return selectSQL14;
    }

    public String getSelectSQL15()
    {
        return selectSQL15;
    }

    public String getSubareanumb()
    {
        return subareanumb;
    }