treedbbean.java

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

            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(6784);
            setStatusMessage("从三表结果集中取数据放入vector数组时出错");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public String getDelFlag()
    {
        return delflag;
    }

    public String getDoorNumb1()
    {
        return doornumb1;
    }

    public String getFloorNumb1()
    {
        return floornumb1;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public String getSelectSQL02()
    {
        return selectSQL02;
    }

    public String getSelectSQL03()
    {
        return selectSQL03;
    }

    public String getSelectSQL04()
    {
        return selectSQL04;
    }

    public String getSelectSQL05()
    {
        return selectSQL05;
    }

    public String getSelectSQL06()
    {
        return selectSQL06;
    }

    public String getSelectSQL07()
    {
        return selectSQL07;
    }

    public String getSelectSQL08()
    {
        return selectSQL08;
    }

    public String getSubAreaNumb1()
    {
        return subareanumb1;
    }

    public String getTableName1()
    {
        return tablename1;
    }

    public String getTableName2()
    {
        return tablename2;
    }

    public String getTableName3()
    {
        return tablename3;
    }

    public String getTableName4()
    {
        return tablename4;
    }

    public String getTableName5()
    {
        return tablename5;
    }

    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("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement01.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("fixturenumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect02()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement02 = new SelectStatement();
        selectStatement02.setConnection(connBean);
        statementmetadata = selectStatement02.getMetaData();
        statementmetadata.setSQL(getSelectSQL02());
        statementmetadata.addTable(getTableName1());
        statementmetadata.addParameter("apparatuskind", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement02.setParameter("apparatuskind", getApparatusKind());
        selectStatement02.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("apparatusnumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect03()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement03 = new SelectStatement();
        selectStatement03.setConnection(connBean);
        statementmetadata = selectStatement03.getMetaData();
        statementmetadata.setSQL(getSelectSQL03());
        statementmetadata.addTable(getTableName1());
        statementmetadata.addParameter("apparatuskind", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement03.setParameter("apparatuskind", getApparatusKind());
        selectStatement03.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("apparatusnumb2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect04()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement04 = new SelectStatement();
        selectStatement04.setConnection(connBean);
        statementmetadata = selectStatement04.getMetaData();
        statementmetadata.setSQL(getSelectSQL04());
        statementmetadata.addTable(getTableName1());
        statementmetadata.addParameter("apparatuskind", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement04.setParameter("apparatuskind", getApparatusKind());
        selectStatement04.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("apparatusnumb3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect05()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement05 = new SelectStatement();
        selectStatement05.setConnection(connBean);
        statementmetadata = selectStatement05.getMetaData();
        statementmetadata.setSQL(getSelectSQL05());
        statementmetadata.addTable(getTableName2());
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement05.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("anumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect06(int i)
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement06 = new SelectStatement();
        selectStatement06.setConnection(connBean);
        statementmetadata = selectStatement06.getMetaData();
        statementmetadata.setSQL(getSelectSQL06());
        statementmetadata.addTable(getTableName3());
        statementmetadata.addParameter("subareanumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement06.setParameter("subareanumb1", getSubAreaNumb1());
        selectStatement06.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("numberb" + i, class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("buildingnumb" + i, class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("doorcount" + i, class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect07(int i)
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement07 = new SelectStatement();
        selectStatement07.setConnection(connBean);
        statementmetadata = selectStatement07.getMetaData();
        statementmetadata.setSQL(getSelectSQL07());
        statementmetadata.addTable(getTableName4());
        statementmetadata.addParameter("subareanumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("buildingnumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doornumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement07.setParameter("subareanumb1", getSubAreaNumb1());
        selectStatement07.setParameter("buildingnumb1", getBuildingNumb1());
        selectStatement07.setParameter("doornumb1", getDoorNumb1());
        selectStatement07.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("numberc" + i, class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("floornumb" + i, class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cellnumb" + i, class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("owner" + i, class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect08()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement08 = new SelectStatement();
        selectStatement08.setConnection(connBean);
        statementmetadata = selectStatement08.getMetaData();
        statementmetadata.setSQL(getSelectSQL08());
        statementmetadata.addTable(getTableName5());
        statementmetadata.addParameter("subareanumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("buildingnumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doornumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floornumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cellnumb1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement08.setParameter("subareanumb1", getSubAreaNumb1());
        selectStatement08.setParameter("buildingnumb1", getBuildingNumb1());
        selectStatement08.setParameter("doornumb1", getDoorNumb1());
        selectStatement08.setParameter("floornumb1", getFloorNumb1());
        selectStatement08.setParameter("cellnumb1", getCellNumb1());
        selectStatement08.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("numberco", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("ownername", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

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

            default:
                throw dataexception;
            }
        }
    }

    public void select02()
        throws Exception
    {
        try
        {
            try
            {
                initSelect02();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement02.execute();
            result = selectStatement02.getResult();
            result.firstRow();
            setStatusCode(1088);
            setStatusMessage("检索指定类型的三表的编号成功完成");
        }
        catch(DataException dataexception)
        {
            setStatusCode(1089);
            setStatusMessage("检索指定类型的三表的编号时出错：" + dataexception.getMessage());
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有符合条件的三表");
                setStatusCode(1089);
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void select03()