treedbbean.java

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

        throws Exception
    {
        try
        {
            try
            {
                initSelect03();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement03.execute();
            result = selectStatement03.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 select04()
        throws Exception
    {
        try
        {
            try
            {
                initSelect04();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement04.execute();
            result = selectStatement04.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 select05()
        throws Exception
    {
        try
        {
            try
            {
                initSelect05();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement05.execute();
            result = selectStatement05.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 select06(int i)
        throws Exception
    {
        try
        {
            try
            {
                initSelect06(i);
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement06.execute();
            result = selectStatement06.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 select07(int i)
        throws Exception
    {
        try
        {
            try
            {
                initSelect07(i);
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement07.execute();
            result = selectStatement07.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 select08()
        throws Exception
    {
        try
        {
            try
            {
                initSelect08();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            selectStatement08.execute();
            result = selectStatement08.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 setApparatusKind(String s)
    {
        apparatuskind = s;
    }

    public void setBuildingNumb1(String s)
    {
        buildingnumb1 = s;
    }

    public void setCellNumb1(String s)
    {
        cellnumb1 = s;
    }

    public void setDelFlag(String s)
    {
        delflag = s;
    }

    public void setDoorNumb1(String s)
    {
        doornumb1 = s;
    }

    public void setFloorNumb1(String s)
    {
        floornumb1 = s;
    }

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

    public void setSelectSQL02(String s)
    {
        selectSQL02 = s;
    }

    public void setSelectSQL03(String s)
    {
        selectSQL03 = s;
    }

    public void setSelectSQL04(String s)
    {
        selectSQL04 = s;
    }

    public void setSelectSQL05(String s)
    {
        selectSQL05 = s;
    }

    public void setSelectSQL06(String s)
    {
        selectSQL06 = s;
    }

    public void setSelectSQL07(String s)
    {
        selectSQL07 = s;
    }

    public void setSelectSQL08(String s)
    {
        selectSQL08 = s;
    }

    public void setSubAreaNumb1(String s)
    {
        subareanumb1 = s;
    }

    public void setTableName1(String s)
    {
        tablename1 = s;
    }

    public void setTableName2(String s)
    {
        tablename2 = s;
    }

    public void setTableName3(String s)
    {
        tablename3 = s;
    }

    public void setTableName4(String s)
    {
        tablename4 = s;
    }

    public void setTableName5(String s)
    {
        tablename5 = s;
    }
}