3 public class QueryBuilder {
\r
5 private String whereClause;
\r
6 private String orderByClause;
\r
8 public QueryBuilder(){
\r
9 whereClause = new String();
\r
10 orderByClause = new String();
\r
13 public void appendDescendingOrder(String anOrder) {
\r
14 if (orderByClause.length()==0) {
\r
15 orderByClause=anOrder+" desc";
\r
18 orderByClause=orderByClause+","+anOrder+" desc";
\r
22 public void appendAscendingOrder(String anOrder) {
\r
23 if (orderByClause.length()==0) {
\r
24 orderByClause=anOrder+" asc";
\r
27 orderByClause=orderByClause+","+anOrder+" asc";
\r
31 public void appendAndCondition(String aQualifier) {
\r
32 if (whereClause.length()==0) {
\r
33 whereClause = aQualifier;
\r
36 whereClause="("+whereClause+") and ("+aQualifier+")";
\r
40 public void appendOrCondition(String aQualifier) {
\r
41 if (whereClause.length()==0) {
\r
42 whereClause = aQualifier;
\r
45 whereClause="("+whereClause+") or ("+aQualifier+")";
\r
49 public String getWhereClause() {
\r
53 public String getOrderByClause() {
\r
54 return orderByClause;
\r