MyBank

JCO

JWAA

Java+

ALE

Academia

Mideast

Cox

Installation

Documentation

Source

Changes

License

Demo

FieldBean.java

package edu.virtualschool.jwaa.bean;
import java.sql.Timestamp;

import org.apache.log4j.Logger;

import edu.virtualschool.jwaa.AccountAbstraction;
import edu.virtualschool.jwaa.Fault;
import edu.virtualschool.jwaa.dbms.DB;
import edu.virtualschool.jwaa.dbms.DBQuery;
import edu.virtualschool.jwaa.dbms.DBUpdate;
import edu.virtualschool.jwaa.field.CommaSeparatedField;

public class FieldBean
{
  public final String accountID;
  public final String pageID;
  public final String fieldID;
  public String value;
  public Timestamp when;
  
  final static Logger logger = Logger.getLogger(FieldBean.class.getName());

  public FieldBean(DBQuery query) throws DB.Fault
  {
    this(
      query.getString("account"),
      query.getString("page"),
      query.getString("field"),
      query.getString("value"),
      query.getTimestamp("when")
    );
  }
  public FieldBean(
    String accountID,
    String pageID,
    String fieldID,
    String value,
    Timestamp time
  )
  {
    this.accountID = accountID;
    this.pageID = pageID;
    this.fieldID = fieldID;
    this.value = value;
    this.when = time;
  }
//  public static HashMap loadMap(
//      DB dbms, 
//      Page page,
//      String accountID
//  ) throws DB.Fault
//  {
//    final HashMap map = new HashMap();
//    if (accountID == null || page == null)
//      return map;
//    final String sql = "select * from Answers " +
//      "\n where task="+DBUtil.quote(page.getPages())+
//      "\n and page="+DBUtil.quote(page)+
//      "\n and account="+DBUtil.quote(accountID);
//    try
//    {
//      DBQuery query = dbms.query(sql);
//      while(query.hasNext())
//      {
//        FormBean answer = new FormBean(query);
//        map.put(answer.fieldID.toString(), answer);
//      }
//      query.close();
//    }
//    catch (DB.Fault e)
//    {
//      logger.error(e, e);
//    }
//    for (Iterator iterator = page.getQuestions().iterator(); iterator.hasNext(); )
//    {
//      Question form = (Question)iterator.next();
//      String key = form.getIdentity();
//      if (!map.containsKey(key))
//        map.put(key, new FormBean(page, form, accountID));
//    }
//    return map;
//  }
  public void update(DB dbms, AccountAbstraction account, CommaSeparatedField value) 
    throws Fault
  {
    if (value.equals(this.value))
      return;
    this.value = value.stringValue; 
    this.when = new Timestamp(System.currentTimeMillis());
    save(dbms);
  }
  public final String getQuestionID() { return fieldID.toString(); }
  public final String getStudentID() { return accountID.toString(); }
  public final String getField() { return value.toString(); }
  public final Timestamp getWhen() { return when; }
  public void save(DB dbms) throws Fault
  {
    String sql = "replace into Form set\n" +
      "account=?,\n"+
      "page=?,\n"+
      "field=?,\n"+
      "value=?,\n"+
      "time=?\n";
    DBUpdate update = dbms.update(sql);
    try 
    {
      update.setString(accountID);
      update.setString(pageID);
      update.setString(fieldID);
      update.setString(value);
      update.setTimestamp(when);
      update.executeUpdate();
      update.close();
    } 
    catch (Fault e) 
    {
      String s = "CREATE TABLE Form (\n"+
        "account varchar(255) NOT NULL,\n" +
        "page varchar(255) NOT NULL,\n" +
        "field varchar(255) NOT NULL,\n" +
        "value text NOT NULL,\n" +
        "time datetime NOT NULL,\n" +
        "PRIMARY KEY (account, page, field)\n"+
      ") TYPE=InnoDB PACK_KEYS=1\n";
      dbms.execute(s);
      update.setString(accountID);
      update.setString(pageID);
      update.setString(fieldID);
      update.setString(value);
      update.setTimestamp(when);
      update.executeUpdate();
      update.close();
    }
  }
  public String toString()
  {
    return value;
  }
}