retrieveownerpaperdbbean.java

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

        case 1: // '\001'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("ldate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("ldate2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("ldate3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("ldate1", Date.valueOf(getLdate()));
            selectStatement01.setParameter("ldate2", Date.valueOf(getEnddate()));
            selectStatement01.setParameter("ldate3", Date.valueOf(getLdate()));
            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("tenement1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("tenement1", getTenement());
            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("tenementno1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("tenementno1", getTenementno());
            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("admin1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("admin1", getAdmin());
            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(0x77df9);
            setStatusMessage("查询所有文章失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x77dfa);
            setStatusMessage("查询所有文章的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(0x77dfb);
                setStatusMessage("查询所有文章的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

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

    public void setAllSqlStatement()
    {
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,LDATE,TENEMENT,TENEMENTNO FROM LIVEOWNER WHERE (DELFLAG=?) ORDER BY LDATE DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,LDATE,TENEMENT,TENEMENTNO FROM LIVEOWNER WHERE ((DELFLAG=?)AND ((LDATE >= ?)AND(LDATE<=?)OR(LDATE=?))) ORDER BY LDATE DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,LDATE,TENEMENT,TENEMENTNO FROM LIVEOWNER WHERE ((DELFLAG=?)AND (TENEMENT like ?)) ORDER BY  LDATE  DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,LDATE,TENEMENT,TENEMENTNO FROM LIVEOWNER WHERE ((DELFLAG=?)AND (TENEMENTNO like ?)) ORDER  BY  LDATE  DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,LDATE,TENEMENT,TENEMENTNO FROM LIVEOWNER WHERE ((DELFLAG=?)AND (ADMIN like ? )) ORDER BY  LDATE  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 setFloor(String s)
    {
        floor = s;
    }

    public void setLdate(String s)
    {
        ldate = s;
    }

    public void setMemo1(String s)
    {
        memo1 = s;
    }

    public void setMemo2(String s)
    {
        memo2 = s;
    }

    public void setMemo3(String s)
    {
        memo3 = s;
    }

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

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

    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"));
                    ldatevec.addElement(result.getColumnValueToString("ldate"));
                    tenementvec.addElement(result.getColumnValueToString("tenement"));
                    tenementnovec.addElement(result.getColumnValueToString("tenementno"));
                }

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

    public void setTenementno(String s)
    {
        tenementno = 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";
    }
}