MyBank

JCO

JWAA

Java+

ALE

Academia

Mideast

Cox

Installation

Documentation

Source

Changes

License

Demo

DemoAccountBean.java

package edu.virtualschool.jwaa.bean;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.NoSuchElementException;

import org.apache.log4j.Logger;

import edu.virtualschool.jwaa.AccountAbstraction;
import edu.virtualschool.jwaa.Fault;
import edu.virtualschool.jwaa.GenericAccount;
import edu.virtualschool.jwaa.StringUtil;
import edu.virtualschool.jwaa.TimeUtil;
import edu.virtualschool.jwaa.UserFault;
import edu.virtualschool.jwaa.dbms.DB;
import edu.virtualschool.jwaa.dbms.DBQuery;
import edu.virtualschool.jwaa.dbms.DBUpdate;
import edu.virtualschool.jwaa.dbms.DBUtil;
import edu.virtualschool.jwaa.field.CityField;
import edu.virtualschool.jwaa.field.CommaSeparatedField;
import edu.virtualschool.jwaa.field.CountryField;
import edu.virtualschool.jwaa.field.EmailField;
import edu.virtualschool.jwaa.field.NameField;
import edu.virtualschool.jwaa.field.OpField;
import edu.virtualschool.jwaa.field.PasswordField;
import edu.virtualschool.jwaa.field.PhoneField;
import edu.virtualschool.jwaa.field.StreetField;
import edu.virtualschool.jwaa.field.USStateField;
import edu.virtualschool.jwaa.field.Validatable;
import edu.virtualschool.jwaa.field.ZipcodeField;
import edu.virtualschool.jwaa.xml.GenericForm;
import edu.virtualschool.jwaa.xml.ValidationFault;
import edu.virtualschool.jwaa.xml.Controller;

public class DemoAccountBean extends GenericAccount implements AccountAbstraction
{
  public EmailField email;
  public PasswordField password;
  public NameField name;
  public StreetField street;
  public CityField city;
  public USStateField state;
  public ZipcodeField zipcode;
  public CountryField country;
  public PhoneField phone;
  public Timestamp whenCreated;

  private final static Logger logger =
    Logger.getLogger(DemoAccountBean.class.getName());

