statpersonstatusdbbean.java

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

                    vskillb.addElement(result.getColumnValueToString("skill").trim());
                }
                catch(NullPointerException _ex)
                {
                    vskillb.addElement("");
                }
                try
                {
                    vlikeb.addElement(result.getColumnValueToString("like").trim());
                }
                catch(NullPointerException _ex)
                {
                    vlikeb.addElement("");
                }
                try
                {
                    videntirycodeb.addElement(result.getColumnValueToString("identirycode").trim());
                }
                catch(NullPointerException _ex)
                {
                    videntirycodeb.addElement("");
                }
                try
                {
                    vphoneb.addElement(result.getColumnValueToString("phone").trim());
                }
                catch(NullPointerException _ex)
                {
                    vphoneb.addElement("");
                }
                try
                {
                    vschool1b.addElement(result.getColumnValueToString("school1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vschool1b.addElement("");
                }
                try
                {
                    vstaradate1b.addElement(result.getColumnValueToString("staradate1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vstaradate1b.addElement("");
                }
                try
                {
                    venddate1b.addElement(result.getColumnValueToString("enddate1").trim());
                }
                catch(NullPointerException _ex)
                {
                    venddate1b.addElement("");
                }
                try
                {
                    vspecialty1b.addElement(result.getColumnValueToString("specialty1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vspecialty1b.addElement("");
                }
                try
                {
                    vschool2b.addElement(result.getColumnValueToString("school2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vschool2b.addElement("");
                }
                try
                {
                    vstaradate2b.addElement(result.getColumnValueToString("staradate2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vstaradate2b.addElement("");
                }
                try
                {
                    venddate2b.addElement(result.getColumnValueToString("enddate2").trim());
                }
                catch(NullPointerException _ex)
                {
                    venddate2b.addElement("");
                }
                try
                {
                    vspecialty2b.addElement(result.getColumnValueToString("specialty2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vspecialty2b.addElement("");
                }
                try
                {
                    vschool3b.addElement(result.getColumnValueToString("school3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vschool3b.addElement("");
                }
                try
                {
                    vstaradate3b.addElement(result.getColumnValueToString("staradate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vstaradate3b.addElement("");
                }
                try
                {
                    venddate3b.addElement(result.getColumnValueToString("enddate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    venddate3b.addElement("");
                }
                try
                {
                    vspecialty3b.addElement(result.getColumnValueToString("specialty3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vspecialty3b.addElement("");
                }
                try
                {
                    vcompname1b.addElement(result.getColumnValueToString("compname1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcompname1b.addElement("");
                }
                try
                {
                    vcstartdate1b.addElement(result.getColumnValueToString("cstartdate1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcstartdate1b.addElement("");
                }
                try
                {
                    vcenddate1b.addElement(result.getColumnValueToString("cenddate1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcenddate1b.addElement("");
                }
                try
                {
                    vjob1b.addElement(result.getColumnValueToString("job1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vjob1b.addElement("");
                }
                try
                {
                    vcompname2b.addElement(result.getColumnValueToString("compname2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcompname2b.addElement("");
                }
                try
                {
                    vcstartdate2b.addElement(result.getColumnValueToString("cstartdate2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcstartdate2b.addElement("");
                }
                try
                {
                    vcenddate2b.addElement(result.getColumnValueToString("cenddate2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcenddate2b.addElement("");
                }
                try
                {
                    vjob2b.addElement(result.getColumnValueToString("job2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vjob2b.addElement("");
                }
                try
                {
                    vcompname3b.addElement(result.getColumnValueToString("compname3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcompname3b.addElement("");
                }
                try
                {
                    vcstartdate3b.addElement(result.getColumnValueToString("cstartdate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcstartdate3b.addElement("");
                }
                try
                {
                    vcenddate3b.addElement(result.getColumnValueToString("cenddate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcenddate3b.addElement("");
                }
                try
                {
                    vjob3b.addElement(result.getColumnValueToString("job3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vjob3b.addElement("");
                }
                try
                {
                    vfname1b.addElement(result.getColumnValueToString("fname1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfname1b.addElement("");
                }
                try
                {
                    vrelation1b.addElement(result.getColumnValueToString("relation1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vrelation1b.addElement("");
                }
                try
                {
                    vaddr1b.addElement(result.getColumnValueToString("addr1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddr1b.addElement("");
                }
                try
                {
                    vfphone1b.addElement(result.getColumnValueToString("fphone1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfphone1b.addElement("");
                }
                try
                {
                    vfname2b.addElement(result.getColumnValueToString("fname2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfname2b.addElement("");
                }
                try
                {
                    vrelation2b.addElement(result.getColumnValueToString("relation2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vrelation2b.addElement("");
                }
                try
                {
                    vaddr2b.addElement(result.getColumnValueToString("addr2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddr2b.addElement("");
                }
                if(result.getColumnValue("fphone2") == null)
                    vfphone2b.addElement("");
                else
                    vfphone2b.addElement(result.getColumnValueToString("fphone2").trim());
                if(result.getColumnValue("fname3") == null)
                    vfname3b.addElement("");
                else
                    vfname3b.addElement(result.getColumnValueToString("fname3").trim());
                if(result.getColumnValue("relation3") == null)
                    vrelation3b.addElement("");
                else
                    vrelation3b.addElement(result.getColumnValueToString("relation3").trim());
                if(result.getColumnValue("addr3") == null)
                    vaddr3b.addElement("");
                else
                    vaddr3b.addElement(result.getColumnValueToString("addr3").trim());
                if(result.getColumnValue("fphone3") == null)
                    vfphone3b.addElement("");
                else
                    vfphone3b.addElement(result.getColumnValueToString("fphone3").trim());
                if(result.getColumnValue("date") == null)
                    vdateb.addElement("");
                else
                    vdateb.addElement(result.getColumnValueToString("date").trim());
                if(result.getColumnValue("dept") == null)
                    vdeptb.addElement("");
                else
                    vdeptb.addElement(result.getColumnValueToString("dept").trim());
                try
                {
                    if(result.getColumnValueToString("status").trim().equals("0"))
                        vstatusb.addElement("试用");
                    else
                    if(result.getColumnValueToString("status").trim().equals("1"))
                        vstatusb.addElement("已聘用");
                    else
                        vstatusb.addElement("离职");
                }
                catch(NullPointerException _ex)
                {
                    vstatusb.addElement("");
                }
                try
                {
                    vleavereasonb.addElement(result.getColumnValueToString("leavereason").trim());
                }
                catch(NullPointerException _ex)
                {
                    vleavereasonb.addElement("");
                }
                try
                {
                    vlinkmanb.addElement(result.getColumnValueToString("linkman").trim());