NullPointerException

[mjz]

Hi,
I need help on why am getting a NPE with the code below.I am connecting to Ora 11g using JDBC in OracleCon which works well but executing the SQL code throws an NPE.
Thax.



package zm.crb;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;

public class User {
private String username;
private String password;
private int alevel;
private int manNo;
private int deptID;
private int x;
String y;

public User() {
}
public User(String username,String password) {
this.username = username;
this.password = password;
}
public User(int manNo,String username,String password, int alevel,int dept) {
this.username = username;
this.password = password;
this.alevel= alevel;
this.manNo=manNo;
this.deptID=dept;
}
public String addUser(){
OracleCon db = new OracleCon();
Statement st = db.getScrollableStatement();
try{
if(db.connect()){
String query="INSERT INTO mjzeko.Users VALUES('"+manNo+"','"+username+"', '"+password+"', '"+alevel+"','','','"+deptID+"')";
st.executeUpdate(query);

db.disconnect();
return "You created a User";
}
else{
return "No conn to DB Failure See DBA >>>";
}

}
catch(SQLException e){
e.printStackTrace();
return "exception occured";
}

}


public boolean aunthenticate1(String username,String password){
OracleCon db = new OracleCon();
Statement st2 = db.getScrollableStatement();
try{
if(db.connect()){
String uquery = "Select * from mjzeko.users";
ResultSet res = st2.executeQuery(uquery);
while (res.next()){
x=Integer.parseInt(res.getString(1));
y=res.getString(2);
System.out.print(x);
System.out.print(y);
st2.close();
}
return true;
}
else
return false;
}

catch(Exception ex)
{ ex.printStackTrace();
System.out.print("This is where I end up");
return false;
}
}
public static void main(String args[]){
User c=new User("mjzeko","12345");
System.out.print(c.aunthenticate1("mjzeko","12345" ));
}
}

stackTrace:

java.lang.NullPointerException This is where I end upfalse
at zm.crb.User.aunthenticate1(User.java:74)
at zm.crb.User.main(User.java:107)

[britto_bicsjohn]

if u use
Select * from mjzeko.users some time the record is fetched.but traversing
record will be problametic.you specifiy the excat field names you want.
EX: SELECT USER_NAME,PASS_WARD FROM tbl_user; something like this

INSERT INTO mjzeko.Users VALUES('"+manNo+"','"+username+"', '"+password+"', '"+alevel+"','','','"+deptID+"')";

u specify the filed name and values in the querys
sure u will not get any problem