retrievetodayfeedbbean.java

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

            statementmetadata.addParameter("feedate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("planmaker1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("feedate1", Date.valueOf(getFeedate()));
            selectStatement01.setParameter("planmaker1", getPlanmaker());
            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("feedate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("plandate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("feedate1", Date.valueOf(getFeedate()));
            selectStatement01.setParameter("plandate1", Date.valueOf(getPlandate()));
            break;

        default:
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("feedate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("feedate1", Date.valueOf(getFeedate()));
            break;
        }
    }

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

            default:
                throw dataexception;
            }
        }
    }

    public void setAllSqlStatement()
    {
        allSqlStatement.addElement(new String("SELECT NUMBER,feenum,feemethod,planmaker,plandate FROM feeplan WHERE ((DELFLAG=?)AND (feedate=? )) ORDER BY feenum DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,feenum,feemethod,planmaker,plandate FROM feeplan WHERE ((DELFLAG=?)AND (feedate=? )AND (feenum=? )) ORDER BY feenum DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,feenum,feemethod,planmaker,plandate FROM feeplan WHERE ((DELFLAG=?)AND (feedate=? )AND (feemethod like ?)) ORDER BY  feenum  DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,feenum,feemethod,planmaker,plandate FROM feeplan WHERE ((DELFLAG=?)AND (feedate=? )AND (planmaker like ?)) ORDER  BY  feenum DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,feenum,feemethod,planmaker,plandate FROM feeplan WHERE ((DELFLAG=?)AND (feedate=? )AND (plandate like ? )) ORDER BY  feenum DESC"));
    }

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

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

    public void setFeedate(String s)
    {
        feedate = s;
    }

    public void setFeemethod(String s)
    {
        feemethod = s;
    }

    public void setFeenum(String s)
    {
        if(s.equals(""))
            feenum = "0";
        else
            feenum = s;
    }

    public void setFeetime(String s)
    {
        feetime = s;
    }

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

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

    public void setPlandate(String s)
    {
        if(s.length() != 10)
            plandate = "2001-01-01";
        else
            plandate = s;
    }

    public void setPlanmaker(String s)
    {
        planmaker = 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"));
                    feenumvec.addElement(result.getColumnValueToString("feenum"));
                    feemethodvec.addElement(result.getColumnValueToString("feemethod"));
                    planmakervec.addElement(result.getColumnValueToString("planmaker"));
                    plandatevec.addElement(result.getColumnValueToString("plandate"));
                }

                setStatusCode(0x61ed0);
                setStatusMessage("查询主题下所有文章成功");
            } else
            {
                setStatusCode(0x61ed1);
                setStatusMessage("对不起，没有符合条件的文章");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(0x61ed2);
            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 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";
    }
}