addpersondbbean.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:   AddPersonDBBean.java

package personaladmin;

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

public class AddPersonDBBean extends QueryDBBean
{

    protected String personpower;
    protected String persnumb;
    protected String persname;
    protected String persgender;
    protected byte picture[];
    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 identirycard;
    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;
    protected String number;
    protected String powername;
    protected String powercode;
    protected String tablename2;
    protected String insertSQL01;
    protected SQLStatement insertStatement01;
    protected String selectSQL01;
    protected SelectStatement selectStatement01;
    protected String selectSQL02;
    protected SelectStatement selectStatement02;
    Vector vecQ1;
    Vector vpnumb;
    Vector vpname;
    Vector vpowercode;
    static Class class$java$lang$Integer; /* synthetic field */
    static Class class$java$lang$String; /* synthetic field */
    static Class array$B; /* synthetic field */

    public AddPersonDBBean()
    {
        personpower = null;
        persnumb = null;
        persname = null;
        persgender = null;
        picture = new byte[0x19000];
        picturename = "";
        nation = null;
        borndate = null;
        address = null;
        edulevel = null;
        technica = null;
        marriage = null;
        skill = null;
        like = null;
        identirycard = 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;
        number = null;
        powername = null;
        powercode = null;
        tablename2 = null;
        vecQ1 = new Vector();
        vpnumb = new Vector();
        vpname = new Vector();
        vpowercode = new Vector();
    }

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

    public String getAddr1()
    {
        return addr1;
    }

    public String getAddr2()
    {
        return addr2;
    }

    public String getAddr3()
    {
        return addr3;
    }

    public String getAddress()
    {
        return address;
    }

    public String getBornDate()
    {
        return borndate;
    }

    public String getCEndDate1()
    {
        return cenddate1;
    }

    public String getCEndDate2()
    {
        return cenddate2;
    }

    public String getCEndDate3()
    {
        return cenddate3;
    }

    public String getCStartDate1()
    {
        return cstartdate1;
    }

    public String getCStartDate2()
    {
        return cstartdate2;
    }

    public String getCStartDate3()
    {
        return cstartdate3;
    }

    public String getCompName1()
    {
        return compname1;
    }

    public String getCompName2()
    {
        return compname2;
    }

    public String getCompName3()
    {
        return compname3;
    }

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

        }
        catch(DataException dataexception)
        {
            setStatusCode(200);
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult02()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vpnumb.addElement(result.getColumnValueToString("number").trim());
                vpname.addElement(result.getColumnValueToString("powername").trim());
                vpowercode.addElement(result.getColumnValueToString("powercode").trim());
            }

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

    public String getDate()
    {
        return date;
    }

    public String getDelFlag()
    {
        return delflag;
    }

    public String getDept()
    {
        return dept;
    }

    public String getEduLevel()
    {
        return edulevel;
    }

    public String getEndDate1()
    {
        return enddate1;
    }

    public String getEndDate2()
    {
        return enddate2;
    }

    public String getEndDate3()
    {
        return enddate3;
    }

    public String getFName1()
    {
        return fname1;
    }

    public String getFName2()
    {
        return fname2;
    }

    public String getFName3()
    {
        return fname3;
    }

    public String getFPhone1()
    {
        return fphone1;
    }

    public String getFPhone2()
    {
        return fphone2;
    }

    public String getFPhone3()
    {
        return fphone3;
    }

    public String getIdentiryCard()
    {
        return identirycard;
    }

    public String getInsertSQL01()