addcelldbbean.java

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

        statementmetadata.addParameter("enterdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fitment", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("owner", 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("cellnumb", getCellnumb());
        insertStatement01.setParameter("floortype", getFloortype());
        insertStatement01.setParameter("floornumb", getFloornumb());
        insertStatement01.setParameter("doornumb", getDoornumb());
        insertStatement01.setParameter("buildingnumb", getBuildingnumb());
        insertStatement01.setParameter("subareanumb", getSubareanumb());
        insertStatement01.setParameter("use", getUse());
        insertStatement01.setParameter("structure", getStructure());
        insertStatement01.setParameter("architecturearea", getArchitecturearea());
        insertStatement01.setParameter("usingarea", getUsingarea());
        insertStatement01.setParameter("direction", getDirection());
        insertStatement01.setParameter("bedroom", getBedroom());
        insertStatement01.setParameter("hall", getHall());
        insertStatement01.setParameter("loo", getLoo());
        insertStatement01.setParameter("cookroom", getCookroom());
        insertStatement01.setParameter("balcony", getBalcony());
        insertStatement01.setParameter("else", getElseroom());
        insertStatement01.setParameter("addfixture", getAddfixture());
        insertStatement01.setParameter("candr", getCandr());
        insertStatement01.setParameter("crdate", getCrdate());
        insertStatement01.setParameter("useflag", getUseflag());
        insertStatement01.setParameter("price", getPrice());
        insertStatement01.setParameter("paymentway", getPaymentway());
        insertStatement01.setParameter("paycontent", getPaycontent());
        insertStatement01.setParameter("enterdate", getEnterdate());
        insertStatement01.setParameter("fitment", getFitment());
        insertStatement01.setParameter("owner", getOwner());
        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("cellnumb", 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("doornumb", 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("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement01.setParameter("cellnumb", getCellnumb());
        selectStatement01.setParameter("floornumb", getFloornumb());
        selectStatement01.setParameter("doornumb", getDoornumb());
        selectStatement01.setParameter("buildingnumb", getBuildingnumb());
        selectStatement01.setParameter("subareanumb", getSubareanumb());
        statementmetadata.addColumn("cellnumb", 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(1015);
            setStatusMessage("批量增加单元资料操作成功！");
        }
        catch(DataException dataexception)
        {
            setStatusCode(1016);
            setStatusMessage("批量增加单元资料到表 cellinfo 失败，发生错误：" + dataexception.getMessage());
            throw dataexception;
        }
    }

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

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

    public void setAddfixture(String s)
    {
        addfixture = s;
    }

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

    public void setBalcony(String s)
    {
        balcony = s;
    }

    public void setBedroom(String s)
    {
        bedroom = s;
    }

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

    public void setCandr(String s)
    {
        candr = s;
    }

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

    public void setCookroom(String s)
    {
        cookroom = s;
    }

    public void setCrdate(String s)
    {
        crdate = s;
    }

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

    public void setDirection(String s)
    {
        direction = s;
    }

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

    public void setElseroom(String s)
    {
        elseroom = s;
    }

    public void setEnterdate(String s)
    {
        enterdate = s;
    }

    public void setFitment(String s)
    {
        fitment = s;
    }

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

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

    public void setHall(String s)
    {
        hall = s;
    }

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

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

    public void setLoo(String s)
    {
        loo = s;
    }

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

    public void setOwner(String s)
    {
        owner = s;
    }

    public void setPaycontent(String s)
    {
        paycontent = s;
    }

    public void setPaymentway(String s)
    {
        paymentway = s;
    }

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

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

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

    public void setPrice(String s)
    {
        price = s;
    }

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

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

    public void setStructure(String s)
    {
        structure = s;
    }

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

    public void setUse(String s)
    {
        use = s;
    }

    public void setUseflag(String s)
    {
        useflag = s;
    }

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