addbuilddbbean.java

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

        statementmetadata.addParameter("handoverdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("handoverman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        insertStatement01.setParameter("number", new Integer(getNumber()));
        insertStatement01.setParameter("buildingnumb", getBuildingnumb());
        insertStatement01.setParameter("subareanumb", getSubareanumb());
        insertStatement01.setParameter("buildingname", getBuildingname());
        insertStatement01.setParameter("btype", getBtype());
        insertStatement01.setParameter("buse", getBuse());
        insertStatement01.setParameter("doorcount", getDoorcount());
        insertStatement01.setParameter("struture", getStruture());
        insertStatement01.setParameter("height", getHeight());
        insertStatement01.setParameter("floorcount", getFloorcount());
        insertStatement01.setParameter("startdate", getStartdate());
        insertStatement01.setParameter("enddate", getEnddate());
        insertStatement01.setParameter("developer", getDeveloper());
        insertStatement01.setParameter("architecture", getArchitecture());
        insertStatement01.setParameter("takearea", getTakearea());
        insertStatement01.setParameter("architecturearea", getArchitecturearea());
        insertStatement01.setParameter("usingarea", getUsingarea());
        insertStatement01.setParameter("virescencearea", getVirescencearea());
        insertStatement01.setParameter("cellcount", getCellcount());
        insertStatement01.setParameter("salerate", getSalerate());
        insertStatement01.setParameter("hirerate", getHirerate());
        insertStatement01.setParameter("handover", getHandover());
        insertStatement01.setParameter("handoverdate", getHandoverdate());
        insertStatement01.setParameter("handoverman", getHandoverman());
        insertStatement01.setParameter("remark", getRemark());
        insertStatement01.setParameter("delflag", getDelflag());
    }

    protected void initInsert02()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        insertStatement02 = new SQLStatement();
        insertStatement02.setConnection(connBean);
        statementmetadata = insertStatement02.getMetaData();
        statementmetadata.setSQL(getInsertSQL02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("number1", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("num", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("piccontent", array$B == null ? (array$B = class$("[B")) : array$B, -4);
        statementmetadata.addParameter("picname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("picdescribe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        insertStatement02.setParameter("number1", new Integer(getNumber()));
        insertStatement02.setParameter("num", new Integer(getNum()));
        insertStatement02.setParameter("piccontent", getPiccontent());
        insertStatement02.setParameter("picname", getPicname());
        insertStatement02.setParameter("picdescribe", getPicdescribe());
    }

    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("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement01.setParameter("buildingnumb", getBuildingnumb());
        selectStatement01.setParameter("subareanumb", getSubareanumb());
        statementmetadata.addColumn("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusCode(1013);
            setStatusMessage("批量增加楼宇资料操作成功！");
        }
        catch(DataException dataexception)
        {
            setStatusCode(1012);
            setStatusMessage("批量增加楼宇资料到表 buildinginfo 失败，发生错误：" + dataexception.getMessage());
            throw dataexception;
        }
    }

    public void insert02()
        throws Exception
    {
        try
        {
            initInsert02();
            insertStatement02.execute();
            setStatusCode(1013);
            setStatusMessage("批量增加楼宇资料操作成功！");
        }
        catch(Exception exception)
        {
            setStatusCode(1014);
            setStatusMessage("批量增加楼宇资料到表 buildinginfo1 失败，发生错误：" + exception.getMessage());
            throw exception;
        }
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            if(result.getColumnValueToString(1) == null)
            {
                setStatusCode(1020);
            } else
            {
                setStatusCode(1019);
                setStatusMessage("你所增加的楼宇资料已存在，请验证后再操作！");
            }
        }
        catch(DataException dataexception)
        {
            setStatusCode(1060);
            setStatusMessage("检索楼宇资料失败！" + dataexception.getMessage());
        }
    }

    public void setArchitecture(String s)
    {
        architecture = s;
    }

    public void setArchitecturearea(String s)
    {
        architecturearea = s;
    }

    public void setBtype(String s)
    {
        btype = s;
    }

    public void setBuildingname(String s)
    {
        buildingname = s;
    }

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

    public void setBuse(String s)
    {
        buse = s;
    }

    public void setCellcount(String s)
    {
        cellcount = s;
    }

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

    public void setDeveloper(String s)
    {
        developer = s;
    }

    public void setDoorcount(String s)
    {
        doorcount = s;
    }

    public void setEnddate(String s)
    {
        enddate = s;
    }

    public void setFloorcount(String s)
    {
        floorcount = s;
    }

    public void setHandover(String s)
    {
        handover = s;
    }

    public void setHandoverdate(String s)
    {
        handoverdate = s;
    }

    public void setHandoverman(String s)
    {
        handoverman = s;
    }

    public void setHeight(String s)
    {
        height = s;
    }

    public void setHirerate(String s)
    {
        hirerate = s;
    }

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

    public void setInsertSQL02(String s)
    {
        insertSQL02 = s;
    }

    public void setNum(String s)
    {
        num = s;
    }

    public void setPiccontent(byte abyte0[])
    {
        piccontent = abyte0;
    }

    public void setPicdescribe(String s)
    {
        picdescribe = s;
    }

    public void setPicname(String s)
    {
        picname = s;
    }

    public void setRemark(String s)
    {
        remark = s;
    }

    public void setSalerate(String s)
    {
        salerate = s;
    }

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

    public void setStartdate(String s)
    {
        startdate = s;
    }

    public void setStruture(String s)
    {
        struture = s;
    }

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

    public void setTakearea(String s)
    {
        takearea = s;
    }

    public void setUsingarea(String s)
    {
        usingarea = s;
    }

    public void setVirescencearea(String s)
    {
        virescencearea = s;
    }
}