// SqlPerson.java

import  java.applet.*;
import  java.sql.*;

public
    class       SqlPerson
    extends     Person
    implements  SqlObject, ObjectWithUI
    {
// CONSTRUCTORS

    public
        SqlPerson
        (
        String          poStringName,
        String          poStringAddress,
        String          poStringPhone
        )
        {
        setName     (poStringName   );
        setAddress  (poStringAddress);
        setPhone    (poStringPhone  );
        }

// PUBLIC METHODS

    public
        ObjectApplet    getUI
        (
        )
        {
        ObjectApplet oApplet = new PersonApplet();
        oApplet.setObject(this);
        return oApplet;
        }

    public
        SqlObject       sqlReadResult
        (
        ResultSet       poResult
        )
        throws          SQLException
        {
        setName     (poResult.getString("name"      ));
        setAddress  (poResult.getString("address"   ));
        setPhone    (poResult.getString("phone"     ));
        return this;
        }

    public
        String          sqlSetString
        (
        )
        {
        StringBuffer    oBuffer = new StringBuffer();
        appendSetString(oBuffer,false);
        return oBuffer.toString();
        }

    public
        String          sqlValuesString
        (
        )
        {
        StringBuffer    oBuffer = new StringBuffer();
        appendValuesString(oBuffer,false);
        return oBuffer.toString();
        }

    public
        String          sqlWhereString
        (
        )
        {
        StringBuffer    oBuffer = new StringBuffer();
        appendWhereString(oBuffer,false);
        return oBuffer.toString();
        }

// PROTECTED METHODS

    protected
        boolean         appendSetString
        (
        StringBuffer    poBuffer,
        boolean         ptAppended
        )
        {
        boolean t = ptAppended;
        t = SqlAssistant.append
                (poBuffer,t,","," name = '"     ,getName    (),"'");
        t = SqlAssistant.append
                (poBuffer,t,","," address = '"  ,getAddress (),"'");
        t = SqlAssistant.append
                (poBuffer,t,","," phone = '"    ,getPhone   (),"'");
        return t;
        }

    protected
        boolean         appendValuesString
        (
        StringBuffer    poBuffer,
        boolean         ptAppended
        )
        {
        boolean t = ptAppended;
        t = SqlAssistant.append
                (poBuffer,t,",","'",getName     (),"'");
        t = SqlAssistant.append
                (poBuffer,t,",","'",getAddress  (),"'");
        t = SqlAssistant.append
                (poBuffer,t,",","'",getPhone    (),"'");
        return t;
        }

    protected
        boolean         appendWhereString
        (
        StringBuffer    poBuffer,
        boolean         ptAppended
        )
        {
        boolean t = ptAppended;
        t = SqlAssistant.append
                (poBuffer,t," and"," name = '"      ,getName    (),"'");
        t = SqlAssistant.append
                (poBuffer,t," and"," address = '"   ,getAddress (),"'");
        t = SqlAssistant.append
                (poBuffer,t," and"," phone = '" ,getPhone   (),"'");
        return t;
        }

    public
        SqlObject       newInstance
        (
        )
        {
        return new SqlPerson("","","");
        }
    }