retrievebycdbbean.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:   RetrieveByCDBBean.java

package baseinfo;

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

public class RetrieveByCDBBean extends QueryDBBean
{

    protected String subareanumb;
    protected String buildingnumb;
    protected String doornumb;
    protected String floornumb;
    protected String cellnumb;
    protected String para;
    Vector vecNumb;
    Vector vecQ1;
    Vector vecQ2;
    Vector vecQ3;
    Vector vecQ4;
    Vector vecQ5;
    Vector vecQ6;
    Vector vecQ7;
    Vector vecQ8;
    Vector vecQ9;
    Vector vecQ10;
    Vector vecQ11;
    Vector vecQ12;
    Vector vecQ13;
    Vector vecQ14;
    Vector vecQ15;
    Vector vecQ16;
    Vector vecQ17;
    Vector vecQ18;
    Vector vecQ19;
    Vector vecQ20;
    Vector vecQ21;
    Vector vecQ22;
    Vector vecQ23;
    Vector vecQ24;
    Vector vecQ25;
    Vector vecQ26;
    Vector vecQ27;
    Vector vecQ28;
    Vector vecPicname;
    Vector vecPicdescribe;
    Vector vecNum;
    protected String selectSQL01;
    protected String selectSQL02;
    protected SelectStatement selectStatement01;
    protected SelectStatement selectStatement02;
    static Class class$java$lang$String; /* synthetic field */
    static Class class$java$lang$Integer; /* synthetic field */

    public RetrieveByCDBBean()
    {
        subareanumb = null;
        buildingnumb = null;
        doornumb = null;
        floornumb = null;
        cellnumb = null;
        para = null;
        vecNumb = new Vector();
        vecQ1 = new Vector();
        vecQ2 = new Vector();
        vecQ3 = new Vector();
        vecQ4 = new Vector();
        vecQ5 = new Vector();
        vecQ6 = new Vector();
        vecQ7 = new Vector();
        vecQ8 = new Vector();
        vecQ9 = new Vector();
        vecQ10 = new Vector();
        vecQ11 = new Vector();
        vecQ12 = new Vector();
        vecQ13 = new Vector();
        vecQ14 = new Vector();
        vecQ15 = new Vector();
        vecQ16 = new Vector();
        vecQ17 = new Vector();
        vecQ18 = new Vector();
        vecQ19 = new Vector();
        vecQ20 = new Vector();
        vecQ21 = new Vector();
        vecQ22 = new Vector();
        vecQ23 = new Vector();
        vecQ24 = new Vector();
        vecQ25 = new Vector();
        vecQ26 = new Vector();
        vecQ27 = new Vector();
        vecQ28 = new Vector();
        vecPicname = new Vector();
        vecPicdescribe = new Vector();
        vecNum = new Vector();
    }

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

    public String getBuildingnumb()
    {
        return buildingnumb;
    }

    public String getCellnumb()
    {
        return cellnumb;
    }

    public void getDataFromResult01()
        throws Exception
    {
        if(getPara().equals("0"))
            try
            {
                for(int i = 0; i < result.getNumRowsInCache(); i++)
                {
                    result.setCurrentRow(i + 1);
                    vecQ1.addElement(result.getColumnValueToString("subareanumb").trim());
                    vecQ2.addElement(result.getColumnValueToString("subareaname").trim());
                    vecQ3.addElement(result.getColumnValueToString("subareadescribe").trim());
                    vecQ4.addElement(result.getColumnValueToString("path").trim());
                    vecQ5.addElement(result.getColumnValueToString("publicservice").trim());
                    vecQ6.addElement(result.getColumnValueToString("hirerate").trim());
                    vecQ7.addElement(result.getColumnValueToString("salerate").trim());
                    vecQ8.addElement(result.getColumnValueToString("firefighting").trim());
                    vecQ9.addElement(result.getColumnValueToString("security").trim());
                    vecQ10.addElement(result.getColumnValueToString("remark").trim());
                }

            }
            catch(DataException dataexception)
            {
                setStatusCode(1084);
                setStatusMessage("从分区资料结果集中取值时出错！");
                throw dataexception;
            }
            finally
            {
                closeResultSet();
            }
        if(getPara().equals("1"))
            try
            {
                for(int j = 0; j < result.getNumRowsInCache(); j++)
                {
                    result.setCurrentRow(j + 1);
                    vecNumb.addElement(result.getColumnValueToString("number1").trim());
                    vecQ1.addElement(result.getColumnValueToString("buildingnumb").trim());
                    vecQ2.addElement(result.getColumnValueToString("subareanumb").trim());
                    vecQ3.addElement(result.getColumnValue("buildingname"));
                    vecQ4.addElement(result.getColumnValue("btype"));
                    vecQ5.addElement(result.getColumnValue("buse"));
                    vecQ6.addElement(result.getColumnValue("doorcount"));
                    vecQ7.addElement(result.getColumnValue("struture"));
                    vecQ8.addElement(result.getColumnValue("height"));
                    vecQ9.addElement(result.getColumnValue("floorcount"));
                    vecQ10.addElement(result.getColumnValue("startdate"));
                    vecQ11.addElement(result.getColumnValue("enddate"));
                    vecQ12.addElement(result.getColumnValue("developer"));
                    vecQ13.addElement(result.getColumnValue("architecture"));
                    vecQ14.addElement(result.getColumnValue("takearea"));
                    vecQ15.addElement(result.getColumnValue("architecturearea"));
                    vecQ16.addElement(result.getColumnValue("usingarea"));
                    vecQ17.addElement(result.getColumnValue("virescencearea"));
                    vecQ18.addElement(result.getColumnValue("cellcount"));
                    vecQ19.addElement(result.getColumnValue("salerate"));
                    vecQ20.addElement(result.getColumnValue("hirerate"));
                    vecQ21.addElement(result.getColumnValue("handover"));
                    vecQ22.addElement(result.getColumnValue("handoverdate"));
                    vecQ23.addElement(result.getColumnValue("handoverman"));
                    vecQ24.addElement(result.getColumnValue("remark"));
                }

            }
            catch(DataException dataexception1)
            {
                setStatusCode(1060);
                setStatusMessage("从楼宇资料结果集中取值时出错！");
                throw dataexception1;
            }
            finally
            {
                closeResultSet();
            }
        if(getPara().equals("2"))
            try
            {
                for(int k = 0; k < result.getNumRowsInCache(); k++)
                {
                    result.setCurrentRow(k + 1);
                    vecNumb.addElement(result.getColumnValueToString("number1").trim());
                    vecQ1.addElement(result.getColumnValueToString("cellnumb").trim());
                    vecQ28.addElement(result.getColumnValueToString("floortype").trim());
                    vecQ2.addElement(result.getColumnValueToString("floornumb").trim());
                    vecQ3.addElement(result.getColumnValueToString("doornumb").trim());
                    vecQ4.addElement(result.getColumnValueToString("buildingnumb").trim());
                    vecQ5.addElement(result.getColumnValueToString("subareanumb").trim());
                    vecQ6.addElement(result.getColumnValue("use"));
                    vecQ7.addElement(result.getColumnValue("structure"));
                    vecQ8.addElement(result.getColumnValue("architecturearea"));
                    vecQ9.addElement(result.getColumnValue("usingarea"));