  DemoAccountBean(
    List roles,
    EmailField email,
    PasswordField password,
    NameField name,
    StreetField street,
    CityField city,
    USStateField state,
    ZipcodeField zipcode,
    CountryField country,
    PhoneField phone,
    Timestamp whenCreated)
  {
    super(email.stringValue, roles);
    this.email = email;
    this.password = password;
    this.name = name;
    this.street = street;
    this.city = city;
    this.state = state;
    this.zipcode = zipcode;
    this.country = country;
    this.phone = phone;
    this.whenCreated = whenCreated;
  }
  public static DemoAccountBean load(DBQuery query) 
    throws Fault
  {
    CommaSeparatedField roles = new CommaSeparatedField(query.getString("roles"), "");
    DemoAccountBean person = new DemoAccountBean(
      DemoRole.createRoleList(roles),
      new EmailField(query.getString("email"), ""),
      new PasswordField(query.getString("password"), ""),
      new NameField(query.getString("name"), ""),
      new StreetField(query.getString("street"), ""),
      new CityField(query.getString("city"), ""),
      new USStateField(query.getString("state"), ""),
      new ZipcodeField(query.getString("zipcode"), ""),
      new CountryField(query.getString("country"), ""),
      new PhoneField(query.getString("phone"), ""),
      query.getTimestamp("whenCreated")
    );
    return person;
  }
  public static Iterator loadAll(final DB dbms, Object sortBy) throws Fault
  {
    final String sql = "select * from DemoAccount order by " + sortBy;
    return new DBQuery.Iterator(dbms, sql)
    {
      public Object next()
      {
        try
        {
          return DemoAccountBean.load(query);
        }
        catch (Fault e)
        {
          logger.error("SQL Fault: " + sql, e);
          throw new NoSuchElementException(sql);
        }
      }
    };
  }
  private static List createRoleList(CommaSeparatedField field)
    throws ValidationFault
  {
    List list = new ArrayList();
    for (Iterator iterator = field.arrayValue.iterator(); iterator.hasNext(); )
    {
      Object o = iterator.next();
      String name = (String) o;
      DemoRole role = DemoRole.findRole(name);
      list.add(role);
    }
    return list;
  }
  public static DemoAccountBean findByEmail(DB dbms, EmailField email)
    throws Fault
  {
    String sql = "select * from DemoAccount \n"
        + "where email=" + DBUtil.quote(email);
    DBQuery query = dbms.query(sql);
    if (!query.hasNext())
      throw new UserFault("Couldn't find account with email: " + email);
    DemoAccountBean person = load(query);
    query.close();
    return person;
  }
  public static DemoAccountBean findByEmailAndPassword(DB dbms, EmailField email, PasswordField password)
     throws Fault
  {
    String sql = "select * from DemoAccount\n"
        + "where email=" + DBUtil.quote(email.stringValue) + "\n"
        + "and password=" + DBUtil.quote(password.stringValue);
    DBQuery query = dbms.query(sql);
    if (!query.hasNext())
      throw new UserFault("No account has that email and password");
    DemoAccountBean person = load(query);
    query.close();
    return person;
  }
  public EmailField getEmail()
  {
    return email;
  }
  public PasswordField getPassword()
  {
    return password;
  }
  public NameField getName()
  {
    return name;
  }
  public PhoneField getPhone()
  {
    return phone;
  }
  public StreetField getStreet()
  {
    return street;
  }
  public CityField getCity()
  {
    return city;
  }
  public USStateField getState()
  {
    return state;
  }
  public ZipcodeField getZipcode()
  {
    return zipcode;
  }
  public CountryField getCountry()
  {
    return country;
  }
  public boolean isNull()
  {
    return this == DemoAccountBean.Null;
  }
  public Timestamp getWhenCreated()
  {
    return whenCreated;
  }
  public void save(DB dbms) throws Fault
  {
    String sql =  "replace into DemoAccount set "
        + "email=?,"
        + "password=?,"
        + "roles=?, "
        + "name=?,"
        + "street=?,"
        + "city=?,"
        + "state=?,"
        + "zipcode=?,"
        + "country=?,"
        + "phone=?,"
        + "whenCreated=?";
    DBUpdate s = dbms.update(sql);
    s.setString(email);
    s.setString(password);
    s.setString(StringUtil.join(',', roleList));
    s.setString(name);
    s.setString(street);
    s.setString(city);
    s.setString(state);
    s.setString(zipcode);
    s.setString(country);
    s.setString(phone);
    s.setTimestamp(whenCreated);
    int n = s.executeUpdate();
    s.close();
  }
  public void update(
    EmailField email,
    PasswordField password,
    NameField name,
    StreetField street,
    CityField city,
    USStateField state,
    ZipcodeField zipcode,
    CountryField country,
    PhoneField phone
  )
  {
    this.email = email;
    this.password = password;
    this.name = name;
    this.street = street;
    this.city = city;
    this.state = state;
    this.zipcode = zipcode;
    this.country = country;
    this.phone = phone;
  }
  public String getAddress()
  {
    if (street.ok() && city.ok() && state.ok() && zipcode.ok() && country.ok())
      return street
        + "; "
        + city
        + ", "
        + state
        + " "
        + zipcode
        + " "
        + country;
    else
      return "Address not available";
  }
  public void createDBMS(DB dbms) throws Fault
  {
    dbms.execute(
      "CREATE TABLE DemoAccount (\n"
        + "  email varchar(128) NOT NULL default '',\n"
        + "  password varchar(64) NOT NULL default '',\n"
        + "  role varchar(64) unsigned NOT NULL default '',\n"
        + "  name varchar(32) NOT NULL default '',\n"
        + "  street varchar(64) NOT NULL default '',\n"
        + "  city varchar(64) NOT NULL default '',\n"
        + "  state char(2) NOT NULL default '',\n"
        + "  zipcode varchar(9) NOT NULL default '',\n"
        + "  country varchar(64) NOT NULL default '',\n"
        + "  phone varchar(10) NOT NULL default '',\n"
        + "  whenCreated datetime NOT NULL default '0000-00-00 00:00:00',\n"
        + " INDEX login (email, password),\n"
        + "  PRIMARY KEY (email)\n"
        + ") TYPE=InnoDB PACK_KEYS=1;\n"
    );
    ArrayList roles = new ArrayList();
    roles.add(DemoRole.ADMINISTRATOR);
    DemoAccountBean adminAccount = new DemoAccountBean(
      roles,
      new EmailField("bcox@virtualschool.edu"),
      new PasswordField("++++"),
      new NameField("Admin"),
      StreetField.Null,
      CityField.Null,
      USStateField.Null,
      ZipcodeField.Null,
      CountryField.Null,
      PhoneField.Null,
      TimeUtil.now()
    );
    adminAccount.save(dbms);
  }
  public static DemoAccountBean Null = new DemoAccountBean(
    new ArrayList(),
    EmailField.Null,
    PasswordField.Null,
    NameField.Null,
    StreetField.Null,
    CityField.Null,
    USStateField.Null,
    ZipcodeField.Null,
    CountryField.Null,
    PhoneField.Null,
    new Timestamp(System.currentTimeMillis())
  );
  public static class LoginForm extends GenericForm
  {
    final OpField op;
    final EmailField email;
    final PasswordField password;

