@Override public String toString() { StringBuilder buffer = new StringBuilder(); for (int i = 0; i < selects.size(); i++) { if (i != 0) { buffer.append(" ").append(operations.get(i - 1).toString()).append(" "); } if (brackets == null || brackets.get(i)) { buffer.append("(").append(selects.get(i).toString()).append(")"); } else { buffer.append(selects.get(i).toString()); } } if (orderByElements != null) { buffer.append(PlainSelect.orderByToString(orderByElements)); } if (limit != null) { buffer.append(limit.toString()); } if (offset != null) { buffer.append(offset.toString()); } if (fetch != null) { buffer.append(fetch.toString()); } return buffer.toString(); }
@Override public String toString() { StringBuilder buffer = new StringBuilder(); for (int i = 0; i < selects.size(); i++) { if (i != 0) { buffer.append(" ").append(operations.get(i - 1).toString()).append(" "); } if (brackets == null || brackets.get(i)) { buffer.append("(").append(selects.get(i).toString()).append(")"); } else { buffer.append(selects.get(i).toString()); } } if (orderByElements != null) { buffer.append(PlainSelect.orderByToString(orderByElements)); } if (limit != null) { buffer.append(limit.toString()); } if (offset != null) { buffer.append(offset.toString()); } if (fetch != null) { buffer.append(fetch.toString()); } return buffer.toString(); }
@Override public String toString() { StringBuilder buf = new StringBuilder(); for (int i = 0; i < getPlainSelects().size(); i++) { if (i != 0) { buf.append(" ") .append(getOperations().get(i - 1).toString()) .append(" "); } buf.append(getPlainSelects().get(i).toString()); } if (getOrderByElements() != null) { buf.append(PlainSelect.orderByToString(getOrderByElements())); } if (getLimit() != null) { buf.append(getLimit().toString()); } return buf.toString(); }
if (ps.getLimit()!=null && ps.getLimit().getRowCount() == 0 && ps.getLimit().toString().equals("")) { ret += " LIMIT 0";