updateinstorerecorddbbean.java

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

    protected void initInsert03()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        insertStatement03 = new SQLStatement();
        insertStatement03.setConnection(connBean);
        statementmetadata = insertStatement03.getMetaData();
        statementmetadata.setSQL(getInsertSQL03());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("number3", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("instorenum3", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("goodsname3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("goodsstyle3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("goodsprice3", class$java$math$BigDecimal == null ? (class$java$math$BigDecimal = class$("java.math.BigDecimal")) : class$java$math$BigDecimal, 3);
        statementmetadata.addParameter("goodsnum3", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("goodsunit3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("note3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        insertStatement03.setParameter("number3", new Integer(getNumber()));
        insertStatement03.setParameter("instorenum3", new Integer(getInstorenum()));
        insertStatement03.setParameter("goodsname3", getGoodsname());
        insertStatement03.setParameter("goodsstyle3", getGoodsstyle());
        insertStatement03.setParameter("goodsprice3", new BigDecimal(getGoodsprice()));
        insertStatement03.setParameter("goodsnum3", new Integer(getGoodsnum()));
        insertStatement03.setParameter("goodsunit3", getGoodsunit());
        insertStatement03.setParameter("note3", getNote2());
        insertStatement03.setParameter("delflag3", getDelflag());
    }

    protected void initInsert08()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        insertStatement08 = new SQLStatement();
        insertStatement08.setConnection(connBean);
        statementmetadata = insertStatement08.getMetaData();
        statementmetadata.setSQL(getInsertSQL08());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("number8", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("name8", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style8", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("banlance8", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("unit8", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("flag8", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("delflag8", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        insertStatement08.setParameter("number8", new Integer(getNumber()));
        insertStatement08.setParameter("name8", getName());
        insertStatement08.setParameter("style8", getStyle());
        insertStatement08.setParameter("banlance8", new Integer(getBanlance()));
        insertStatement08.setParameter("unit8", getUnit());
        insertStatement08.setParameter("flag8", getFlag());
        insertStatement08.setParameter("delflag8", getDelflag());
    }

    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("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement01.setParameter("number", new Integer(getNumber()));
        selectStatement01.setParameter("delflag", getDelflag());
        statementmetadata.addColumn("goodsname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("goodsstyle", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("goodsnum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
    }

    public void initSelect02()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement02 = new SelectStatement();
        selectStatement02.setConnection(connBean);
        statementmetadata = selectStatement02.getMetaData();
        statementmetadata.setSQL(getSelectSQL02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement02.setParameter("name", getName());
        selectStatement02.setParameter("style", getStyle());
        statementmetadata.addColumn("banlance", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
    }

    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("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement03.setParameter("name", getName());
        selectStatement03.setParameter("style", getStyle());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("banlance", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
    }

    protected void initUpdate01()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement01 = new SQLStatement();
        updateStatement01.setConnection(connBean);
        statementmetadata = updateStatement01.getMetaData();
        statementmetadata.setSQL(getUpdateSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("buynum1", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("buyman1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("instoredate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("note1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("storemanager1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("number1", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("delflag1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        updateStatement01.setParameter("buynum1", new Integer(getBuynum()));
        updateStatement01.setParameter("buyman1", getBuyman());
        updateStatement01.setParameter("instoredate1", Date.valueOf(getInstoredate()));
        updateStatement01.setParameter("note1", getNote1());
        updateStatement01.setParameter("storemanager1", getStoremanager());
        updateStatement01.setParameter("number1", new Integer(getNumber()));
        updateStatement01.setParameter("delflag1", getDelflag());
    }

    protected void initUpdate02()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement02 = new SQLStatement();
        updateStatement02.setConnection(connBean);
        statementmetadata = updateStatement02.getMetaData();
        statementmetadata.setSQL(getUpdateSQL02());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("goodsname2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("goodsstyle2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("goodsprice2", class$java$math$BigDecimal == null ? (class$java$math$BigDecimal = class$("java.math.BigDecimal")) : class$java$math$BigDecimal, 3);
        statementmetadata.addParameter("goodsnum2", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("goodsunit2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("note2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("number2", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("instorenum2", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("delflag2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        updateStatement02.setParameter("goodsname2", getGoodsname());
        updateStatement02.setParameter("goodsstyle2", getGoodsstyle());
        updateStatement02.setParameter("goodsprice2", new BigDecimal(getGoodsprice()));
        updateStatement02.setParameter("goodsnum2", new Integer(getGoodsnum()));
        updateStatement02.setParameter("goodsunit2", getGoodsunit());
        updateStatement02.setParameter("note2", getNote2());
        updateStatement02.setParameter("number2", new Integer(getNumber()));
        updateStatement02.setParameter("instorenum2", new Integer(getInstorenum()));
        updateStatement02.setParameter("delflag2", getDelflag());
    }

    protected void initUpdate04()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement04 = new SQLStatement();
        updateStatement04.setConnection(connBean);
        statementmetadata = updateStatement04.getMetaData();
        statementmetadata.setSQL(getUpdateSQL04());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("delflag4", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("number4", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        updateStatement04.setParameter("delflag4", getDelflag());
        updateStatement04.setParameter("number4", new Integer(getNumber()));
    }

    protected void initUpdate05()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement05 = new SQLStatement();
        updateStatement05.setConnection(connBean);
        statementmetadata = updateStatement05.getMetaData();
        statementmetadata.setSQL(getUpdateSQL05());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("banlance5", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("name5", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style5", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        updateStatement05.setParameter("banlance5", new Integer(getBanlance()));
        updateStatement05.setParameter("name5", getName());
        updateStatement05.setParameter("style5", getStyle());
    }

    protected void initUpdate06()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement06 = new SQLStatement();
        updateStatement06.setConnection(connBean);
        statementmetadata = updateStatement06.getMetaData();
        statementmetadata.setSQL(getUpdateSQL06());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("delflag6", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("name6", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style6", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        updateStatement06.setParameter("delflag6", getDelflag());
        updateStatement06.setParameter("name6", getName());
        updateStatement06.setParameter("style6", getStyle());
    }

    protected void initUpdate07()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement07 = new SQLStatement();
        updateStatement07.setConnection(connBean);
        statementmetadata = updateStatement07.getMetaData();
        statementmetadata.setSQL(getUpdateSQL07());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("banlance7", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("number7", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("name7", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("style7", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        updateStatement07.setParameter("banlance7", new Integer(getBanlance()));
        updateStatement07.setParameter("number7", new Integer(getNumber()));
        updateStatement07.setParameter("name7", getName());
        updateStatement07.setParameter("style7", getStyle());
    }

    public void insert03()
        throws Exception
    {
        try
        {
            initInsert03();
            insertStatement03.execute();
            setStatusCode(8345);
            setStatusMessage("成功增加入库物品清单");
        }
        catch(DataException dataexception)
        {
            setStatusCode(8346);
            setStatusMessage("增加入库物品清单出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
    }

    public void insert08()
        throws Exception
    {
        try
        {
            initInsert08();
            insertStatement08.execute();
            setStatusCode(8371);
            setStatusMessage("成功增加入库物品清单");
        }
        catch(DataException dataexception)
        {
            setStatusCode(8372);
            setStatusMessage("增加入库物品清单出错");
            throw new Exception(getStatusMessage() + dataexception);
        }
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusCode(8351);
            setStatusMessage("查询入库物品清单表成功");
        }
        catch(DataException dataexception)
        {
            setStatusCode(8352);
            setStatusMessage("查询入库物品清单表时发生错误--" + dataexception.getMessage());
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(8353);
                setStatusMessage("查询入库物品清单表结果为空");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void select02()
        throws Exception
    {
        try
        {
            initSelect02();
            selectStatement02.execute();
            result = selectStatement02.getResult();
            result.firstRow();
            setStatusCode(8355);