5 public class SQLQueryBuilder {
6 private StringBuffer whereClause;
7 private StringBuffer orderByClause;
9 public SQLQueryBuilder(){
10 whereClause = new StringBuffer();
11 orderByClause = new StringBuffer();
14 public void appendDescendingOrder(String anOrder) {
15 if (orderByClause.length()==0) {
16 orderByClause.append(anOrder).append(" desc");
19 orderByClause.append(",").append(anOrder).append(" desc");
23 public void appendAscendingOrder(String anOrder) {
24 if (orderByClause.length()==0) {
25 orderByClause.append(anOrder).append(" asc");
28 orderByClause=orderByClause.append(",").append(anOrder).append(" asc");
32 public void appendAndCondition(String aQualifier) {
33 if (whereClause.length()==0) {
34 whereClause.append("(").append(aQualifier).append(")");
37 whereClause.append(" and (").append(aQualifier).append(")");
41 public void appendOrCondition(String aQualifier) {
42 if (whereClause.length()==0) {
43 whereClause.append(aQualifier);
46 whereClause.append("(").append(whereClause).append(") or (").append(aQualifier).append(")");
50 public String getWhereClause() {
51 return whereClause.toString();
54 public String getOrderByClause() {
55 return orderByClause.toString();