Thread: nulls in sql and jdbc

How exactly do I use nulls in sql and java?

What I mean is, when I want a column in my database to be set to null, can I
just use
  prepStmt.setString(1, null)
and would this work for setting columns of any type?

Conversely, for reading values in that are a null in sql, could I for example
say
  String str = resltSet.getString("columnName");
  if (str.equals(null))
  {
    ....
  }
and again, is this valid for any type in java or sql?



_______________________________________________________________________
All the good things in life are either illegal, immoral or fattening.

use prepStmt.setNull("columnName");

and Stirng str = resultSet.getString("columnName");

if (resultSet.wasNull()) { }

http://java.sun.com/j2se/1.4.2/docs/api/ look under the java.sql
package.

Regards
Marcin Jekot

On Sun, 2003-10-19 at 14:43, J Joubert wrote:
> How exactly do I use nulls in sql and java?
>
> What I mean is, when I want a column in my database to be set to null, can I
> just use
>   prepStmt.setString(1, null)
> and would this work for setting columns of any type?
>
> Conversely, for reading values in that are a null in sql, could I for example
> say
>   String str = resltSet.getString("columnName");
>   if (str.equals(null))
>   {
>     ....
>   }
> and again, is this valid for any type in java or sql?
>
>
>
> _______________________________________________________________________
> All the good things in life are either illegal, immoral or fattening.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>