PatientEditor.java

Go to the documentation of this file.

import java.sql.SQLException;
import java.sql.PreparedStatement;

public class PatientEditor extends Widget
{ 
        public static final int SAVE = 1;
        public static final int CANCEL = 2;
        
        public int patient_id;
        public PolicySelect policy;
        public TextBox name;
        public TextBox address;
        public TextBox phone;
        
        public ActionButton action;
        public boolean done = false;
        
        public PatientEditor(int patient_id, String prefix, Form form)
        {
          super(prefix, form);
          this.patient_id = patient_id;
    action = new ActionButton(n("action"), form);
    name = new TextBox(0,20,n("name"), form);
    phone = new TextBox(0,20,n("phone"), form);
    address = new TextBox(2,20,n("address"), form);
    policy = new PolicySelect(n("policy"), form);
    addChild(action);
    addChild(name);
    addChild(phone);
    addChild(address);
    addChild(policy);
        }
        
        public void loadValues()
        {
    super.loadValues();
    
    if (action.action == SAVE)
    {
      if (save()) done = true;
    }
    else if (action.action == CANCEL)
    {
      done = true;
    }
        }
        
        public void loadDefaults()
        {
          super.loadDefaults();
          Query q = new Query(form.connectDb(), form.pw);
          try
          {
            q.query("SELECT name, phone, address, insurance_policy_id FROM patients WHERE patient_id = " + patient_id);
            if (q.r == null || !q.r.next()) return;
      name.text = q.r.getString(1);
      phone.text = q.r.getString(2);
      address.text = q.r.getString(3);
      policy.id = new Integer(q.r.getInt(4));
          }
          catch (SQLException e)
          {
            p(e);
          }
          finally
          {
            q.close();
          }
        }

        protected boolean save()
        {
          form.connectDb();
          Query q = new Query(form.conn, form.pw);
          try
          {
            PreparedStatement s;
            if (patient_id > 0)
            {
              s = form.conn.prepareStatement("\n"+
"               UPDATE patients SET name = ?, phone = ?, \n"+
"                 address = ?, insurance_policy_id = ?\n"+
"               WHERE patient_id = " + patient_id);
            }
            else
            {
              s = form.conn.prepareStatement("\n"+
"               INSERT INTO patients (name, phone, address, insurance_policy_id)\n"+
"               VALUES (?,?,?,?)");
            }
            try
            {
              s.setString(1, name.text);
              s.setString(2, phone.text);
              s.setString(3, address.text);
              s.setInt(4, policy.id.intValue());
              s.executeUpdate();
            }
            finally
            {
              s.close();
            }
            
            if (patient_id <= 0)
            {
              q.query("SELECT currval('patients_patient_id_seq')");
              if (q != null && !q.r.next())
                patient_id = q.r.getInt(1);
            }
          }
          catch (SQLException e)
          {
            p(e);
          }
          catch (Throwable e)
          {
            Query.rethrow(e);
          }
          finally
          {
            q.close();
          }
          return true;
        }
        
        public void display(boolean hidden)
        {
    super.display(hidden);
    
    if (hidden || modalChild != null) return;
    
    p(
"<table>\n"+
"<tr>\n"+
"  <td valign=top>Name:</td>\n"+
"  <td>"); name.display(); p("</td>\n"+
"</tr>\n"+
"<tr>\n"+
"  <td valign=top>Phone:</td>\n"+
"  <td>"); phone.display(); p("</td>\n"+
"</tr>\n"+
"<tr>\n"+
"  <td valign=top>Address:</td>\n"+
"  <td>"); address.display(); p("</td>\n"+
"</tr>\n"+
"<tr>\n"+
"  <td valign=top>Insurance Policy:</td>\n"+
"  <td>"); policy.display(); p("</td>\n"+
"</tr>\n"+
"<tr>\n"+
"  <td>&nbsp;</td>\n"+
"  <td>\n"+
"  "); action.display("Save Changes", SAVE); action.display("Cancel", CANCEL); 
p("\n"+
"  </td>\n"+
"</td>\n"+
"</table>\n"+
"");
        }
};

---