statfitapplydbbean.java

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

    public Vector getNamevec1()
    {
        return namevec1;
    }

    public String getNoses()
    {
        return noses;
    }

    public String getNumber()
    {
        return number;
    }

    public Vector getNumbervec()
    {
        return numbervec;
    }

    public Vector getNumbervec1()
    {
        return numbervec1;
    }

    public String getOverduedays()
    {
        return overduedays;
    }

    public String getOverduefee()
    {
        return overduefee;
    }

    public String getOwneridno()
    {
        return owneridno;
    }

    public String getOwnertel()
    {
        return ownertel;
    }

    public int getPagecount()
    {
        return pagecount;
    }

    public int getPageindex()
    {
        return pageindex;
    }

    public String getPaperdate()
    {
        return paperdate;
    }

    public String getPaperman()
    {
        return paperman;
    }

    public String getRemark()
    {
        return remark;
    }

    public String getRetrievecom()
    {
        return retrievecom;
    }

    public String getRetrievecon()
    {
        return retrievecon;
    }

    public String getRetrieveindex()
    {
        return retrieveindex;
    }

    public Vector getReturnsignvec1()
    {
        return returnsignvec1;
    }

    public String getSelect02()
    {
        return select02;
    }

    public String getSign()
    {
        return sign;
    }

    public Vector getSignvec()
    {
        return signvec;
    }

    public Vector getSignvec1()
    {
        return signvec1;
    }

    public String getStair()
    {
        return stair;
    }

    public Vector getStairvec()
    {
        return stairvec;
    }

    public Vector getStairvec1()
    {
        return stairvec1;
    }

    public String getStartdate()
    {
        return startdate;
    }

    public String getSubarea()
    {
        return subarea;
    }

    public Vector getSubareavec()
    {
        return subareavec;
    }

    public Vector getSubareavec1()
    {
        return subareavec1;
    }

    public String getTeam()
    {
        return team;
    }

    public String getTeamgrantno()
    {
        return teamgrantno;
    }

    public String getTeamlevel()
    {
        return teamlevel;
    }

    public String getTeamno()
    {
        return teamno;
    }

    public String getTouchway()
    {
        return touchway;
    }

    public Vector getTouchwayvec()
    {
        return touchwayvec;
    }

    public Vector getTouchwayvec1()
    {
        return touchwayvec1;
    }

    public String getTransactor()
    {
        return transactor;
    }

    public String getUpdownindex()
    {
        return updownindex;
    }

    protected void initSelect02()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        selectSql02 = new SelectStatement();
        selectSql02.setConnection(connBean);
        statementmetadata = selectSql02.getMetaData();
        statementmetadata.setSQL(getSelect02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("subarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("touchway", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("applydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("apply", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("approvedate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("deposit", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("accept1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptdate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("accept2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptdate2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("acceptsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("returnsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        switch(Integer.parseInt(getRetrieveindex()))
        {
        case 0: // '\0'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            selectSql02.setParameter("delflag", getDelflag());
            break;

        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("name2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("name2", getName());
            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("team2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("team2", getTeam());
            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("approveman2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("approveman2", getApproveman());
            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("acceptman21", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            statementmetadata.addParameter("acceptman22", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("acceptman21", getAcceptman1());
            selectSql02.setParameter("acceptman22", getAcceptman2());
            break;

        case 5: // '\005'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("transactor2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("transactor2", getTransactor());
            break;

        case 6: // '\006'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("day2", Date.valueOf(getDate()));
            selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day4", Date.valueOf(getDate()));
            break;

        case 7: // '\007'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("day2", Date.valueOf(getDate()));
            selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day4", Date.valueOf(getDate()));
            break;

        case 8: // '\b'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("day2", Date.valueOf(getDate()));
            selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day4", Date.valueOf(getDate()));
            break;

        case 9: // '\t'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("day2", Date.valueOf(getDate()));
            selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day4", Date.valueOf(getDate()));
            break;

        case 10: // '\n'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day5", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day6", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("day7", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectSql02.setParameter("delflag", getDelflag());
            selectSql02.setParameter("day2", Date.valueOf(getDate()));
            selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day4", Date.valueOf(getDate()));
            selectSql02.setParameter("day5", Date.valueOf(getDate()));
            selectSql02.setParameter("day6", Date.valueOf(getEnddate()));
            selectSql02.setParameter("day7", Date.valueOf(getDate()));
            break;

        default:
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            selectSql02.setParameter("delflag", getDelflag());
            break;
        }
    }

    public void select02()
        throws Exception
    {
        try
        {
            initSelect02();
            selectSql02.execute();
            result = selectSql02.getResult();
            setStatusCode(2052);
            setStatusMessage("查询所有装修申请记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(2053);
            setStatusMessage("查询所有装修申请记录的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(2054);
                setStatusMessage("查询所有装修申请记录的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAccept1(String s)
    {
        accept1 = s;
    }

    public void setAccept2(String s)
    {
        accept2 = s;
    }

    public void setAcceptdate1(String s)
    {
        acceptdate1 = s;
    }

    public void setAcceptdate2(String s)
    {
        acceptdate2 = s;
    }

    public void setAcceptman1(String s)
    {
        acceptman1 = s;
    }

    public void setAcceptman2(String s)
    {
        acceptman2 = s;
    }

    public void setAcceptsign(String s)
    {
        acceptsign = s;
    }

    public void setAllSqlStatement()
    {