retrievebycdbbean.java

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

        }
        if(getPara().equals("2"))
        {
            statementmetadata.addParameter("num", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
            selectStatement02.setParameter("num", new Integer(getNumber()));
            statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
            statementmetadata.addColumn("picname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            statementmetadata.addColumn("picdescribe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        }
    }

    public void select01()
        throws Exception
    {
        if(getPara().equals("0"))
            try
            {
                initSelect01();
                selectStatement01.execute();
                result = selectStatement01.getResult();
                result.firstRow();
                setStatusCode(1083);
                setStatusMessage("查询分区资料成功！");
            }
            catch(DataException dataexception)
            {
                setStatusCode(1084);
                setStatusMessage("查询分区资料数据时出错！");
                switch(dataexception.getErrorCode())
                {
                case 214: 
                    setStatusCode(1084);
                    setStatusMessage("没有符合条件的分区资料信息");
                    break;

                default:
                    throw dataexception;
                }
            }
        if(getPara().equals("1"))
            try
            {
                initSelect01();
                selectStatement01.execute();
                result = selectStatement01.getResult();
                result.firstRow();
                setStatusCode(1059);
                setStatusMessage("查询楼宇资料成功！");
            }
            catch(DataException dataexception1)
            {
                setStatusCode(1060);
                setStatusMessage("查询楼宇资料数据时出错！");
                switch(dataexception1.getErrorCode())
                {
                case 214: 
                    setStatusCode(1060);
                    setStatusMessage("没有符合条件的楼宇资料信息");
                    break;

                default:
                    throw dataexception1;
                }
            }
        if(getPara().equals("2"))
            try
            {
                initSelect01();
                selectStatement01.execute();
                result = selectStatement01.getResult();
                result.firstRow();
                setStatusCode(1067);
                setStatusMessage("查询单元资料成功！");
            }
            catch(DataException dataexception2)
            {
                setStatusCode(1068);
                setStatusMessage("查询单元资料数据时出错！");
                switch(dataexception2.getErrorCode())
                {
                case 214: 
                    setStatusCode(1068);
                    setStatusMessage("没有符合条件的单元资料信息");
                    break;

                default:
                    throw dataexception2;
                }
            }
    }

    public void select02()
        throws Exception
    {
        if(getPara().equals("0"))
            try
            {
                initSelect02();
                selectStatement02.execute();
                result = selectStatement02.getResult();
                result.firstRow();
                setStatusCode(1083);
                setStatusMessage("查询分区资料成功！");
            }
            catch(DataException dataexception)
            {
                setStatusCode(1084);
                setStatusMessage("查询分区资料数据时出错！");
                switch(dataexception.getErrorCode())
                {
                case 214: 
                    setStatusCode(1184);
                    setStatusMessage("没有符合条件的分区资料信息");
                    break;

                default:
                    throw dataexception;
                }
            }
        if(getPara().equals("1"))
            try
            {
                initSelect02();
                selectStatement02.execute();
                result = selectStatement02.getResult();
                result.firstRow();
                setStatusCode(1059);
                setStatusMessage("查询楼宇资料成功！");
            }
            catch(DataException dataexception1)
            {
                setStatusCode(1060);
                setStatusMessage("查询楼宇资料数据时出错！");
                switch(dataexception1.getErrorCode())
                {
                case 214: 
                    setStatusCode(1160);
                    setStatusMessage("没有符合条件的楼宇资料信息");
                    break;

                default:
                    throw dataexception1;
                }
            }
        if(getPara().equals("2"))
            try
            {
                initSelect02();
                selectStatement02.execute();
                result = selectStatement02.getResult();
                result.firstRow();
                setStatusCode(1067);
                setStatusMessage("查询单元资料成功！");
            }
            catch(DataException dataexception2)
            {
                setStatusCode(1068);
                setStatusMessage("查询单元资料数据时出错！");
                switch(dataexception2.getErrorCode())
                {
                case 214: 
                    setStatusCode(1168);
                    setStatusMessage("没有符合条件的单元资料信息");
                    break;

                default:
                    throw dataexception2;
                }
            }
    }

    public void setBuildingnumb(String s)
    {
        buildingnumb = s;
    }

    public void setCellnumb(String s)
    {
        cellnumb = s;
    }

    public void setDoornumb(String s)
    {
        doornumb = s;
    }

    public void setFloornumb(String s)
    {
        floornumb = s;
    }

    public void setNumber(String s)
    {
        number = s;
    }

    public void setPara(String s)
    {
        para = s;
    }

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

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

    public void setSubareanumb(String s)
    {
        subareanumb = s;
    }
}