statallpersontraindbbean.java

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

                    }
                    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("");
                    }
                }

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

    public void getDataFromResult02()
        throws Exception
    {
        try
        {
            int i = getPage();
            int j = result.getNumRowsInCache();
            if(getPageLength() * (i - 1) >= j && j > 0)
            {
                i--;
                setPage(i);
            }
            for(int k = getPageLength() * (i - 1); k < Math.min(getPageLength() * i, j); k++)
            {
                result.setCurrentRow(k + 1);
                vnumber1.addElement(result.getColumnValueToString("number1").trim());
                vpersnumb1.addElement(result.getColumnValueToString("persnumb1").trim());
                vtrainname.addElement(result.getColumnValueToString("trainname").trim());
                vtstartdate.addElement(result.getColumnValueToString("tstartdate").trim());
                vtenddate.addElement(result.getColumnValueToString("tenddate").trim());
                vtaddress.addElement(result.getColumnValueToString("taddress").trim());
                vtperson.addElement(result.getColumnValueToString("tperson").trim());
                vtcontent.addElement(result.getColumnValueToString("tcontent").trim());
                vteffect.addElement(result.getColumnValueToString("teffect").trim());
                vremark.addElement(result.getColumnValueToString("remark").trim());
            }

            if(j != 0)
            {
                for(int l = 0; l < j; l++)
                {
                    result.setCurrentRow(l + 1);
                    vnumber1b.addElement(result.getColumnValueToString("number1").trim());
                    vpersnumb1b.addElement(result.getColumnValueToString("persnumb1").trim());
                    vtrainnameb.addElement(result.getColumnValueToString("trainname").trim());
                    vtstartdateb.addElement(result.getColumnValueToString("tstartdate").trim());
                    vtenddateb.addElement(result.getColumnValueToString("tenddate").trim());
                    vtaddressb.addElement(result.getColumnValueToString("taddress").trim());
                    vtpersonb.addElement(result.getColumnValueToString("tperson").trim());
                    vtcontentb.addElement(result.getColumnValueToString("tcontent").trim());
                    vteffectb.addElement(result.getColumnValueToString("teffect").trim());
                    vremarkb.addElement(result.getColumnValueToString("remark").trim());
                }

            } else
            {
                vnumber1b.addElement(" ");
                vpersnumb1b.addElement(getPersNumb());
                vtrainnameb.addElement(" ");
                vtstartdateb.addElement(" ");
                vtenddateb.addElement(" ");
                vtaddressb.addElement(" ");
                vtpersonb.addElement(" ");
                vtcontentb.addElement(" ");
                vteffectb.addElement(" ");
                vremarkb.addElement(" ");
            }
        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从机电设备附件资料结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void getDataFromResult03()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() > 0)
            {
                for(int i = 0; i < result.getNumRowsInCache(); i++)
                {
                    result.setCurrentRow(i + 1);
                    vnowjob.addElement(result.getColumnValueToString("nowjob").trim());
                }

            } else
            {
                vnowjob.addElement(" ");
            }
            nowjob = (String)vnowjob.elementAt(0);
            vnowjob.removeAllElements();
        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public String getDelFlag()
    {
        return delflag;
    }

    public int getPage()
    {
        return page;
    }

    public int getPageLength()
    {
        return pageLength;
    }

    public int getPages()
    {
        return pages;
    }

    public String getPersNumb()
    {
        return persnumb;
    }