org.turro.contacts.util.MostUsed Class Reference

Static Public Member Functions
static String	getConnector (String choices, String defaultChoice)
static String	getAddress (String choices, String defaultChoice)

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 29 of file MostUsed.java.

Member Function Documentation

getAddress()

static String org.turro.contacts.util.MostUsed.getAddress ( String  choices, String  defaultChoice  )

static

Definition at line 43 of file MostUsed.java.

                                                                        {
    Dao dao = new ContactsPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select address.description, count(address.description)");
    wc.addClause("from Address address");
    wc.addClause("where address.description in (" + SQLHelper.quoteTokensForIn(choices) + ")");
    wc.addClause("group by address.description");
    wc.addClause("order by count(address.description) DESC");
    Object o[] = (Object[]) dao.getSingleResult(wc);
    return (String) ((o == null || o.length == 0 || o[0] == null) ? defaultChoice : o[0]);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getConnector()

static String org.turro.contacts.util.MostUsed.getConnector ( String  choices, String  defaultChoice  )

static

Definition at line 31 of file MostUsed.java.

                                                                          {
    Dao dao = new ContactsPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select connector.description, count(connector.description)");
    wc.addClause("from Connector connector");
    wc.addClause("where connector.description in (" + SQLHelper.quoteTokensForIn(choices) + ")");
    wc.addClause("group by connector.description");
    wc.addClause("order by count(connector.description) DESC");
    Object o[] = (Object[]) dao.getSingleResult(wc);
    return (String) ((o == null || o.length == 0 || o[0] == null) ? defaultChoice : o[0]);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• MostUsed.java