customer.java

java 完全探索的随书源码

public class Customer
{
  // Default Constructor
  public Customer()
  {
    super();
  }

  // Private Instance Variables
  private String id;
  private String name;
  private String city;
  private String state;
  private String zip;

  // Public Accessors
  public String getId()
  {
    return id;
  }

  public void setId( String custId )
  {
    id = custId;
  }

  public void setName( String newName )
  {
    name = newName;
  }

  public String getName()
  {
    return name;
  }

  public void setCity( String city )
  {
    this.city = city;
  }

  public String getCity()
  {
    return city;
  }

  public void setState( String state )
  {
    this.state = state;
  }

  public String getState()
  {
    return state;
  }

  public void setZip( String zip )
  {
    this.zip = zip;
  }

  public String getZip()
  {
    return zip;
  }

  // Return a String that clients can use to Insert an instance of this
  // class into the database.
  public String getInsertSQL()
  {
    StringBuffer sqlBuf = new StringBuffer( "INSERT INTO CUSTOMER (" );
    sqlBuf.append( "CUSTID, NAME, CITY, STATE, ZIP ) " );
    sqlBuf.append( " VALUES ( " );
    sqlBuf.append( getId() );
    sqlBuf.append( "," );

    sqlBuf.append( "'" );
    sqlBuf.append( getName() );
    sqlBuf.append( "'," );

    sqlBuf.append( "'" );
    sqlBuf.append( getCity() );
    sqlBuf.append( "'," );

    sqlBuf.append( "'" );
    sqlBuf.append( getState() );
    sqlBuf.append( "'," );

    sqlBuf.append( 1 );
    sqlBuf.append( "," );

    sqlBuf.append( "'" );
    sqlBuf.append( getZip() );
    sqlBuf.append( "')" );

    return sqlBuf.toString();
  }

  // Return a string that clients can use to get all of the Customer records
  public static String getReadAllSQL()
  {
    return "SELECT CUSTID, NAME, CITY, STATE, REPID, ZIP FROM CUSTOMER";
  }

  // Return a SQL update String for this instance. Notice that we are doing it
  // very inefficently because we are updating all the fields regardless of
  // whether or not it changed. There are better ways to do it for real world
  // applications. Since customer number was assigned, we are not going to
  // update that field. It would cause big refertial integrity problems if
  // we did.
  public String getUpdateSQL()
  {
    StringBuffer sqlBuf = new StringBuffer( "UPDATE CUSTOMER SET " );

    sqlBuf.append( "NAME='" );
    sqlBuf.append( getName() );
    sqlBuf.append( "', CITY='");
    sqlBuf.append( getCity() );
    sqlBuf.append( "', STATE='");
    sqlBuf.append( getState() );
    sqlBuf.append( "', ZIP='");
    sqlBuf.append( getZip() );
    sqlBuf.append( "' WHERE CUSTID = " );
    sqlBuf.append( getId() );

    return sqlBuf.toString();
  }

  // Override the default toString method to output something of our own
  public String toString()
  {
    StringBuffer buf = new StringBuffer();
    buf.append( "ID: " );
    buf.append( getId() );
    buf.append( " Name: " );
    buf.append( getName() );
    buf.append( " City: " );
    buf.append( getCity() );
    buf.append( " State: " );
    buf.append( getState() );
    buf.append( " Zip: " );
    buf.append( getZip() );

    return buf.toString();
  }
}