statallpersontraindbbean.java

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

        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();
        tablename3 = null;
        changedate = null;
        beforejob = null;
        nowjob = null;
        changereason = null;
        vnowjob = 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
        {
            if(result.getNumRowsInCache() > 0)
            {
                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)
                    {
                        vpersname.addElement("");
                    }
                    try
                    {
                        if(result.getColumnValueToString("persgender").trim().equals("0"))
                            vpersgender.addElement("男");
                        else
                            vpersgender.addElement("女");
                    }
                    catch(NullPointerException _ex)
                    {
                        vpersgender.addElement("");
                    }
                    try
                    {
                        vpicturename.addElement(result.getColumnValue("picturename"));
                    }
                    catch(NullPointerException _ex)
                    {
                        vpicturename.addElement("");
                    }
                    try
                    {
                        vnation.addElement(result.getColumnValueToString("nation").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vnation.addElement("");
                    }
                    try
                    {
                        vborndate.addElement(result.getColumnValueToString("borndate").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vborndate.addElement("");
                    }
                    try
                    {
                        vaddress.addElement(result.getColumnValueToString("address").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vaddress.addElement("");
                    }
                    try
                    {
                        vedulevel.addElement(result.getColumnValueToString("edulevel").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vedulevel.addElement("");
                    }
                    try
                    {
                        vtechnica.addElement(result.getColumnValueToString("technica").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vtechnica.addElement("");
                    }
                    try
                    {
                        vmarriage.addElement(result.getColumnValueToString("marriage").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vmarriage.addElement("");
                    }
                    try
                    {
                        vskill.addElement(result.getColumnValueToString("skill").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vskill.addElement("");
                    }
                    try
                    {
                        vlike.addElement(result.getColumnValueToString("like").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vlike.addElement("");
                    }
                    try
                    {
                        videntirycode.addElement(result.getColumnValueToString("identirycode").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        videntirycode.addElement("");
                    }
                    try
                    {
                        vphone.addElement(result.getColumnValueToString("phone").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vphone.addElement("");
                    }
                    try
                    {
                        vschool1.addElement(result.getColumnValueToString("school1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vschool1.addElement("");
                    }
                    try
                    {
                        vstaradate1.addElement(result.getColumnValueToString("staradate1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vstaradate1.addElement("");
                    }
                    try
                    {
                        venddate1.addElement(result.getColumnValueToString("enddate1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        venddate1.addElement("");
                    }
                    try
                    {
                        vspecialty1.addElement(result.getColumnValueToString("specialty1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vspecialty1.addElement("");
                    }
                    try
                    {
                        vschool2.addElement(result.getColumnValueToString("school2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vschool2.addElement("");
                    }
                    try
                    {
                        vstaradate2.addElement(result.getColumnValueToString("staradate2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vstaradate2.addElement("");
                    }
                    try
                    {
                        venddate2.addElement(result.getColumnValueToString("enddate2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        venddate2.addElement("");
                    }
                    try
                    {
                        vspecialty2.addElement(result.getColumnValueToString("specialty2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vspecialty2.addElement("");
                    }
                    try
                    {
                        vschool3.addElement(result.getColumnValueToString("school3").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vschool3.addElement("");
                    }
                    try
                    {
                        vstaradate3.addElement(result.getColumnValueToString("staradate3").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vstaradate3.addElement("");
                    }
                    try
                    {
                        venddate3.addElement(result.getColumnValueToString("enddate3").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        venddate3.addElement("");
                    }
                    try
                    {
                        vspecialty3.addElement(result.getColumnValueToString("specialty3").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vspecialty3.addElement("");
                    }
                    try
                    {
                        vcompname1.addElement(result.getColumnValueToString("compname1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vcompname1.addElement("");
                    }
                    try
                    {
                        vcstartdate1.addElement(result.getColumnValueToString("cstartdate1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vcstartdate1.addElement("");
                    }
                    try
                    {
                        vcenddate1.addElement(result.getColumnValueToString("cenddate1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vcenddate1.addElement("");
                    }
                    try
                    {
                        vjob1.addElement(result.getColumnValueToString("job1").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vjob1.addElement("");
                    }
                    try
                    {
                        vcompname2.addElement(result.getColumnValueToString("compname2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vcompname2.addElement("");
                    }
                    try
                    {
                        vcstartdate2.addElement(result.getColumnValueToString("cstartdate2").trim());
                    }
                    catch(NullPointerException _ex)
                    {
                        vcstartdate2.addElement("");
                    }
                    try
                    {
                        vcenddate2.addElement(result.getColumnValueToString("cenddate2").trim());