retrievepersondbbean.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:   RetrievePersonDBBean.java

package personaladmin.statistic;

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

public class RetrievePersonDBBean extends ParentDBBean
{

    protected String persnumb;
    protected String persname;
    protected String persgender;
    protected String picturename;
    protected String nation;
    protected String borndate;
    protected String address;
    protected String edulevel;
    protected String technica;
    protected String marriage;
    protected String skill;
    protected String like;
    protected String identirycode;
    protected String phone;
    protected String school1;
    protected String staradate1;
    protected String enddate1;
    protected String specialty1;
    protected String school2;
    protected String staradate2;
    protected String enddate2;
    protected String specialty2;
    protected String school3;
    protected String staradate3;
    protected String enddate3;
    protected String specialty3;
    protected String compname1;
    protected String cstartdate1;
    protected String cenddate1;
    protected String job1;
    protected String compname2;
    protected String cstartdate2;
    protected String cenddate2;
    protected String job2;
    protected String compname3;
    protected String cstartdate3;
    protected String cenddate3;
    protected String job3;
    protected String fname1;
    protected String relation1;
    protected String addr1;
    protected String fphone1;
    protected String fname2;
    protected String relation2;
    protected String addr2;
    protected String fphone2;
    protected String fname3;
    protected String relation3;
    protected String addr3;
    protected String fphone3;
    protected String date;
    protected String dept;
    protected String status;
    protected String leavereason;
    protected String linkman;
    protected String linktel;
    protected String delflag;
    Vector vnumber;
    Vector vpersnumb;
    Vector vpersname;
    Vector vpersgender;
    Vector vpicturename;
    Vector vnation;
    Vector vborndate;
    Vector vaddress;
    Vector vedulevel;
    Vector vtechnica;
    Vector vmarriage;
    Vector vskill;
    Vector vlike;
    Vector videntirycode;
    Vector vphone;
    Vector vschool1;
    Vector vstaradate1;
    Vector venddate1;
    Vector vspecialty1;
    Vector vschool2;
    Vector vstaradate2;
    Vector venddate2;
    Vector vspecialty2;
    Vector vschool3;
    Vector vstaradate3;
    Vector venddate3;
    Vector vspecialty3;
    Vector vcompname1;
    Vector vcstartdate1;
    Vector vcenddate1;
    Vector vjob1;
    Vector vcompname2;
    Vector vcstartdate2;
    Vector vcenddate2;
    Vector vjob2;
    Vector vcompname3;
    Vector vcstartdate3;
    Vector vcenddate3;
    Vector vjob3;
    Vector vfname1;
    Vector vrelation1;
    Vector vaddr1;
    Vector vfphone1;
    Vector vfname2;
    Vector vrelation2;
    Vector vaddr2;
    Vector vfphone2;
    Vector vfname3;
    Vector vrelation3;
    Vector vaddr3;
    Vector vfphone3;
    Vector vdate;
    Vector vdept;
    Vector vstatus;
    Vector vleavereason;
    Vector vlinkman;
    Vector vlinktel;
    Vector vdelflag;
    protected String selectSQL01;
    protected SelectStatement selectStatement01;
    static Class class$java$lang$String; /* synthetic field */
    static Class class$java$lang$Integer; /* synthetic field */

    public RetrievePersonDBBean()
    {
        persnumb = null;
        persname = null;
        persgender = null;
        picturename = null;
        nation = null;
        borndate = null;
        address = null;
        edulevel = null;
        technica = null;
        marriage = null;
        skill = null;
        like = null;
        identirycode = null;
        phone = null;
        school1 = null;
        staradate1 = null;
        enddate1 = null;
        specialty1 = null;
        school2 = null;
        staradate2 = null;
        enddate2 = null;
        specialty2 = null;
        school3 = null;
        staradate3 = null;
        enddate3 = null;
        specialty3 = null;
        compname1 = null;
        cstartdate1 = null;
        cenddate1 = null;
        job1 = null;
        compname2 = null;
        cstartdate2 = null;
        cenddate2 = null;
        job2 = null;
        compname3 = null;
        cstartdate3 = null;
        cenddate3 = null;
        job3 = null;
        fname1 = null;
        relation1 = null;
        addr1 = null;
        fphone1 = null;
        fname2 = null;
        relation2 = null;
        addr2 = null;
        fphone2 = null;
        fname3 = null;
        relation3 = null;
        addr3 = null;
        fphone3 = null;
        date = null;
        dept = null;
        status = null;
        leavereason = null;
        linkman = null;
        linktel = null;
        delflag = null;
        vnumber = new Vector();
        vpersnumb = new Vector();
        vpersname = new Vector();
        vpersgender = new Vector();
        vpicturename = new Vector();
        vnation = new Vector();
        vborndate = new Vector();
        vaddress = new Vector();
        vedulevel = new Vector();
        vtechnica = new Vector();
        vmarriage = new Vector();
        vskill = new Vector();
        vlike = new Vector();
        videntirycode = new Vector();
        vphone = new Vector();
        vschool1 = new Vector();
        vstaradate1 = new Vector();
        venddate1 = new Vector();
        vspecialty1 = new Vector();
        vschool2 = new Vector();
        vstaradate2 = new Vector();
        venddate2 = new Vector();
        vspecialty2 = new Vector();
        vschool3 = new Vector();
        vstaradate3 = new Vector();
        venddate3 = new Vector();
        vspecialty3 = new Vector();
        vcompname1 = new Vector();
        vcstartdate1 = new Vector();
        vcenddate1 = new Vector();
        vjob1 = new Vector();
        vcompname2 = new Vector();
        vcstartdate2 = new Vector();
        vcenddate2 = new Vector();
        vjob2 = new Vector();
        vcompname3 = new Vector();
        vcstartdate3 = new Vector();
        vcenddate3 = new Vector();
        vjob3 = new Vector();
        vfname1 = new Vector();
        vrelation1 = new Vector();
        vaddr1 = new Vector();
        vfphone1 = new Vector();
        vfname2 = new Vector();
        vrelation2 = new Vector();
        vaddr2 = new Vector();
        vfphone2 = new Vector();
        vfname3 = new Vector();
        vrelation3 = new Vector();
        vaddr3 = new Vector();
        vfphone3 = new Vector();
        vdate = new Vector();
        vdept = new Vector();
        vstatus = new Vector();
        vleavereason = new Vector();
        vlinkman = new Vector();
        vlinktel = new Vector();
        vdelflag = new Vector();
    }

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

    public void getDataFromResult01()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                try
                {
                    vnumber.addElement(result.getColumnValueToString("number").trim());
                }
                catch(NullPointerException _ex)
                {
                    vnumber.addElement("");
                }
                try
                {
                    vpersnumb.addElement(result.getColumnValueToString("persnumb").trim());
                }
                catch(NullPointerException _ex)
                {
                    vpersnumb.addElement("");
                }
                try
                {
                    vpersname.addElement(result.getColumnValueToString("persname").trim());
                }
                catch(NullPointerException _ex)