statpersonstatusdbbean.java

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

                {
                    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());
                }
                catch(NullPointerException _ex)
                {
                    vfname1.addElement("");
                }
                try
                {
                    vrelation1.addElement(result.getColumnValueToString("relation1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vrelation1.addElement("");
                }
                try
                {
                    vaddr1.addElement(result.getColumnValueToString("addr1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddr1.addElement("");
                }
                try
                {
                    vfphone1.addElement(result.getColumnValueToString("fphone1").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfphone1.addElement("");
                }
                try
                {
                    vfname2.addElement(result.getColumnValueToString("fname2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfname2.addElement("");
                }
                try
                {
                    vrelation2.addElement(result.getColumnValueToString("relation2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vrelation2.addElement("");
                }
                try
                {
                    vaddr2.addElement(result.getColumnValueToString("addr2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddr2.addElement("");
                }
                try
                {
                    vfphone2.addElement(result.getColumnValueToString("fphone2").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfphone2.addElement("");
                }
                try
                {
                    vfname3.addElement(result.getColumnValueToString("fname3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfname3.addElement("");
                }
                try
                {
                    vrelation3.addElement(result.getColumnValueToString("relation3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vrelation3.addElement("");
                }
                try
                {
                    vaddr3.addElement(result.getColumnValueToString("addr3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddr3.addElement("");
                }
                try
                {
                    vfphone3.addElement(result.getColumnValueToString("fphone3").trim());
                }
                catch(NullPointerException _ex)
                {
                    vfphone3.addElement("");
                }
                try
                {
                    vdate.addElement(result.getColumnValueToString("date").trim());
                }
                catch(NullPointerException _ex)
                {
                    vdate.addElement("");
                }
                try
                {
                    vdept.addElement(result.getColumnValueToString("dept").trim());
                }
                catch(NullPointerException _ex)
                {
                    vdept.addElement("");
                }
                try
                {
                    if(result.getColumnValueToString("status").trim().equals("0"))
                        vstatus.addElement("试用");
                    else
                    if(result.getColumnValueToString("status").trim().equals("1"))
                        vstatus.addElement("已聘用");
                    else
                        vstatus.addElement("离职");
                }
                catch(NullPointerException _ex)
                {
                    vstatus.addElement("");
                }
                try
                {
                    vleavereason.addElement(result.getColumnValueToString("leavereason").trim());
                }
                catch(NullPointerException _ex)
                {
                    vleavereason.addElement("");
                }
                try
                {
                    vlinkman.addElement(result.getColumnValueToString("linkman").trim());
                }
                catch(NullPointerException _ex)
                {
                    vlinkman.addElement("");
                }
                try
                {
                    vlinktel.addElement(result.getColumnValueToString("linktel").trim());
                }
                catch(NullPointerException _ex)
                {
                    vlinktel.addElement("");
                }
                try
                {
                    vdelflag.addElement(result.getColumnValueToString("delflag").trim());
                }
                catch(NullPointerException _ex)
                {
                    vdelflag.addElement("");
                }
            }

            for(int l = 0; l < result.getNumRowsInCache(); l++)
            {
                result.setCurrentRow(l + 1);
                try
                {
                    vnumberb.addElement(result.getColumnValueToString("number").trim());
                }
                catch(NullPointerException _ex)
                {
                    vnumberb.addElement("");
                }
                try
                {
                    vpersnumbb.addElement(result.getColumnValueToString("persnumb").trim());
                }
                catch(NullPointerException _ex)
                {
                    vpersnumbb.addElement("");
                }
                try
                {
                    vpersnameb.addElement(result.getColumnValueToString("persname").trim());
                }
                catch(NullPointerException _ex)
                {
                    vpersnameb.addElement("");
                }
                try
                {
                    if(result.getColumnValueToString("persgender").trim().equals("0"))
                        vpersgenderb.addElement("男");
                    else
                        vpersgenderb.addElement("女");
                }
                catch(NullPointerException _ex)
                {
                    vpersgenderb.addElement("");
                }
                try
                {
                    vpicturenameb.addElement(result.getColumnValue("picturename"));
                }
                catch(NullPointerException _ex)
                {
                    vpicturenameb.addElement("");
                }
                try
                {
                    vnationb.addElement(result.getColumnValueToString("nation").trim());
                }
                catch(NullPointerException _ex)
                {
                    vnationb.addElement("");
                }
                try
                {
                    vborndateb.addElement(result.getColumnValueToString("borndate").trim());
                }
                catch(NullPointerException _ex)
                {
                    vborndateb.addElement("");
                }
                try
                {
                    vaddressb.addElement(result.getColumnValueToString("address").trim());
                }
                catch(NullPointerException _ex)
                {
                    vaddressb.addElement("");
                }
                try
                {
                    vedulevelb.addElement(result.getColumnValueToString("edulevel").trim());
                }
                catch(NullPointerException _ex)
                {
                    vedulevelb.addElement("");
                }
                try
                {
                    vtechnicab.addElement(result.getColumnValueToString("technica").trim());
                }
                catch(NullPointerException _ex)
                {
                    vtechnicab.addElement("");
                }
                try
                {
                    vmarriageb.addElement(result.getColumnValueToString("marriage").trim());
                }
                catch(NullPointerException _ex)
                {
                    vmarriageb.addElement("");
                }
                try
                {