/** * Returns the SQL for this buffer. * * @param replaceParams if true, then replace parameters with the * actual parameter values */ public String getSQL(boolean replaceParams) { resolveSubselects(); String sql = _sql.toString(); if (!replaceParams || _params == null || _params.isEmpty()) return sql; StringBuilder buf = new StringBuilder(); Iterator pi = _params.iterator(); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) != '?') { buf.append(sql.charAt(i)); continue; } Object param = pi.hasNext() ? pi.next() : null; if (param == null) buf.append("NULL"); else if (param instanceof Number || param instanceof Boolean) buf.append(param); else if (param instanceof String || param instanceof Character) buf.append("'").append(param).append("'"); else buf.append("?"); } return buf.toString(); }
/** * Returns the SQL for this buffer. * * @param replaceParams if true, then replace parameters with the * actual parameter values */ public String getSQL(boolean replaceParams) { resolveSubselects(); String sql = _sql.toString(); if (!replaceParams || _params == null || _params.isEmpty()) return sql; StringBuilder buf = new StringBuilder(); Iterator pi = _params.iterator(); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) != '?') { buf.append(sql.charAt(i)); continue; } Object param = pi.hasNext() ? pi.next() : null; if (param == null) buf.append("NULL"); else if (param instanceof Number || param instanceof Boolean) buf.append(param); else if (param instanceof String || param instanceof Character) buf.append("'").append(param).append("'"); else buf.append("?"); } return buf.toString(); }
/** * Returns the SQL for this buffer. * * @param replaceParams if true, then replace parameters with the * actual parameter values */ public String getSQL(boolean replaceParams) { resolveSubselects(); String sql = _sql.toString(); if (!replaceParams || _params == null || _params.isEmpty()) return sql; StringBuilder buf = new StringBuilder(); Iterator pi = _params.iterator(); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) != '?') { buf.append(sql.charAt(i)); continue; } Object param = pi.hasNext() ? pi.next() : null; if (param == null) buf.append("NULL"); else if (param instanceof Number || param instanceof Boolean) buf.append(param); else if (param instanceof String || param instanceof Character) buf.append("'").append(param).append("'"); else buf.append("?"); } return buf.toString(); }
/** * Returns the SQL for this buffer. * * @param replaceParams if true, then replace parameters with the * actual parameter values */ public String getSQL(boolean replaceParams) { resolveSubselects(); String sql = _sql.toString(); if (!replaceParams || _params == null || _params.isEmpty()) return sql; StringBuilder buf = new StringBuilder(); Iterator pi = _params.iterator(); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) != '?') { buf.append(sql.charAt(i)); continue; } Object param = pi.hasNext() ? pi.next() : null; if (param == null) buf.append("NULL"); else if (param instanceof Number || param instanceof Boolean) buf.append(param); else if (param instanceof String || param instanceof Character) buf.append("'").append(param).append("'"); else buf.append("?"); } return buf.toString(); }
/** * Returns the SQL for this buffer. * * @param replaceParams if true, then replace parameters with the * actual parameter values */ public String getSQL(boolean replaceParams) { resolveSubselects(); String sql = _sql.toString(); if (!replaceParams || _params == null || _params.isEmpty()) return sql; StringBuffer buf = new StringBuffer(); Iterator pi = _params.iterator(); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) != '?') { buf.append(sql.charAt(i)); continue; } Object param = pi.hasNext() ? pi.next() : null; if (param == null) buf.append("NULL"); else if (param instanceof Number || param instanceof Boolean) buf.append(param); else if (param instanceof String || param instanceof Character) buf.append("'").append(param).append("'"); else buf.append("?"); } return buf.toString(); }
/** * Resolve our delayed subselects. */ private void resolveSubselects() { if (_subsels == null || _subsels.isEmpty()) return; // add subsels backwards so that the stored insertion points of // later subsels remain valid Subselect sub; SQLBuffer buf; for (int i = _subsels.size() - 1; i >= 0; i--) { sub = (Subselect) _subsels.get(i); if (sub.count) buf = sub.select.toSelectCount(); else buf = sub.select.toSelect(false, sub.fetch); buf.resolveSubselects(); append(buf, sub.sqlIndex, sub.paramIndex, false); } _subsels.clear(); }
/** * Resolve our delayed subselects. */ private void resolveSubselects() { if (_subsels == null || _subsels.isEmpty()) return; // add subsels backwards so that the stored insertion points of // later subsels remain valid Subselect sub; SQLBuffer buf; for (int i = _subsels.size() - 1; i >= 0; i--) { sub = (Subselect) _subsels.get(i); if (sub.count) buf = sub.select.toSelectCount(); else buf = sub.select.toSelect(false, sub.fetch); buf.resolveSubselects(); append(buf, sub.sqlIndex, sub.paramIndex, false, false); } _subsels.clear(); }
/** * Resolve our delayed subselects. */ private void resolveSubselects() { if (_subsels == null || _subsels.isEmpty()) return; // add subsels backwards so that the stored insertion points of // later subsels remain valid Subselect sub; SQLBuffer buf; for (int i = _subsels.size() - 1; i >= 0; i--) { sub = (Subselect) _subsels.get(i); if (sub.count) buf = sub.select.toSelectCount(); else buf = sub.select.toSelect(false, sub.fetch); buf.resolveSubselects(); append(buf, sub.sqlIndex, sub.paramIndex, false, false); } _subsels.clear(); }
/** * Resolve our delayed subselects. */ private void resolveSubselects() { if (_subsels == null || _subsels.isEmpty()) return; // add subsels backwards so that the stored insertion points of // later subsels remain valid Subselect sub; SQLBuffer buf; for (int i = _subsels.size() - 1; i >= 0; i--) { sub = (Subselect) _subsels.get(i); if (sub.count) buf = sub.select.toSelectCount(); else buf = sub.select.toSelect(false, sub.fetch); buf.resolveSubselects(); append(buf, sub.sqlIndex, sub.paramIndex, false, false); } _subsels.clear(); }
/** * Resolve our delayed subselects. */ private void resolveSubselects() { if (_subsels == null || _subsels.isEmpty()) return; // add subsels backwards so that the stored insertion points of // later subsels remain valid Subselect sub; SQLBuffer buf; for (int i = _subsels.size() - 1; i >= 0; i--) { sub = (Subselect) _subsels.get(i); if (sub.count) buf = sub.select.toSelectCount(); else buf = sub.select.toSelect(false, sub.fetch); buf.resolveSubselects(); append(buf, sub.sqlIndex, sub.paramIndex, false, false); } _subsels.clear(); }