Thread: Error 500--Internal Server Error java.lang.NullPointerException

[jackdear44]

after executin this code it shows nullpointerexception......pls help


public int securityLevel(String userid, String password) throws SQLException,
MalformedURLException,
IOException {
connect();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIV E, ResultSet.CONCUR_READ_ONLY);
String SQL = "select * from USERS";
int result=1;
String [] security= new String [2];
System.out.println("\nExecuting query: " + SQL);
rset = stmt.executeQuery(SQL);

while(rset.next()){
security[0]=rset.getString(1);
security[1]=rset.getString(2);
security[2]=rset.getString(3);
if(userid.equals(security[0])&&password.equals(security[1])){
result=Integer.parseInt(security[2]);
System.out.println(security[2]);
}
}
return result;
}

[pbrockway2]

The message indicates that you are trying to use a variable or expression whose value is null. The error message will say on what line this is happening: it would be good to share this information.

But it's certainly before this line:

security[2]=rset.getString(3);

which is going to throw an ArrayIndexOutOfBoundsException as you declare security to be an array of two strings, not three.