org.postgresql.core.ParameterList.setNull java code examples

Common ways to obtain ParameterList

private void myMethod () {
 ParameterList p =SimpleParameterList[] subparams;new CompositeParameterList(subparams, offsets)
QueryExecutor queryExecutor;queryExecutor.createFastpathParameters(count)
new FastpathParameterList(paramCount)
Smart code suggestions by Tabnine
}

  void populateParameter(ParameterList params, int index) throws SQLException {
    if (bytes == null)
      params.setNull(index, 0);
    else
      params.setBytea(index, bytes, bytesStart, bytesLength);
  }
}

 void populateParameter(ParameterList params, int index) throws SQLException {
  if (bytes == null) {
   params.setNull(index, 0);
  } else {
   params.setBytea(index, bytes, bytesStart, bytesLength);
  }
 }
}

protected void setString(int parameterIndex, String x, int oid) throws SQLException {
 // if the passed string is null, then set this column to null
 checkClosed();
 if (x == null) {
  preparedParameters.setNull(parameterIndex, oid);
 } else {
  bindString(parameterIndex, x, oid);
 }
}

protected void setString(int parameterIndex, String x, int oid) throws SQLException
{
  // if the passed string is null, then set this column to null
  checkClosed();
  if (x == null)
  {
    if ( adjustIndex )
      parameterIndex--;   
    preparedParameters.setNull( parameterIndex, oid);
  }
  else
    bindString(parameterIndex, x, oid);
}

public void setNull(int parameterIndex, int targetSqlType) throws SQLException
{
  checkClosed();
  int oid;
  switch (targetSqlType)
  {
    case Types.SQLXML:
      oid = Oid.XML;
      break;
    default:
      super.setNull(parameterIndex, targetSqlType);
      return;
  }
  if (adjustIndex)
    parameterIndex--;
  preparedParameters.setNull(parameterIndex, oid);
}

public void setNull(int parameterIndex, int t, String typeName) throws SQLException {
 if (typeName == null) {
  setNull(parameterIndex, t);
  return;
 }
 checkClosed();
 TypeInfo typeInfo = connection.getTypeInfo();
 int oid = typeInfo.getPGType(typeName);
 preparedParameters.setNull(parameterIndex, oid);
}

preparedParameters.setNull(parameterIndex, oid);

preparedParameters.setNull( parameterIndex, oid);

  void populateParameter(ParameterList params, int index) throws SQLException {
    if (bytes == null)
      params.setNull(index, 0);
    else
      params.setBytea(index, bytes, bytesStart, bytesLength);
  }
}

  void populateParameter(ParameterList params, int index) throws SQLException {
    if (bytes == null)
      params.setNull(index, 0);
    else
      params.setBytea(index, bytes, bytesStart, bytesLength);
  }
}

protected void setString(int parameterIndex, String x, int oid) throws SQLException
{
  // if the passed string is null, then set this column to null
  checkClosed();
  if (x == null)
  {
    if ( adjustIndex )
      parameterIndex--;   
    preparedParameters.setNull( parameterIndex, oid);
  }
  else
    bindString(parameterIndex, x, oid);
}

protected void setString(int parameterIndex, String x, int oid) throws SQLException
{
  // if the passed string is null, then set this column to null
  checkClosed();
  if (x == null)
  {
    if ( adjustIndex )
      parameterIndex--;   
    preparedParameters.setNull( parameterIndex, oid);
  }
  else
    bindString(parameterIndex, x, oid);
}

public void setNull(int parameterIndex, int targetSqlType) throws SQLException
{
  checkClosed();
  int oid;
  switch (targetSqlType)
  {
    case Types.SQLXML:
      oid = Oid.XML;
      break;
    default:
      super.setNull(parameterIndex, targetSqlType);
      return;
  }
  if (adjustIndex)
    parameterIndex--;
  preparedParameters.setNull(parameterIndex, oid);
}

public void setNull(int parameterIndex, int targetSqlType) throws SQLException
{
  checkClosed();
  int oid;
  switch (targetSqlType)
  {
    case Types.SQLXML:
      oid = Oid.XML;
      break;
    default:
      super.setNull(parameterIndex, targetSqlType);
      return;
  }
  if (adjustIndex)
    parameterIndex--;
  preparedParameters.setNull(parameterIndex, oid);
}

preparedParameters.setNull( parameterIndex, oid);

preparedParameters.setNull( parameterIndex, oid);

Javadoc

Binds a SQL NULL value to a parameter. Associated with the parameter is a typename for the parameter that should correspond to an entry in pg_types.

Popular methods of ParameterList

clear
Unbind all parameter values bound in this list.
copy
Perform a shallow copy of this ParameterList, returning a new instance (still suitable for passing t
getInParameterCount
Get the number of IN parameters in this list.
getOutParameterCount
Get the number of OUT parameters in this list.
getParameterCount
Get the number of parameters in this list. This value never changes for a particular instance, and m
getTypeOIDs
Return the oids of the parameters in this list. May be null for a ParameterList that does not suppor
registerOutParameter
setBytea
Binds a binary bytea value stored as a bytearray to a parameter. The parameter's type is implicitly
setLiteralParameter
Binds a String value that is an unquoted literal to the server's query parser (for example, a bare i
setStringParameter
Binds a String value that needs to be quoted for the server's parser to understand (for example, a t
toString
Return a human-readable representation of a particular parameter in this ParameterList. If the param
appendAll
Use this operation to append more parameters to the current list.

Popular in Java

Creating JSON documents from java classes using gson
onCreateOptionsMenu (Activity)
startActivity (Activity)
getSharedPreferences (Context)
Time (java.sql)
Java representation of an SQL TIME value. Provides utilities to format and parse the time's represen
DataSource (javax.sql)
An interface for the creation of Connection objects which represent a connection to a database. This
BoxLayout (javax.swing)
JOptionPane (javax.swing)
BasicDataSource (org.apache.commons.dbcp)
Basic implementation of javax.sql.DataSource that is configured via JavaBeans properties. This is no
DateTimeFormat (org.joda.time.format)
Factory that creates instances of DateTimeFormatter from patterns and styles. Datetime formatting i

How to use setNullmethodin org.postgresql.core.ParameterList

Best Java code snippets using org.postgresql.core.ParameterList.setNull (Showing top 16 results out of 315)

How to use
setNull
method
in
org.postgresql.core.ParameterList