siretrieveroomexamdbbean.java

来自「JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的」· Java 代码 · 共 790 行 · 第 1/2 页

        statementmetadata.addColumn("ceiling", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("wall", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("lfloor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("door", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("doorlock", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("windows", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("antenna", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("light", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("lswitch", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("jack", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("casement", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cloaca", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("downcomer", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("pipe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("dishpan", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("valve", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("tap", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("stool", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("gaspipe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("gasmeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("watermeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("ammeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("powerbox", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("airswitch", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("interphone", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("doorbell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("gasnumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("waternumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("powernumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("useridea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("adminidea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("admin", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        selectSqlThe.setParameter("number", new Integer(getNumber()));
    }

    public void selectThe()
        throws Exception
    {
        try
        {
            initSelectThe();
            selectSqlThe.execute();
            result = selectSqlThe.getResult();
            setStatusCode(0x72f75);
            setStatusMessage("查询指定记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x72f76);
            setStatusMessage("查询指定记录的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(0x72f77);
                setStatusMessage("查询指定记录的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAdmin(String s)
    {
        admin = s;
    }

    public void setAdminidea(String s)
    {
        adminidea = s;
    }

    public void setAirswitch(String s)
    {
        airswitch = s;
    }

    public void setAmmeter(String s)
    {
        ammeter = s;
    }

    public void setAntenna(String s)
    {
        antenna = s;
    }

    public void setBuilding(String s)
    {
        building = s;
    }

    public void setCasement(String s)
    {
        casement = s;
    }

    public void setCeiling(String s)
    {
        ceiling = s;
    }

    public void setCell(String s)
    {
        cell = s;
    }

    public void setCheckdate(String s)
    {
        checkdate = s;
    }

    public void setCheckitem(String s)
    {
        checkitem = s;
    }

    public void setCheckman(String s)
    {
        checkman = s;
    }

    public void setCloaca(String s)
    {
        cloaca = s;
    }

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

    public void setDishpan(String s)
    {
        dishpan = s;
    }

    public void setDoor(String s)
    {
        door = s;
    }

    public void setDoorbell(String s)
    {
        doorbell = s;
    }

    public void setDoorlock(String s)
    {
        doorlock = s;
    }

    public void setDowncomer(String s)
    {
        downcomer = s;
    }

    public void setFloor(String s)
    {
        floor = s;
    }

    public void setGasmeter(String s)
    {
        gasmeter = s;
    }

    public void setGasnumber(String s)
    {
        gasnumber = s;
    }

    public void setGaspipe(String s)
    {
        gaspipe = s;
    }

    public void setInterphone(String s)
    {
        interphone = s;
    }

    public void setJack(String s)
    {
        jack = s;
    }

    public void setLfloor(String s)
    {
        lfloor = s;
    }

    public void setLight(String s)
    {
        light = s;
    }

    public void setLswitch(String s)
    {
        lswitch = s;
    }

    public void setMagicindex(String s)
    {
        magicindex = s;
    }

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

    public void setPagecount(String s)
    {
        pagecount = s;
    }

    public void setPageindex(String s)
    {
        pageindex = s;
    }

    public void setPipe(String s)
    {
        pipe = s;
    }

    public void setPowerbox(String s)
    {
        powerbox = s;
    }

    public void setPowernumber(String s)
    {
        powernumber = s;
    }

    public void setResultThe()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() != 0)
            {
                result.firstRow();
                setSubArea(result.getColumnValueToString("subarea"));
                setBuilding(result.getColumnValueToString("building"));
                setStair(result.getColumnValueToString("stair"));
                setFloor(result.getColumnValueToString("floor"));
                setCell(result.getColumnValueToString("cell"));
                setCheckman(result.getColumnValueToString("checkman"));
                if(result.getColumnValue("checkdate") == null)
                    setCheckdate("");
                else
                    setCheckdate(result.getColumnValueToString("checkdate"));
                setCheckitem(result.getColumnValueToString("checkitem"));
                setCeiling(result.getColumnValueToString("ceiling"));
                setWall(result.getColumnValueToString("wall"));
                setLfloor(result.getColumnValueToString("lfloor"));
                setDoor(result.getColumnValueToString("door"));
                setDoorlock(result.getColumnValueToString("doorlock"));
                setWindows(result.getColumnValueToString("windows"));
                setAntenna(result.getColumnValueToString("antenna"));
                setLight(result.getColumnValueToString("light"));
                setLswitch(result.getColumnValueToString("lswitch"));
                setJack(result.getColumnValueToString("jack"));
                setCasement(result.getColumnValueToString("casement"));
                setCloaca(result.getColumnValueToString("cloaca"));
                setDowncomer(result.getColumnValueToString("downcomer"));
                setPipe(result.getColumnValueToString("pipe"));
                setDishpan(result.getColumnValueToString("dishpan"));
                setValve(result.getColumnValueToString("valve"));
                setTap(result.getColumnValueToString("tap"));
                setStool(result.getColumnValueToString("stool"));
                setGaspipe(result.getColumnValueToString("gaspipe"));
                setGasmeter(result.getColumnValueToString("gasmeter"));
                setWatermeter(result.getColumnValueToString("watermeter"));
                setAmmeter(result.getColumnValueToString("ammeter"));
                setPowerbox(result.getColumnValueToString("powerbox"));
                setAirswitch(result.getColumnValueToString("airswitch"));
                setInterphone(result.getColumnValueToString("interphone"));
                setDoorbell(result.getColumnValueToString("doorbell"));
                if(result.getColumnValue("gasnumber") == null)
                    setGasnumber("");
                else
                    setGasnumber(result.getColumnValueToString("gasnumber"));
                if(result.getColumnValue("waternumber") == null)
                    setWaternumber("");
                else
                    setWaternumber(result.getColumnValueToString("waternumber"));
                if(result.getColumnValue("powernumber") == null)
                    setPowernumber("");
                else
                    setPowernumber(result.getColumnValueToString("powernumber"));
                setUseridea(result.getColumnValueToString("useridea"));
                setAdminidea(result.getColumnValueToString("adminidea"));
                setAdmin(result.getColumnValueToString("admin"));
                setStatusCode(0x77ba4);
                setStatusMessage("查询指定记录成功");
            } else
            {
                setStatusCode(0x77ba5);
                setStatusMessage("对不起，没有符合条件的记录");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(0x77ba6);
            setStatusMessage("处理指定记录结果集出错");
            throw exception1;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void setRetrievecom(String s)
    {
        retrievecom = s;
    }

    public void setRetrievecon(String s)
    {
        retrievecon = s;
    }

    public void setRetrieveindex(String s)
    {
        retrieveindex = s;
    }

    public void setSelectThe(String s)
    {
        selectThe = s;
    }

    public void setSelectnum(String s)
    {
        selectnum = s;
    }

    public void setStair(String s)
    {
        stair = s;
    }

    public void setStool(String s)
    {
        stool = s;
    }

    public void setSubArea(String s)
    {
        subarea = s;
    }

    public void setTap(String s)
    {
        tap = s;
    }

    public void setUseridea(String s)
    {
        useridea = s;
    }

    public void setValve(String s)
    {
        valve = s;
    }

    public void setWall(String s)
    {
        wall = s;
    }

    public void setWatermeter(String s)
    {
        watermeter = s;
    }

    public void setWaternumber(String s)
    {
        waternumber = s;
    }

    public void setWindows(String s)
    {
        windows = s;
    }
}