    public LoginForm(Controller p)
    {
      this.op = new OpField(p.getParameter("op", ""));
      this.email = new EmailField(p.getParameter("email", ""));
      this.password = new PasswordField(p.getParameter("password", ""));
      validate(new Validatable[] { op, email, password });
    }
    public AccountAbstraction load(DB dbms) throws Fault
    {
      try
      {
        DemoAccountBean account = DemoAccountBean.findByEmailAndPassword(dbms, email, password);
        return account;
      }
      catch (Fault e)
      {
        return DemoAccountBean.Null;
      }
    }
    public EmailField getEmail()
    {
      return email;
    }

    public OpField getOp()
    {
      return op;
    }

    public PasswordField getPassword()
    {
      return password;
    }

  }
  public static class UpdateForm extends GenericForm
  {
    final OpField op;
    final EmailField email;
    final PasswordField password;
    final NameField name;
    final StreetField street;
    final CityField city;
    final USStateField state;
    final ZipcodeField zipcode;
    final CountryField country;
    final PhoneField phone;
    final PasswordField passwordConfirm;

    public UpdateForm(Controller p)
    {
      DemoAccountBean pb = (DemoAccountBean)p.getAccount();
      this.op = new OpField(p.getParameter("op", ""));
      this.email = new EmailField(p.getParameter("email", pb.email));
      this.password = new PasswordField(p.getParameter("password", pb.password));
      this.name = new NameField(p.getParameter("name", pb.name));
      this.street = new StreetField(p.getParameter("street", pb.street));
      this.city = new CityField(p.getParameter("city", pb.city));
      this.state = new USStateField(p.getParameter("state", pb.state));
      this.zipcode = new ZipcodeField(p.getParameter("zipcode", pb.zipcode));
      this.country = new CountryField(p.getParameter("country", pb.country));
      this.phone = new PhoneField(p.getParameter("phone", pb.phone));
      this.passwordConfirm = new PasswordField(p.getParameter("passwordConfirm", PasswordField.Null));
      if (!password.stringValue.equals(passwordConfirm.stringValue))
        passwordConfirm.setValid(false, "The passwords don't match");       
      validate(new Validatable[] { 
        op,
        email,
        password,
        name,
        street,
        city,
        state,
        zipcode,
        country,
        phone, 
        passwordConfirm
      });
    }
    public AccountAbstraction createAccount(DB dbms)
    {
      try
      {
        DemoAccountBean account = DemoAccountBean.findByEmailAndPassword(dbms, email, password);
        updateAccount(dbms, account);
        return account;
      }
      catch (Fault e1)
      {
        try
        {
          DemoAccountBean account = DemoAccountBean.findByEmail(dbms, email);
          email.setValid(false, "That email address is already registered.");
          return Null;
        }
        catch (Fault e2)
        {
          List roles = new ArrayList();
          roles.add(DemoRole.STUDENT);
          DemoAccountBean account = new DemoAccountBean(
            roles,
            email,
            password,
            name,
            street,
            city,
            state,
            zipcode,
            country,
            phone,
            new Timestamp(System.currentTimeMillis())
          );
          try
          {
            account.save(dbms);
            return account;
          }
          catch (Fault e)
          {
            return DemoAccountBean.Null;
          }
        }
      }
    }
    public void updateAccount(DB dbms, DemoAccountBean person)
      throws Fault
    {
      person.update(
        email,
        password,
        name,
        street,
        city,
        state,
        zipcode,
        country,
        phone
      );
      person.save(dbms);
    }
    public CityField getCity()
    {
      return city;
    }

    public CountryField getCountry()
    {
      return country;
    }

    public EmailField getEmail()
    {
      return email;
    }

    public NameField getName()
    {
      return name;
    }

    public OpField getOp()
    {
      return op;
    }

    public PasswordField getPassword()
    {
      return password;
    }
    public PasswordField getPasswordConfirm()
    {
      return passwordConfirm;
    }
    public PhoneField getPhone()
    {
      return phone;
    }
    public USStateField getState()
    {
      return state;
    }

    public StreetField getStreet()
    {
      return street;
    }

    public ZipcodeField getZipcode()
    {
      return zipcode;
    }

  }
  public static class AdminForm extends GenericForm
  {
    public AdminForm(Controller p)
    {
    }
  }
}