SelectBox.java

Go to the documentation of this file.

import java.util.Map;
import java.util.HashMap;
import java.util.Set;
import java.util.Iterator;
import java.sql.SQLException;

public class SelectBox extends Widget
{ 
  public int rows;
  public String text;
  public boolean multi;

  Integer id;
  Map ids = new HashMap();
        
        public SelectBox(boolean multi, int rows, String prefix, Form form)
        {
          super(prefix, form);
          this.rows = rows;
          this.multi = multi;
        }
        
        public void loadValues()
        {
    if (multi)
    {
      String[] v = form.req.getParameterValues(prefix);
      if (v == null) return;
      int vl = v.length;
      for(int i = 0; i < vl; ++i)
      {
        int n = toInt(v[i],0);
        if (n > 0) ids.put(new Integer(n), null);
      }
    }
    else
    {
      String s = loadAttribute();
      if (s != null) id = new Integer(toInt(s,0));
    }  
        }
                
        public void display(boolean hidden)
        {
          display(hidden, null);
        }
        
        public void display(boolean hidden, String query)
        {
          if (hidden)
          {
            if (multi)
            {
              Set s = ids.keySet();
              Iterator i = s.iterator();
              while(i.hasNext())
              {
                Integer n = (Integer) i.next();
                printAttribute(null, n.toString());
              }
            }
            else
            {
              if (id != null)
                printAttribute(null, id.toString());
            }
            return;
          }

        p("<select name=" + prefix + " rows=" + rows + (multi ? " multiple" : "") + ">\n");
    if (query != null)
    {
      form.connectDb();
      Query q = new Query(form.conn, form.pw, query);
      try
      {
              if (q.r != null)
              while (q.r.next())
              {
                int rid = q.r.getInt(1);
                String rname = q.r.getString(2);
                String s = (multi && ids.containsKey(new Integer(rid)))
                  || (!multi && id != null && id.intValue() == rid) ?
            " selected" : "";
                      p("  <option value=" + rid + s + ">" + htmlencode(rname) + "</option>\n");
              }
            }
            catch (SQLException e)
            {
              p(e);
            }
            finally
            {
              q.close();
            }
          }
          p("</select>\n");
        }
};

---