dspaddotherfeedbbean.java

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

    }

    public String getSelectSQL04()
    {
        return selectSQL04;
    }

    public String getSubAreaNumb()
    {
        return subAreaNumb;
    }

    public String getTableName1()
    {
        return tableName1;
    }

    public String getTableName2()
    {
        return tableName2;
    }

    public void initSelect01()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement01 = new SelectStatement();
        selectStatement01.setConnection(connBean);
        statementmetadata = selectStatement01.getMetaData();
        statementmetadata.setSQL(getSelectSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("itemnum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 12);
        selectStatement01.setParameter("subareanumb", getSubAreaNumb());
        selectStatement01.setParameter("buildingnumb", getBuildingNumb());
        selectStatement01.setParameter("doornumb", getDoorNumb());
        selectStatement01.setParameter("floornumb", getFloorNumb());
        selectStatement01.setParameter("cellnumb", getCellNumb());
        selectStatement01.setParameter("itemnum", new Integer(getItemNum()));
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("cashflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addColumn("feeunits", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("fee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("startdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("enddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("paystartdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("payenddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
    }

    public void initSelect03()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement03 = new SelectStatement();
        selectStatement03.setConnection(connBean);
        statementmetadata = selectStatement03.getMetaData();
        statementmetadata.setSQL(getSelectSQL03());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement03.setParameter("subareanumb", getSubAreaNumb());
        selectStatement03.setParameter("buildingnumb", getBuildingNumb());
        selectStatement03.setParameter("doornumb", getDoorNumb());
        selectStatement03.setParameter("floornumb", getFloorNumb());
        selectStatement03.setParameter("cellnumb", getCellNumb());
        if(getFlag().trim().equals("2"))
            statementmetadata.addColumn("floortype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        else
            statementmetadata.addColumn("tenement", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect04()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement04 = new SelectStatement();
        selectStatement04.setConnection(connBean);
        statementmetadata = selectStatement04.getMetaData();
        statementmetadata.setSQL(getSelectSQL04());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        selectStatement04.setParameter("number", new Integer(getItemNum()));
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("feename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("latefeerate", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("feeunit", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("feestandard", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("latefeedays", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("cycleflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusMessage("检索收费记录成功");
            setStatusCode(7641);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费记录出错");
            setStatusCode(7650);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该缴纳的收费记录信息");
                setStatusCode(7651);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void select03()
        throws Exception
    {
        try
        {
            initSelect03();
            selectStatement03.execute();
            result = selectStatement03.getResult();
            result.firstRow();
            setStatusMessage("查询缴纳其他费用用户的姓名成功");
            setStatusCode(7641);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("查询缴纳其他费用用户的姓名时出错");
            setStatusCode(7643);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该缴纳其他费用用户的姓名");
                setStatusCode(7644);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void select04()
        throws Exception
    {
        try
        {
            initSelect04();
            selectStatement04.execute();
            result = selectStatement04.getResult();
            result.firstRow();
            setStatusMessage("检索收费项目信息成功");
            setStatusCode(7641);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("检索收费项目信息时出错");
            setStatusCode(7647);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有收费项目信息");
                setStatusCode(7648);
                break;

            default:
                throw new Exception(getStatusMessage() + dataexception);
            }
        }
    }

    public void setAllFee(String s)
    {
        allFee = s;
    }

    public void setBaseFeeNum(String s)
    {
        baseFeeNum = s;
    }

    public void setBuildingNumb(String s)
    {
        buildingNumb = s;
    }

    public void setCellNumb(String s)
    {
        cellNumb = s;
    }

    public void setDoorNumb(String s)
    {
        doorNumb = s;
    }

    public void setFlag(String s)
    {
        flag = s;
    }

    public void setFloorNumb(String s)
    {
        floorNumb = s;
    }

    public void setFloortype(String s)
    {
        floortype = s;
    }

    public void setItemNum(String s)
    {
        itemNum = s;
    }

    public void setLateDays()
    {
        Calendar calendar = Calendar.getInstance();
        calendar.add(2, 1);
        Calendar calendar1 = Calendar.getInstance();
        int i = 0;
        if(!((String)vecQ7.elementAt(0)).equals(""))
            i = Integer.parseInt((String)vecQ7.elementAt(0));
        for(int j = 0; j < vecQ9.size(); j++)
        {
            int k = 0;
            String s = (String)vecQ17.elementAt(j);
            calendar1.set(Integer.parseInt(s.substring(0, 4)), Integer.parseInt(s.substring(5, 7)), Integer.parseInt(s.substring(8, 10)));
            calendar1.add(5, i);
            while(calendar1.before(calendar)) 
            {
                calendar1.add(5, 1);
                k++;
            }
            vecQ18.addElement(String.valueOf(k));
        }

    }

    public void setOwnerName(String s)
    {
        ownerName = s;
    }

    public void setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }

    public void setSelectSQL03(String s)
    {
        selectSQL03 = s;
    }

    public void setSelectSQL04(String s)
    {
        selectSQL04 = s;
    }

    public void setSubAreaNumb(String s)
    {
        subAreaNumb = s;
    }

    public void setTableName1(String s)
    {
        tableName1 = s;
    }

    public void setTableName2(String s)
    {
        tableName2 = s;
    }
}