addfixturedbbean.java

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

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   AddFixtureDBBean.java

package baseinfo;

import com.ibm.db.*;
import common.ParentDBBean;
import common.QueryDBBean;
import java.io.IOException;
import java.util.Vector;

public class AddFixtureDBBean extends QueryDBBean
{

    protected String fixturename;
    protected String fixturenumb;
    protected String fixturetype;
    protected String fixturestandard;
    protected String manufacturer;
    protected String leavefactorydate;
    protected String leavefactorynumb;
    protected String ratedvoltage;
    protected String ratedcurrent;
    protected String ratedrev;
    protected String fitdate;
    protected String fitaddr;
    protected String usingexplain;
    protected String delflag;
    protected String insertSQL01;
    protected SQLStatement insertStatement01;
    protected String selectSQL01;
    protected SelectStatement selectStatement01;
    Vector vecQ1;
    static Class class$java$lang$Integer; /* synthetic field */
    static Class class$java$lang$String; /* synthetic field */

    public AddFixtureDBBean()
    {
        fixturename = null;
        fixturenumb = null;
        fixturetype = null;
        fixturestandard = null;
        manufacturer = null;
        leavefactorydate = null;
        leavefactorynumb = null;
        ratedvoltage = null;
        ratedcurrent = null;
        ratedrev = null;
        fitdate = null;
        fitaddr = null;
        usingexplain = null;
        delflag = null;
        vecQ1 = new Vector();
    }

    static Class class$(String s)
    {
        try
        {
            return Class.forName(s);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            throw new NoClassDefFoundError(classnotfoundexception.getMessage());
        }
    }

    public void getDataFromResult01()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecQ1.addElement(result.getColumnValueToString("fixturenumb").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(200);
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public String getDelFlag()
    {
        return delflag;
    }

    public String getFitAddr()
    {
        return fitaddr;
    }

    public String getFitDate()
    {
        return fitdate;
    }

    public String getFixtureName()
    {
        return fixturename;
    }

    public String getFixtureNumb()
    {
        return fixturenumb;
    }

    public String getFixtureStandard()
    {
        return fixturestandard;
    }

    public String getFixtureType()
    {
        return fixturetype;
    }

    public String getInsertSQL01()
    {
        return insertSQL01;
    }

    public String getLeaveFactoryDate()
    {
        return leavefactorydate;
    }

    public String getLeaveFactoryNumb()
    {
        return leavefactorynumb;
    }

    public String getManufacturer()
    {
        return manufacturer;
    }

    public String getRatedCurrent()
    {
        return ratedcurrent;
    }

    public String getRatedRev()
    {
        return ratedrev;
    }

    public String getRatedVoltage()
    {
        return ratedvoltage;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public String getUsingExplain()
    {
        return usingexplain;
    }

    protected void initInsert01()
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        insertStatement01 = new SQLStatement();
        insertStatement01.setConnection(connBean);
        statementmetadata = insertStatement01.getMetaData();
        statementmetadata.setSQL(getInsertSQL01());
        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("fixturename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fixturenumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fixturetype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fixturestandard", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("manufacturer", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("leavefactorydate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("leavefactorynumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ratedvoltage", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ratedcurrent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ratedrev", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fitdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fitaddr", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("usingexplain", 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("fixturename", getFixtureName());
        insertStatement01.setParameter("fixturenumb", getFixtureNumb());
        insertStatement01.setParameter("fixturetype", getFixtureType());
        insertStatement01.setParameter("fixturestandard", getFixtureStandard());
        insertStatement01.setParameter("manufacturer", getManufacturer());
        insertStatement01.setParameter("leavefactorydate", getLeaveFactoryDate());
        insertStatement01.setParameter("leavefactorynumb", getLeaveFactoryNumb());
        insertStatement01.setParameter("ratedvoltage", getRatedVoltage());
        insertStatement01.setParameter("ratedcurrent", getRatedCurrent());
        insertStatement01.setParameter("ratedrev", getRatedRev());
        insertStatement01.setParameter("fitdate", getFitDate());
        insertStatement01.setParameter("fitaddr", getFitAddr());
        insertStatement01.setParameter("usingexplain", getUsingExplain());
        insertStatement01.setParameter("delflag", 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.addColumn("fixturenumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fixturenumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement01.setParameter("fixturenumb", getFixtureNumb());
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusCode(1008);
            setStatusMessage("增加数据到 fixtureinfo 表操作成功！");
        }
        catch(DataException dataexception)
        {
            setStatusCode(1009);
            setStatusMessage("插入数据到 fixtureinfo 表时发生：" + dataexception.getMessage());
            throw dataexception;
        }
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusCode(1078);
        }
        catch(DataException dataexception)
        {
            setStatusCode(1079);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(1079);
                break;

            default:
                throw dataexception;
            }
        }
    }

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

    public void setFitAddr(String s)
    {
        fitaddr = s;
    }

    public void setFitDate(String s)
    {
        fitdate = s;
    }

    public void setFixtureName(String s)
    {
        fixturename = s;
    }

    public void setFixtureNumb(String s)
    {
        fixturenumb = s;
    }

    public void setFixtureStandard(String s)
    {
        fixturestandard = s;
    }

    public void setFixtureType(String s)
    {
        fixturetype = s;
    }

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

    public void setLeaveFactoryDate(String s)
    {
        leavefactorydate = s;
    }

    public void setLeaveFactoryNumb(String s)
    {
        leavefactorynumb = s;
    }

    public void setManufacturer(String s)
    {
        manufacturer = s;
    }

    public void setRatedCurrent(String s)
    {
        ratedcurrent = s;
    }

    public void setRatedRev(String s)
    {
        ratedrev = s;
    }

    public void setRatedVoltage(String s)
    {
        ratedvoltage = s;
    }

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

    public void setUsingExplain(String s)
    {
        usingexplain = s;
    }
}