retrievepersondbbean.java

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

                {
                    vpersname.addElement("");
                }
                try
                {
                    vpersgender.addElement(result.getColumnValueToString("persgender").trim());
                }
                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());
                }
                catch(NullPointerException _ex)
                {
                    vcenddate2.addElement("");
                }
                try
                {
                    vjob2.addElement(result.getColumnValueToString("job2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vjob2.addElement("");
                }
                try
                {
                    vcompname3.addElement(result.getColumnValueToString("compname3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcompname3.addElement("");
                }
                try
                {
                    vcstartdate3.addElement(result.getColumnValueToString("cstartdate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcstartdate3.addElement("");
                }
                try
                {
                    vcenddate3.addElement(result.getColumnValueToString("cenddate3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vcenddate3.addElement("");
                }
                try
                {
                    vjob3.addElement(result.getColumnValueToString("job3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vjob3.addElement("");
                }
                try
                {
                    vfname1.addElement(result.getColumnValueToString("fname1").trim());