retrieveemptydbbean.java

华磊物业管理系统源码 (仅供参考)

            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("usedate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("usedate2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("usedate3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("usedate1", Date.valueOf(getUsedate()));
            selectStatement01.setParameter("usedate2", Date.valueOf(getEnddate()));
            selectStatement01.setParameter("usedate3", Date.valueOf(getUsedate()));
            break;

        case 2: // '\002'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("usedept1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("usedept1", getUsedept());
            break;

        case 3: // '\003'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("usetype1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("usetype1", getUsetype());
            break;

        case 4: // '\004'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("recorder1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("recorder1", getRecorder());
            break;

        default:
            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());
            break;
        }
    }

    public void selectSQL01()
        throws Exception
    {
        try
        {
            initSelectSQL011();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            setStatusCode(0x693fd);
            setStatusMessage("查询所有文章失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x693fe);
            setStatusMessage("查询所有文章的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(0x693ff);
                setStatusMessage("查询所有文章的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAllSqlStatement()
    {
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,USETYPE,USEDATE,RECORDER FROM EMPTYUSE WHERE (DELFLAG=?) ORDER BY USEDATE DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,USETYPE,USEDATE,RECORDER FROM EMPTYUSE WHERE ((DELFLAG=?)AND ((USEDATE >= ?)AND(USEDATE<=?)OR(USEDATE=?))) ORDER BY USEDATE DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,USETYPE,USEDATE,RECORDER FROM EMPTYUSE WHERE ((DELFLAG=?)AND (USEDEPT like ?)) ORDER BY  USEDATE  DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,USETYPE,USEDATE,RECORDER FROM EMPTYUSE WHERE ((DELFLAG=?)AND (USETYPE like ?)) ORDER  BY  USEDATE DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,USETYPE,USEDATE,RECORDER FROM EMPTYUSE WHERE ((DELFLAG=?)AND (RECORDER like ? )) ORDER BY  USEDATE DESC"));
    }

    public void setAllcheck(String s)
    {
        allcheck = s;
    }

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

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

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

    public void setEnddate(String s)
    {
        enddate = s;
    }

    public void setExponent(String s)
    {
        exponent = s;
    }

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

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

    public void setPageindex(int i)
    {
        pageindex = i;
    }

    public void setRecorder(String s)
    {
        recorder = s;
    }

    public void setRemark(String s)
    {
        remark = s;
    }

    public void setResultall()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() != 0)
            {
                setAllcheck(String.valueOf(result.getNumRowsInCache()));
                if(result.getNumRowsInCache() % 5 != 0)
                {
                    if(result.getNumRowsInCache() > 5)
                        pagecount = result.getNumRowsInCache() / 5;
                    else
                        pagecount = 0;
                } else
                if(result.getNumRowsInCache() > 5)
                    pagecount = result.getNumRowsInCache() / 5 - 1;
                else
                    pagecount = 0;
                for(int i = 5 * pageindex; i < 5 * (pageindex + 1); i++)
                {
                    if(i == result.getNumRowsInCache())
                        break;
                    result.setCurrentRow(i + 1);
                    numbervec.addElement(result.getColumnValueToString("number"));
                    subareavec.addElement(result.getColumnValueToString("subarea"));
                    buildingvec.addElement(result.getColumnValueToString("building"));
                    stairvec.addElement(result.getColumnValueToString("stair"));
                    floorvec.addElement(result.getColumnValueToString("floor"));
                    cellvec.addElement(result.getColumnValueToString("cell"));
                    usetypevec.addElement(result.getColumnValueToString("usetype"));
                    usedatevec.addElement(result.getColumnValueToString("usedate"));
                    recordervec.addElement(result.getColumnValueToString("recorder"));
                }

                setStatusCode(0x69400);
                setStatusMessage("查询主题下所有文章成功");
            } else
            {
                setStatusCode(0x69401);
                setStatusMessage("对不起，没有符合条件的文章");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(0x69402);
            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 setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }

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

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

    public void setTheSqlStatement()
    {
        switch(Integer.parseInt(getRetrieveindex()))
        {
        case 0: // '\0'
            setSelectSQL01((String)allSqlStatement.elementAt(0));
            break;

        case 1: // '\001'
            setSelectSQL01((String)allSqlStatement.elementAt(1));
            break;

        case 2: // '\002'
            setSelectSQL01((String)allSqlStatement.elementAt(2));
            break;

        case 3: // '\003'
            setSelectSQL01((String)allSqlStatement.elementAt(3));
            break;

        case 4: // '\004'
            setSelectSQL01((String)allSqlStatement.elementAt(4));
            break;

        default:
            setSelectSQL01((String)allSqlStatement.elementAt(0));
            break;
        }
    }

    public void setUpdownindex()
    {
        int i = getPageindex();
        int j = getPagecount();
        if((i == 0) & (j != 0))
            updownindex = "1";
        if((i == j) & (j != 0))
            updownindex = "2";
        if((i > 0) & (i < j))
            updownindex = "3";
    }

    public void setUsedate(String s)
    {
        usedate = s;
    }

    public void setUsedept(String s)
    {
        usedept = s;
    }

    public void setUsetype(String s)
    {
        usetype = s;
    }
}