Package ch.inftec.ju.util

Examples of ch.inftec.ju.util.XString.addText()


      } else {
        XString xs = new XString();
        xs.addFormatted("SELECT * FROM %s ORDER BY ", tableName);
        for (String orderColumn : orderColumns) {
          xs.assertText("ORDER BY ", ", ");
          xs.addText(orderColumn);
        }
       
        return this.addTable(tableName, xs.toString());
      }
    }
View Full Code Here


      } else {
        XString xs = new XString();
        xs.addFormatted("SELECT * FROM %s ORDER BY ", tableName);
        for (String orderColumn : orderColumns) {
          xs.assertText("ORDER BY ", ", ");
          xs.addText(orderColumn);
        }
       
        return this.addTable(tableName, xs.toString());
      }
    }
View Full Code Here

      } else {
        XString xs = new XString();
        xs.addFormatted("SELECT * FROM %s ORDER BY ", tableName);
        for (String orderColumn : orderColumns) {
          xs.assertText("ORDER BY ", ", ");
          xs.addText(orderColumn);
        }
       
        return this.addTable(tableName, xs.toString());
      }
    }
View Full Code Here

            throw new JuRuntimeException("Couldn't introspect bean", ex);
          }
        }
       
        if (xsWhere.isEmpty()) {
          xsWhere.addText("1 = 1");
        }
        String whereClause = String.format("(%s)", xsWhere.toString());
       
        while (actualQuery.indexOf(this.whereClausePlaceholder) > 0) {
          actualQuery = actualQuery.replace(this.whereClausePlaceholder, whereClause);
View Full Code Here

      // Add order by clause
      if (this.ordering.size() > 0) {
        XString xsOrderBy = new XString();
        for (AttributeOrdering ao : this.ordering) {
          xsOrderBy.assertEmptyOrText(", ");
          xsOrderBy.addText(this.getActualColumnName(ao.getAttributeName()));
          if (ao.getOrdering() == Ordering.DESCENDING) xsOrderBy.addText(" desc");
        }
       
        while (actualQuery.indexOf(this.orderByClausePlaceholder) > 0) {
          actualQuery = actualQuery.replace(this.orderByClausePlaceholder, xsOrderBy.toString());
View Full Code Here

      if (this.ordering.size() > 0) {
        XString xsOrderBy = new XString();
        for (AttributeOrdering ao : this.ordering) {
          xsOrderBy.assertEmptyOrText(", ");
          xsOrderBy.addText(this.getActualColumnName(ao.getAttributeName()));
          if (ao.getOrdering() == Ordering.DESCENDING) xsOrderBy.addText(" desc");
        }
       
        while (actualQuery.indexOf(this.orderByClausePlaceholder) > 0) {
          actualQuery = actualQuery.replace(this.orderByClausePlaceholder, xsOrderBy.toString());
        }
View Full Code Here

      } else {
        XString xs = new XString();
        xs.addFormatted("SELECT * FROM %s ORDER BY ", tableName);
        for (String orderColumn : orderColumns) {
          xs.assertText("ORDER BY ", ", ");
          xs.addText(orderColumn);
        }
       
        return this.addTable(tableName, xs.toString());
      }
    }
View Full Code Here

      updateQry = new XString("UPDATE " + this.getTableName() + " SET ");
     
      int i = 0;
      for (Val changedColumn : changedColumns) {
        updateQry.assertText("SET ", ", ");
        updateQry.addText(changedColumn.getColumnName() + "=?");
        changedVals[i] = changedColumns[i].getChangedValue();
        i++;
      }
     
      updateQry.addText(" WHERE " + this.getPrimaryKeyValue().getColumnName() + "=?");
View Full Code Here

        updateQry.addText(changedColumn.getColumnName() + "=?");
        changedVals[i] = changedColumns[i].getChangedValue();
        i++;
      }
     
      updateQry.addText(" WHERE " + this.getPrimaryKeyValue().getColumnName() + "=?");
      changedVals[i] = this.getPrimaryKeyValue().getOriginalValue();
     
      int res = this.getDbConnection().getQueryRunner().update(updateQry.toString(), changedVals);
      if (res != 1) throw new JuDbException("Execution of query returned " + res + ", expected 1: " + updateQry);
    } catch (Exception ex) {
View Full Code Here

   
    @Override
    public String toString() {
      XString val = new XString();
      val.addFormatted("%s(%s", this.getColumnName(), this.getOriginalValue());
      if (this.hasChanged()) val.addText(">", this.getChangedValue());
      val.addText(")");
     
      return val.toString();
    }
  }
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.