org.postgresql.jdbc2.AbstractJdbc2Statement.bindString java code examples

Add the Codota plugin to your IDE and get smart completions

private void myMethod () {
 StringBuilder s =new StringBuilder()
new StringBuilder(32)
String str;new StringBuilder(str)
Smart code suggestions by Codota
}

public void setBoolean(int parameterIndex, boolean x) throws SQLException
{
  checkClosed();
  bindString(parameterIndex, x ? "1" : "0", Oid.BOOL);
}

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 setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

  break;
case Types.DISTINCT:
  bindString(parameterIndex, in.toString(), Oid.UNSPECIFIED);
  break;
case Types.OTHER:
    setPGobject(parameterIndex, (PGobject)in);
  else
    bindString(parameterIndex, in.toString(), Oid.UNSPECIFIED);
  break;
default:

public void setBoolean(int parameterIndex, boolean x) throws SQLException
{
  checkClosed();
  bindString(parameterIndex, x ? "1" : "0", Oid.BOOL);
}

public void setBoolean(int parameterIndex, boolean x) throws SQLException
{
  checkClosed();
  bindString(parameterIndex, x ? "1" : "0", Oid.BOOL);
}

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 setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

  break;
case Types.DISTINCT:
  bindString(parameterIndex, in.toString(), Oid.UNSPECIFIED);
  break;
case Types.OTHER:
    setPGobject(parameterIndex, (PGobject)in);
  else
    bindString(parameterIndex, in.toString(), Oid.UNSPECIFIED);
  break;
default:

    setPGobject(parameterIndex, (PGobject)in);
  else
    bindString(parameterIndex, in.toString(), Oid.UNSPECIFIED);
  break;
default:

Popular methods of AbstractJdbc2Statement

addWarning
This adds a warning to the warning chain.
bindLiteral
checkClosed
checkIndex
helperfunction for the getXXX calls to check isFunction and index == 1
clearWarnings
close
createInternalType
createResultSet
escapeFunction
generate sql for escaped functions
execute
executeWithFlags
getLastOID

Popular in Java

Updating database using SQL prepared statement
addToBackStack (FragmentTransaction)
getOriginalFilename (MultipartFile)
Return the original filename in the client's filesystem.This may contain path information depending
startActivity (Activity)
MalformedURLException (java.net)
Thrown to indicate that a malformed URL has occurred. Either no legal protocol could be found in a s
Set (java.util)
A collection that contains no duplicate elements. More formally, sets contain no pair of elements e1
CountDownLatch (java.util.concurrent)
A synchronization aid that allows one or more threads to wait until a set of operations being perfor
Cipher (javax.crypto)
This class provides access to implementations of cryptographic ciphers for encryption and decryption
ServletException (javax.servlet)
Defines a general exception a servlet can throw when it encounters difficulty.
Response (javax.ws.rs.core)
Defines the contract between a returned instance and the runtime when an application needs to provid

How to use bindStringmethodin org.postgresql.jdbc2.AbstractJdbc2Statement

Best Java code snippets using org.postgresql.jdbc2.AbstractJdbc2Statement.bindString (Showing top 18 results out of 315)

How to use
bindString
method
in
org.postgresql.jdbc2.AbstractJdbc2Statement