How can i know the String object is created or is null

[mahesh]

HI alll

in my code i want to check that the sql query return null value
and if the query return null value the i hav to use

stmt.setXXX(1,Types.some oracle type)
else
i hav to set other value for that column using
stmt.setXXX(1,****)
to find null values i'm using
String st=rst.getInt(1).toString();
but if it returns null then it set the st=null
and it trhows null pointer exception
is there any way to achieve this

 

[Bart Cremers]

HI alll

in my code i want to check that the sql query return null value
and if the query return null value the i hav to use

stmt.setXXX(1,Types.some oracle type)
else
i hav to set other value for that column using
stmt.setXXX(1,****)
to find null values i'm using
String st=rst.getInt(1).toString();
but if it returns null then it set the st=null
and it trhows null pointer exception
is there any way to achieve this

If you want to receive a String from a resultset it's better to use
rst.getString(index). So:

String st = rst.getString(1);

if (st == null) {
doSomething();
} else {
doSomethingElse();
}


Regards,

Bart

 

[Andrew Thompson]

mahesh wrote:
....

in my code i want to check that the sql query return null value
and if the query return null value the i hav to use

if ( theString==null ) {
// ...

Have you considered doing the basic Java tutorial?
<http://java.sun.com/docs/books/tutorial/index.html>

Andrew T.

 

[Patricia Shanahan]

HI alll

in my code i want to check that the sql query return null value
and if the query return null value the i hav to use

stmt.setXXX(1,Types.some oracle type)
else
i hav to set other value for that column using
stmt.setXXX(1,****)
to find null values i'm using
String st=rst.getInt(1).toString();
but if it returns null then it set the st=null
and it trhows null pointer exception
is there any way to achieve this

If that line itself throws the exception, you are not even getting to
the point of calling toString.

Is it possible that rst is null? If so, you need to test for that first.

As others have indicated, test for null by == comparison.

Patricia

 

[mahesh]

If you want to receive a String from a resultset it's better to use
rst.getString(index). So:

String st = rst.getString(1);

if (st == null) {
doSomething();
} else {
doSomethingElse();
}


Regards,

Bart

thank u

 

[mahesh]

If you want to receive a String from a resultset it's better to use
rst.getString(index). So:

String st = rst.getString(1);

if (st == null) {
doSomething();
} else {
doSomethingElse();
}


Regards,

Bart

thank u