treedbbean.java

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

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   TreeDBBean.java

package baseinfo;

import com.ibm.db.*;
import common.ParentDBBean;
import java.util.Vector;

public class TreeDBBean extends ParentDBBean
{

    protected String tablename1;
    protected String tablename2;
    protected String tablename3;
    protected String tablename4;
    protected String tablename5;
    protected String fixturenumb;
    protected String apparatusnumb1;
    protected String apparatusnumb2;
    protected String apparatusnumb3;
    protected String apparatuskind;
    protected String anumber;
    protected String subareanumb;
    protected String subareanumb1;
    protected String buildingnumb1;
    protected String doornumb1;
    protected String floornumb1;
    protected String cellnumb1;
    protected String delflag;
    protected String number2;
    Vector vfixturenumb;
    Vector vapparatusnumb1;
    Vector vapparatusnumb2;
    Vector vapparatusnumb3;
    Vector vanumber;
    Vector vsubareanumb;
    Vector vbuildingnumb;
    Vector vdoorcount;
    Vector vfloornumb;
    Vector vcellnumb;
    Vector vowner;
    Vector vnumberb;
    Vector vnumberc;
    String vnumberco;
    String vownername;
    protected String selectSQL01;
    protected String selectSQL02;
    protected String selectSQL03;
    protected String selectSQL04;
    protected String selectSQL05;
    protected String selectSQL06;
    protected String selectSQL07;
    protected String selectSQL08;
    protected SelectStatement selectStatement01;
    protected SelectStatement selectStatement02;
    protected SelectStatement selectStatement03;
    protected SelectStatement selectStatement04;
    protected SelectStatement selectStatement05;
    protected SelectStatement selectStatement06;
    protected SelectStatement selectStatement07;
    protected SelectStatement selectStatement08;
    static Class class$java$lang$String; /* synthetic field */
    static Class class$java$lang$Integer; /* synthetic field */

    public TreeDBBean()
    {
        tablename1 = null;
        tablename2 = null;
        tablename3 = null;
        tablename4 = null;
        tablename5 = null;
        fixturenumb = null;
        apparatusnumb1 = null;
        apparatusnumb2 = null;
        apparatusnumb3 = null;
        apparatuskind = null;
        anumber = null;
        subareanumb = null;
        subareanumb1 = null;
        buildingnumb1 = null;
        doornumb1 = null;
        floornumb1 = null;
        cellnumb1 = null;
        delflag = null;
        number2 = null;
        vfixturenumb = new Vector();
        vapparatusnumb1 = new Vector();
        vapparatusnumb2 = new Vector();
        vapparatusnumb3 = new Vector();
        vanumber = new Vector();
        vsubareanumb = new Vector();
        vbuildingnumb = new Vector();
        vdoorcount = new Vector();
        vfloornumb = new Vector();
        vcellnumb = new Vector();
        vowner = new Vector();
        vnumberb = new Vector();
        vnumberc = new Vector();
        vnumberco = "";
        vownername = "";
    }

    static Class class$(String s)
    {
        try
        {
            return Class.forName(s);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            throw new NoClassDefFoundError(classnotfoundexception.getMessage());
        }
    }

    public String getApparatusKind()
    {
        return apparatuskind;
    }

    public String getBuildingNumb1()
    {
        return buildingnumb1;
    }

    public String getCellNumb1()
    {
        return cellnumb1;
    }

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

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从机电设备资料结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

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

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从三表结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

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

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从三表结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

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

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从三表结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult05()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vanumber.addElement(result.getColumnValueToString("anumber").trim());
                vsubareanumb.addElement(result.getColumnValueToString("subareanumb").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从分区结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult06(int i)
        throws Exception
    {
        try
        {
            for(int j = 0; j < result.getNumRowsInCache(); j++)
            {
                result.setCurrentRow(j + 1);
                vnumberb.addElement(result.getColumnValueToString("numberb" + i).trim());
                vbuildingnumb.addElement(result.getColumnValueToString("buildingnumb" + i).trim());
                vdoorcount.addElement(result.getColumnValueToString("doorcount" + i).trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从分区结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult07(int i)
        throws Exception
    {
        try
        {
            for(int j = 0; j < result.getNumRowsInCache(); j++)
            {
                result.setCurrentRow(j + 1);
                vnumberc.addElement(result.getColumnValueToString("numberc" + i).trim());
                vfloornumb.addElement(result.getColumnValueToString("floornumb" + i).trim());
                vcellnumb.addElement(result.getColumnValueToString("cellnumb" + i).trim());
                vowner.addElement(result.getColumnValueToString("owner" + i).trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从单元结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult08()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vnumberco = result.getColumnValueToString("numberco").trim();
                vownername = result.getColumnValueToString("ownername").trim();