How to use

SimpleParameterList

in

org.postgresql.core.v2

public ParameterList createParameterList() {
  if (fragments.length == 1)
    return NO_PARAMETERS;
  return new SimpleParameterList(fragments.length - 1, useEStringSyntax);
}

protected void sendQuery(V2Query query, SimpleParameterList params, String queryPrefix) throws IOException {
  if (logger.logDebug())
    logger.debug(" FE=> Query(\"" + (queryPrefix == null ? "" : queryPrefix) + query.toString(params) + "\")");
  pgStream.SendChar('Q');
  Writer encodingWriter = pgStream.getEncodingWriter();
  if (queryPrefix != null)
    encodingWriter.write(queryPrefix);
  String[] fragments = query.getFragments();
  for (int i = 0 ; i < fragments.length; ++i)
  {
    encodingWriter.write(fragments[i]);
    if (i < params.getParameterCount())
      params.writeV2Value(i + 1, encodingWriter);
  }
  encodingWriter.write(0);
  pgStream.flush();
}

public void setIntParameter(int index, int value) throws SQLException {
  setLiteralParameter(index, "" + value, Oid.INT4);
}

void writeV2Value(int index, Writer encodingWriter) throws IOException {
  if (paramValues[index - 1] instanceof StreamWrapper)
  {
    streamBytea((StreamWrapper)paramValues[index - 1], encodingWriter);
  }
  else
  {
    encodingWriter.write((String)paramValues[index - 1]);
  }
}

  parameters = (SimpleParameterList)query.createParameterList();
parameters.checkAllParametersSet();

void writeV2Value(int index, Writer encodingWriter) throws IOException {
  if (paramValues[index - 1] instanceof StreamWrapper)
  {
    streamBytea((StreamWrapper)paramValues[index - 1], encodingWriter);
  }
  else
  {
    encodingWriter.write((String)paramValues[index - 1]);
  }
}

  parameters = (SimpleParameterList)query.createParameterList();
parameters.checkAllParametersSet();

protected void sendQuery(V2Query query, SimpleParameterList params, String queryPrefix) throws IOException {
  if (logger.logDebug())
    logger.debug(" FE=> Query(\"" + (queryPrefix == null ? "" : queryPrefix) + query.toString(params) + "\")");
  pgStream.SendChar('Q');
  Writer encodingWriter = pgStream.getEncodingWriter();
  if (queryPrefix != null)
    encodingWriter.write(queryPrefix);
  String[] fragments = query.getFragments();
  for (int i = 0 ; i < fragments.length; ++i)
  {
    encodingWriter.write(fragments[i]);
    if (i < params.getParameterCount())
      params.writeV2Value(i + 1, encodingWriter);
  }
  encodingWriter.write(0);
  pgStream.flush();
}

public void setStringParameter(int index, String value, int oid) throws SQLException {
  StringBuffer sbuf = new StringBuffer(2 + value.length() * 11 / 10); // Add 10% for escaping.
  if (useEStringSyntax)
    sbuf.append(' ').append('E');
  sbuf.append('\'');
  Utils.appendEscapedLiteral(sbuf, value, false);
  sbuf.append('\'');
  setLiteralParameter(index, sbuf.toString(), oid);
}

public ParameterList copy() {
  SimpleParameterList newCopy = new SimpleParameterList(paramValues.length, useEStringSyntax);
  System.arraycopy(paramValues, 0, newCopy.paramValues, 0, paramValues.length);
  return newCopy;
}

void writeV2Value(int index, Writer encodingWriter) throws IOException {
  if (paramValues[index - 1] instanceof StreamWrapper)
  {
    streamBytea((StreamWrapper)paramValues[index - 1], encodingWriter);
  }
  else
  {
    encodingWriter.write((String)paramValues[index - 1]);
  }
}

  parameters = (SimpleParameterList)query.createParameterList();
parameters.checkAllParametersSet();

protected void sendQuery(V2Query query, SimpleParameterList params, String queryPrefix) throws IOException {
  if (logger.logDebug())
    logger.debug(" FE=> Query(\"" + (queryPrefix == null ? "" : queryPrefix) + query.toString(params) + "\")");
  pgStream.SendChar('Q');
  Writer encodingWriter = pgStream.getEncodingWriter();
  if (queryPrefix != null)
    encodingWriter.write(queryPrefix);
  String[] fragments = query.getFragments();
  for (int i = 0 ; i < fragments.length; ++i)
  {
    encodingWriter.write(fragments[i]);
    if (i < params.getParameterCount())
      params.writeV2Value(i + 1, encodingWriter);
  }
  encodingWriter.write(0);
  pgStream.flush();
}

public void setIntParameter(int index, int value) throws SQLException {
  setLiteralParameter(index, "" + value, Oid.INT4);
}

public ParameterList createParameterList() {
  if (fragments.length == 1)
    return NO_PARAMETERS;
  return new SimpleParameterList(fragments.length - 1, useEStringSyntax);
}

public void setIntParameter(int index, int value) throws SQLException {
  setLiteralParameter(index, "" + value, Oid.INT4);
}

public ParameterList createParameterList() {
  if (fragments.length == 1)
    return NO_PARAMETERS;
  return new SimpleParameterList(fragments.length - 1, useEStringSyntax);
}

public void setStringParameter(int index, String value, int oid) throws SQLException {
  StringBuffer sbuf = new StringBuffer(2 + value.length() * 11 / 10); // Add 10% for escaping.
  if (useEStringSyntax)
    sbuf.append(' ').append('E');
  sbuf.append('\'');
  Utils.appendEscapedLiteral(sbuf, value, false);
  sbuf.append('\'');
  setLiteralParameter(index, sbuf.toString(), oid);
}

public ParameterList copy() {
  SimpleParameterList newCopy = new SimpleParameterList(paramValues.length, useEStringSyntax);
  System.arraycopy(paramValues, 0, newCopy.paramValues, 0, paramValues.length);
  return newCopy;
}

public void setStringParameter(int index, String value, int oid) throws SQLException {
  StringBuffer sbuf = new StringBuffer(2 + value.length() * 11 / 10); // Add 10% for escaping.
  if (useEStringSyntax)
    sbuf.append(' ').append('E');
  sbuf.append('\'');
  Utils.appendEscapedLiteral(sbuf, value, false);
  sbuf.append('\'');
  setLiteralParameter(index, sbuf.toString(), oid);
}