modifydossierdbbean.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:   ModifyDossierDBBean.java

package personaladmin;

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

class ModifyDossierDBBean extends ParentDBBean
{

    protected String dossiertopic;
    protected String dossiernumb;
    protected String dossierkind;
    protected String receivedate;
    protected String senddate;
    protected String sendorganize;
    protected String pages;
    protected String contenttype;
    protected String contentname;
    protected String location;
    protected String remark;
    protected byte content[];
    protected String number1;
    Vector vecDossiertopic;
    Vector vecDossiernumb;
    Vector vecDossierkind;
    Vector vecReceivedate;
    Vector vecSenddate;
    Vector vecSendorganize;
    Vector vecPages;
    Vector vecContentname;
    Vector vecLocation;
    Vector vecRemark;
    protected String selectSQL01;
    protected String selectSQL02;
    protected String updateSQL01;
    protected String updateSQL02;
    protected SelectStatement selectStatement01;
    protected SelectStatement selectStatement02;
    protected SQLStatement updateStatement01;
    protected SQLStatement updateStatement02;
    static Class class$java$lang$Integer; /* synthetic field */
    static Class class$java$lang$String; /* synthetic field */
    static Class array$B; /* synthetic field */

    ModifyDossierDBBean()
    {
        dossiertopic = null;
        dossiernumb = null;
        dossierkind = null;
        receivedate = null;
        senddate = null;
        sendorganize = null;
        pages = null;
        contenttype = null;
        contentname = null;
        location = null;
        remark = null;
        content = new byte[0x19000];
        number1 = null;
        vecDossiertopic = new Vector();
        vecDossiernumb = new Vector();
        vecDossierkind = new Vector();
        vecReceivedate = new Vector();
        vecSenddate = new Vector();
        vecSendorganize = new Vector();
        vecPages = new Vector();
        vecContentname = new Vector();
        vecLocation = new Vector();
        vecRemark = new Vector();
    }

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

    public byte[] getContent()
    {
        return content;
    }

    public String getContentname()
    {
        return contentname;
    }

    public String getContenttype()
    {
        return contenttype;
    }

    public void getDataFromResult01()
        throws Exception
    {
        try
        {
            for(int i = 0; i < result.getNumRowsInCache(); i++)
            {
                result.setCurrentRow(i + 1);
                vecDossiertopic.addElement(result.getColumnValueToString("dossiertopic").trim());
                vecDossiernumb.addElement(result.getColumnValueToString("dossiernumb").trim());
                vecDossierkind.addElement(result.getColumnValueToString("dossierkind").trim());
                vecPages.addElement(result.getColumnValueToString("pages").trim());
                vecSendorganize.addElement(result.getColumnValueToString("sendorganize").trim());
                vecSenddate.addElement(result.getColumnValueToString("senddate").trim());
                vecReceivedate.addElement(result.getColumnValueToString("receivedate").trim());
                vecLocation.addElement(result.getColumnValueToString("location").trim());
                vecContentname.addElement(result.getColumnValue("contentname"));
                vecRemark.addElement(result.getColumnValueToString("remark").trim());
            }

        }
        catch(DataException dataexception)
        {
            setStatusCode(3158);
            setStatusMessage("从档案资料详细信息结果集中取值时出错！");
            throw dataexception;
        }
        finally
        {
            closeResultSet();
        }
    }

    public String getDossierkind()
    {
        return dossierkind;
    }

    public String getDossiernumb()
    {
        return dossiernumb;
    }

    public String getDossiertopic()
    {
        return dossiertopic;
    }

    public String getLocation()
    {
        return location;
    }

    public String getNumber1()
    {
        return number1;
    }

    public String getPages()
    {
        return pages;
    }

    public String getReceivedate()
    {
        return receivedate;
    }

    public String getRemark()
    {
        return remark;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public String getSelectSQL02()
    {
        return selectSQL02;
    }

    public String getSenddate()
    {
        return senddate;
    }

    public String getSendorganize()
    {
        return sendorganize;
    }

    public String getUpdateSQL01()
    {
        return updateSQL01;
    }

    public String getUpdateSQL02()
    {
        return updateSQL02;
    }

    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);
        selectStatement01.setParameter("number", new Integer(getNumber1()));
        statementmetadata.addColumn("dossiertopic", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("dossiernumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("dossierkind", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("pages", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sendorganize", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("senddate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("receivedate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("location", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("contentname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
    }

    public void initSelect02()
        throws DataException
    {
        StatementMetaData statementmetadata = null;