java resultset

Piotr Kirklewski — Sat, 06 Jun 2009 02:13:20 GMT

Hi there

I have a strange problem with my Java app.
I'm testing if username and password is correct and retrieve 1 or 0.
But when I test with if (a == "1") then I get negative response as if the value stored in 'a' doesn't match.
I debugged the application but debugger shows a = "1" so I'm completely stupefied by this.
Please help.

===============================================

Statement select = c.createStatement();
ResultSet result = select.executeQuery("select count(*) from system_user where nm = '"
+ username + "' and pwd = '" + password + "'");

if (result != null) {
System.out.println("result !null");
while (result.next()) {
a = result.getString(1);
System.out.println(a);

if (a == "1"){
System.out.println(result.getString(1) + "Access granted");
}

}
}

if (a == "1"){
System.out.println("Access granted !!!");

}else{
System.out.println("User " + username + " does not exists in the databse!!!");
}

result.close();

Re: java resultset

Dennis Handly — Sat, 06 Jun 2009 08:05:39 GMT

Any embedded nulls? What is the length?
What version of Java?

Re: java resultset

Piotr Kirklewski — Sat, 06 Jun 2009 17:19:03 GMT

Nothing that I know of.

java version "1.6.0_14"

topic java resultset in Operating System - HP-UX

java resultset

Re: java resultset

Re: java resultset