updatevisitorrecorddbbean.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:   UpdateVisitorRecordDBBean.java

package secfireproof;

import com.ibm.db.*;
import common.ParentDBBean;
import common.QueryDBBean;
import java.io.IOException;
import java.sql.Date;
import java.sql.Time;

public class UpdateVisitorRecordDBBean extends QueryDBBean
{

    protected String guestName;
    protected String ID;
    protected String IDNum;
    protected String visitDest;
    protected String guestNum;
    protected String hostName;
    protected String watcher;
    protected String hostAddress;
    protected String visitDate;
    protected String visitTime;
    protected String leaveDate;
    protected String leaveTime;
    protected String num;
    protected String delFlag;
    protected String flag;
    protected String updateSQL01;
    protected SQLStatement updateStatement01;
    static Class class$java$lang$String; /* synthetic field */
    static Class class$java$lang$Integer; /* synthetic field */
    static Class class$java$sql$Date; /* synthetic field */
    static Class class$java$sql$Time; /* synthetic field */

    public UpdateVisitorRecordDBBean()
    {
        guestName = null;
        ID = null;
        IDNum = null;
        visitDest = null;
        guestNum = null;
        hostName = null;
        watcher = null;
        hostAddress = null;
        visitDate = null;
        visitTime = null;
        leaveDate = null;
        leaveTime = null;
        num = null;
        delFlag = null;
        flag = null;
    }

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

    public String getDelFlag()
    {
        return delFlag;
    }

    public String getFlag()
    {
        return flag;
    }

    public String getGuestName()
    {
        return guestName;
    }

    public String getGuestNum()
    {
        return guestNum;
    }

    public String getHostAddress()
    {
        return hostAddress;
    }

    public String getHostName()
    {
        return hostName;
    }

    public String getID()
    {
        return ID;
    }

    public String getIDNum()
    {
        return IDNum;
    }

    public String getLeaveDate()
    {
        return leaveDate;
    }

    public String getLeaveTime()
    {
        return leaveTime;
    }

    public String getNumber()
    {
        return num;
    }

    public String getUpdateSQL01()
    {
        return updateSQL01;
    }

    public String getVisitDate()
    {
        return visitDate;
    }

    public String getVisitDest()
    {
        return visitDest;
    }

    public String getVisitTime()
    {
        return visitTime;
    }

    public String getWatcher()
    {
        return watcher;
    }

    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("guestname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("id", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("idnum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("visitdest", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("guestnum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("hostname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("watcher", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("hostaddress", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("visitdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("visittime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
        if(getFlag().trim().equals("1"))
        {
            statementmetadata.addParameter("leavedate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("leavetime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
        }
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        updateStatement01.setParameter("guestname", getGuestName());
        updateStatement01.setParameter("id", getID());
        updateStatement01.setParameter("idnum", getIDNum());
        updateStatement01.setParameter("visitdest", getVisitDest());
        updateStatement01.setParameter("guestnum", new Integer(getGuestNum()));
        updateStatement01.setParameter("hostname", getHostName());
        updateStatement01.setParameter("watcher", getWatcher());
        updateStatement01.setParameter("hostaddress", getHostAddress());
        updateStatement01.setParameter("visitdate", Date.valueOf(getVisitDate()));
        updateStatement01.setParameter("visittime", Time.valueOf(getVisitTime()));
        if(getFlag().trim().equals("1"))
        {
            updateStatement01.setParameter("leavedate", Date.valueOf(getLeaveDate()));
            updateStatement01.setParameter("leavetime", Time.valueOf(getLeaveTime()));
        }
        updateStatement01.setParameter("number", new Integer(getNumber()));
    }

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

    public void setFlag(String s)
    {
        flag = s;
    }

    public void setGuestName(String s)
    {
        guestName = s;
    }

    public void setGuestNum(String s)
    {
        guestNum = s;
    }

    public void setHostAddress(String s)
    {
        hostAddress = s;
    }

    public void setHostName(String s)
    {
        hostName = s;
    }

    public void setID(String s)
    {
        ID = s;
    }

    public void setIDNum(String s)
    {
        IDNum = s;
    }

    public void setLeaveDate(String s)
    {
        leaveDate = s;
    }

    public void setLeaveTime(String s)
    {
        leaveTime = s;
    }

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

    public void setUpdateSQL01(String s)
    {
        updateSQL01 = s;
    }

    public void setVisitDate(String s)
    {
        visitDate = s;
    }

    public void setVisitDest(String s)
    {
        visitDest = s;
    }

    public void setVisitTime(String s)
    {
        visitTime = s;
    }

    public void setWatcher(String s)
    {
        watcher = s;
    }

    public void update01()
        throws Exception
    {
        try
        {
            initUpdate01();
            updateStatement01.execute();
            setStatusMessage("成功修改外来人员出入信息");
            setStatusCode(7056);
        }
        catch(DataException dataexception)
        {
            setStatusMessage("修改外来人员出入信息时出错");
            setStatusCode(7057);
            throw dataexception;
        }
    }
}