retrievevdatadbbean.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:   RetrieveVDataDBBean.java

package beautify.virescence;

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

public class RetrieveVDataDBBean extends ParentDBBean
{

    protected SelectStatement selectSql02;
    protected String select02;
    protected final int pagelength = 5;
    protected String updownindex;
    protected int pagecount;
    protected int pageindex;
    protected String retrieveindex;
    protected String retrievecon;
    protected String retrievecom;
    protected Vector allSqlStatement;
    protected String number;
    protected String plant;
    protected String sort;
    protected String tang;
    protected String comefrom;
    protected String unit;
    protected String bedway;
    protected String bedplace;
    protected String bedarea;
    protected String price;
    protected String amount;
    protected String recorder;
    protected String remark;
    protected String delflag;
    protected String recorddate;
    protected Vector numbervec;
    protected Vector plantvec;
    protected Vector sortvec;
    protected Vector comefromvec;
    protected Vector unitvec;
    protected Vector bedwayvec;
    protected Vector bedplacevec;
    protected Vector bedareavec;
    protected Vector pricevec;
    protected Vector amountvec;
    protected Vector remarkvec;
    protected Vector datevec;
    static Class class$java$lang$Integer; /* synthetic field */
    static Class class$java$lang$String; /* synthetic field */
    static Class class$java$lang$Double; /* synthetic field */

    public RetrieveVDataDBBean()
    {
        updownindex = "0";
        pagecount = 0;
        pageindex = 0;
        retrieveindex = "0";
        retrievecon = "";
        retrievecom = "";
        allSqlStatement = new Vector();
        numbervec = new Vector();
        plantvec = new Vector();
        sortvec = new Vector();
        comefromvec = new Vector();
        unitvec = new Vector();
        bedwayvec = new Vector();
        bedplacevec = new Vector();
        bedareavec = new Vector();
        pricevec = new Vector();
        amountvec = new Vector();
        remarkvec = new Vector();
        datevec = new Vector();
    }

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

    public String getAmount()
    {
        return amount;
    }

    public Vector getAmountvec()
    {
        return amountvec;
    }

    public String getBedarea()
    {
        return bedarea;
    }

    public Vector getBedareavec()
    {
        return bedareavec;
    }

    public String getBedplace()
    {
        return bedplace;
    }

    public Vector getBedplacevec()
    {
        return bedplacevec;
    }

    public String getBedway()
    {
        return bedway;
    }

    public Vector getBedwayvec()
    {
        return bedwayvec;
    }

    public String getComefrom()
    {
        return comefrom;
    }

    public Vector getComefromvec()
    {
        return comefromvec;
    }

    public Vector getDatevec()
    {
        return datevec;
    }

    public String getDelflag()
    {
        return delflag;
    }

    public String getNumber()
    {
        return number;
    }

    public Vector getNumbervec()
    {
        return numbervec;
    }

    public int getPagecount()
    {
        return pagecount;
    }

    public int getPageindex()
    {
        return pageindex;
    }

    public String getPlant()
    {
        return plant;
    }

    public Vector getPlantvec()
    {
        return plantvec;
    }

    public String getPrice()
    {
        return price;
    }

    public Vector getPricevec()
    {
        return pricevec;
    }

    public String getRecorddate()
    {
        return recorddate;
    }

    public String getRecorder()
    {
        return recorder;
    }

    public String getRemark()
    {
        return remark;
    }

    public Vector getRemarkvec()
    {
        return remarkvec;
    }

    public String getRetrievecom()
    {
        return retrievecom;
    }

    public String getRetrievecon()
    {
        return retrievecon;
    }

    public String getRetrieveindex()
    {
        return retrieveindex;
    }

    public String getSelect02()
    {
        return select02;
    }

    public String getSort()
    {
        return sort;
    }

    public Vector getSortvec()
    {
        return sortvec;
    }

    public String getTang()
    {
        return tang;
    }

    public String getUnit()
    {
        return unit;
    }

    public Vector getUnitvec()
    {
        return unitvec;
    }

    public String getUpdownindex()
    {
        return updownindex;
    }

    protected void initSelect02()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        selectSql02 = new SelectStatement();
        selectSql02.setConnection(connBean);
        statementmetadata = selectSql02.getMetaData();
        statementmetadata.setSQL(getSelect02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("plant", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sort", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("comefrom", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("unit", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("bedway", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("bedplace", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("bedarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("price", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("amount", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("recorddate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        switch(Integer.parseInt(getRetrieveindex()))
        {
        case 0: // '\0'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            selectSql02.setParameter("delflag", getDelflag());
            break;

        case 1: // '\001'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("plant2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("plant2", getPlant());
            break;

        case 2: // '\002'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("sort2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());