retrievepersondbbean.java

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

        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();
        vleavereason = new Vector();
        vlinkman = new Vector();
        vlinktel = new Vector();
        vdelflag = 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
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vnumber.addElement(result.getColumnValueToString("number").trim());
                vpersnumb.addElement(result.getColumnValueToString("persnumb").trim());
                vpersname.addElement(result.getColumnValueToString("persname").trim());
                vpersgender.addElement(result.getColumnValueToString("persgender").trim());
                vpicturename.addElement(result.getColumnValue("picturename"));
                vnation.addElement(result.getColumnValueToString("nation").trim());
                vborndate.addElement(result.getColumnValueToString("borndate").trim());
                vaddress.addElement(result.getColumnValueToString("address").trim());
                vedulevel.addElement(result.getColumnValueToString("edulevel").trim());
                vtechnica.addElement(result.getColumnValueToString("technica").trim());
                vmarriage.addElement(result.getColumnValueToString("marriage").trim());
                vskill.addElement(result.getColumnValueToString("skill").trim());
                vlike.addElement(result.getColumnValueToString("like").trim());
                videntirycode.addElement(result.getColumnValueToString("identirycode").trim());
                vphone.addElement(result.getColumnValueToString("phone").trim());
                vschool1.addElement(result.getColumnValueToString("school1").trim());
                vstaradate1.addElement(result.getColumnValueToString("staradate1").trim());
                venddate1.addElement(result.getColumnValueToString("enddate1").trim());
                vspecialty1.addElement(result.getColumnValueToString("specialty1").trim());
                vschool2.addElement(result.getColumnValueToString("school2").trim());
                vstaradate2.addElement(result.getColumnValueToString("staradate2").trim());
                venddate2.addElement(result.getColumnValueToString("enddate2").trim());
                vspecialty2.addElement(result.getColumnValueToString("specialty2").trim());
                vschool3.addElement(result.getColumnValueToString("school3").trim());
                vstaradate3.addElement(result.getColumnValueToString("staradate3").trim());
                venddate3.addElement(result.getColumnValueToString("enddate3").trim());
                vspecialty3.addElement(result.getColumnValueToString("specialty3").trim());
                vcompname1.addElement(result.getColumnValueToString("compname1").trim());
                vcstartdate1.addElement(result.getColumnValueToString("cstartdate1").trim());
                vcenddate1.addElement(result.getColumnValueToString("cenddate1").trim());
                vjob1.addElement(result.getColumnValueToString("job1").trim());
                vcompname2.addElement(result.getColumnValueToString("compname2").trim());
                vcstartdate2.addElement(result.getColumnValueToString("cstartdate2").trim());
                vcenddate2.addElement(result.getColumnValueToString("cenddate2").trim());
                vjob2.addElement(result.getColumnValueToString("job2").trim());
                vcompname3.addElement(result.getColumnValueToString("compname3").trim());
                vcstartdate3.addElement(result.getColumnValueToString("cstartdate3").trim());
                vcenddate3.addElement(result.getColumnValueToString("cenddate3").trim());
                vjob3.addElement(result.getColumnValueToString("job3").trim());
                vfname1.addElement(result.getColumnValueToString("fname1").trim());
                vrelation1.addElement(result.getColumnValueToString("relation1").trim());
                vaddr1.addElement(result.getColumnValueToString("addr1").trim());
                vfphone1.addElement(result.getColumnValueToString("fphone1").trim());
                vfname2.addElement(result.getColumnValueToString("fname2").trim());
                vrelation2.addElement(result.getColumnValueToString("relation2").trim());
                vaddr2.addElement(result.getColumnValueToString("addr2").trim());
                vfphone2.addElement(result.getColumnValueToString("fphone2").trim());
                vfname3.addElement(result.getColumnValueToString("fname3").trim());
                vrelation3.addElement(result.getColumnValueToString("relation3").trim());
                vaddr3.addElement(result.getColumnValueToString("addr3").trim());
                vfphone3.addElement(result.getColumnValueToString("fphone3").trim());
                vdate.addElement(result.getColumnValueToString("date").trim());
                vdept.addElement(result.getColumnValueToString("dept").trim());
                vstatus.addElement(result.getColumnValueToString("status").trim());
                vleavereason.addElement(result.getColumnValueToString("leavereason").trim());
                vlinkman.addElement(result.getColumnValueToString("linkman").trim());
                vlinktel.addElement(result.getColumnValueToString("linktel").trim());
                vdelflag.addElement(result.getColumnValueToString("delflag").trim());
            }

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

    public String getPersNumb()
    {
        return persnumb;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public void initSelect01()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement01 = new SelectStatement();
        selectStatement01.setConnection(connBean);
        statementmetadata = selectStatement01.getMetaData();
        statementmetadata.setSQL(getSelectSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("persnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement01.setParameter("persnumb", getPersNumb());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("persnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("persname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("persgender", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("picturename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("nation", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("borndate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("address", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("edulevel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("technica", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("marriage", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("skill", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("like", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("identirycode", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("phone", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("school1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("staradate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("enddate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("specialty1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("school2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("staradate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("enddate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("specialty2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("school3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("staradate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("enddate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("specialty3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("compname1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cstartdate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cenddate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("job1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("compname2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cstartdate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cenddate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("job2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("compname3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cstartdate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cenddate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("job3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fname1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("relation1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("addr1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fphone1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fname2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("relation2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("addr2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fphone2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fname3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("relation3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("addr3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fphone3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("date", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("dept", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("status", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("leavereason", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("linkman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("linktel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
    }

    public void select01()
        throws Exception
    {
        try
        {
            try
            {
                initSelect01();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusCode(3171);
            setStatusMessage("检索指定编号的员工的资料成功完成");
        }
        catch(DataException dataexception)
        {
            setStatusCode(3172);
            setStatusMessage("检索指定编号的员工的资料时出错：" + dataexception.getMessage());
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有符合条件的员工");
                setStatusCode(3172);
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setPersNumb(String s)
    {
        persnumb = s;
    }

    public void setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }
}