manageindbbean.java

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

        insertStatement01.setParameter("nubmer", new Integer(getNumber()));
        insertStatement01.setParameter("feenum", new Integer(getFeeNum()));
        insertStatement01.setParameter("cyclenum", new Integer(getCycleNum()));
        insertStatement01.setParameter("subareanumb", getSubAreaNumb());
        insertStatement01.setParameter("buildingnumb", getBuildingNumb());
        insertStatement01.setParameter("doornumb", getDoorNumb());
        insertStatement01.setParameter("floornumb", getFloorNumb());
        insertStatement01.setParameter("cellnumb", getCellNumb());
        insertStatement01.setParameter("optionname", getOptionName());
        insertStatement01.setParameter("paydate", Date.valueOf(getPayDate()));
        insertStatement01.setParameter("paytime", Time.valueOf(getPayTime()));
        insertStatement01.setParameter("allfee", new Double(getRealFee()));
        insertStatement01.setParameter("delflag", getDelFlag());
    }

    public void initSelect03()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement03 = new SelectStatement();
        selectStatement03.setConnection(connBean);
        statementmetadata = selectStatement03.getMetaData();
        statementmetadata.setSQL(getSelectSQL03());
        statementmetadata.addTable(getTableName1());
        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());
        statementmetadata.addColumn("floortype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
    }

    public void initSelect04()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement04 = new SelectStatement();
        selectStatement04.setConnection(connBean);
        statementmetadata = selectStatement04.getMetaData();
        statementmetadata.setSQL(getSelectSQL04());
        statementmetadata.addTable(getTableName4());
        statementmetadata.addParameter("account", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement04.setParameter("account", getAccount());
        statementmetadata.addColumn("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect05()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement05 = new SelectStatement();
        selectStatement05.setConnection(connBean);
        statementmetadata = selectStatement05.getMetaData();
        statementmetadata.setSQL(getSelectSQL05());
        statementmetadata.addTable(getTableName2());
        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("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        selectStatement05.setParameter("subareanumb", getSubAreaNumb());
        selectStatement05.setParameter("buildingnumb", getBuildingNumb());
        selectStatement05.setParameter("doornumb", getDoorNumb());
        selectStatement05.setParameter("floornumb", getFloorNumb());
        selectStatement05.setParameter("cellnumb", getCellNumb());
        selectStatement05.setParameter("cyclenum", new Integer(getCycleNum()));
        statementmetadata.addColumn("cyclenum1", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("fee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
    }

    protected void initUpdate01()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement01 = new SQLStatement();
        updateStatement01.setConnection(connBean);
        statementmetadata = updateStatement01.getMetaData();
        statementmetadata.setSQL(getUpdateSQL01());
        statementmetadata.addTable(getTableName2());
        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("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        updateStatement01.setParameter("subareanumb", getSubAreaNumb());
        updateStatement01.setParameter("buildingnumb", getBuildingNumb());
        updateStatement01.setParameter("doornumb", getDoorNumb());
        updateStatement01.setParameter("floornumb", getFloorNumb());
        updateStatement01.setParameter("cellnumb", getCellNumb());
        updateStatement01.setParameter("cyclenum", new Integer(getCycleNum()));
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusMessage("成功支付其他费用");
            setStatusCode(7661);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("支付其他费用写日志时出错");
            setStatusCode(7664);
            throw 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(7643);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusMessage("没有该账号所对应的单元");
                setStatusCode(7644);
                break;

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

    public void select05()
        throws Exception
    {
        try
        {
            initSelect05();
            selectStatement05.execute();
            result = selectStatement05.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 setAccount(String s)
    {
        account = s;
    }

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

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

    public void setCycleNum(String s)
    {
        cyclenum = s;
    }

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

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

    public void setFeeNum(String s)
    {
        feenum = s;
    }

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

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

    public void setInsertSQL01(String s)
    {
        insertSQL01 = s;
    }

    public void setOptionName(String s)
    {
        optionname = s;
    }

    public void setPayDate(String s)
    {
        paydate = s;
    }

    public void setPayTime(String s)
    {
        paytime = s;
    }

    public void setRealFee(String s)
    {
        allfee = s;
    }

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

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

    public void setSelectSQL05(String s)
    {
        selectSQL05 = s;
    }

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

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

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

    public void setTableName4(String s)
    {
        tableName4 = s;
    }

    public void setUpdateSQL01(String s)
    {
        updateSQL01 = s;
    }

    public void update01()
        throws Exception
    {
        try
        {
            initUpdate01();
            updateStatement01.execute();
            numAffectedRows = updateStatement01.getNumAffectedRows();
            if(numAffectedRows == -1)
                setStatusMessage("其他数据已成功导入");
            else
                setStatusMessage("成功修改用户付费标志");
            setStatusCode(7621);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("支付三表费用时出错");
            setStatusCode(7622);
            throw dataexception;
        }
    }
}