3 public class SQLQueryBuilder {
4 private StringBuffer whereClause;
5 private StringBuffer orderByClause;
7 public SQLQueryBuilder(){
8 whereClause = new StringBuffer();
9 orderByClause = new StringBuffer();
12 public void appendDescendingOrder(String anOrder) {
13 if (orderByClause.length()==0) {
14 orderByClause.append(anOrder).append(" desc");
17 orderByClause.append(",").append(anOrder).append(" desc");
21 public void appendAscendingOrder(String anOrder) {
22 if (orderByClause.length()==0) {
23 orderByClause.append(anOrder).append(" asc");
26 orderByClause=orderByClause.append(",").append(anOrder).append(" asc");
30 public void appendAndCondition(String aQualifier) {
31 if (whereClause.length()==0) {
32 whereClause.append("(").append(aQualifier).append(")");
35 whereClause.append(" and (").append(aQualifier).append(")");
39 public void appendOrCondition(String aQualifier) {
40 if (whereClause.length()==0) {
41 whereClause.append(aQualifier);
44 whereClause.append("(").append(whereClause).append(") or (").append(aQualifier).append(")");
48 public String getWhereClause() {
49 return whereClause.toString();
52 public String getOrderByClause() {
53 return orderByClause.toString();