NullPointer Exception using JDBC

[Paras Ahuja]

Hi everyone,
i am encountring a very strange problem. I have two textfields tf[0] and tf[1] on a JFrame. Now, when anyone clicks on Ok button(again a component in my frame), the texts of the textfields are compared to values in an excel sheet. If the text entered in textfields already exist in the excel sheet, it generates error. Here is part of my code:

rs=stmt.executeQuery("Select [NE NAME],[Access IP] from [Sheet1$]" );
				while(rs.next())
				{
					if(rs.getString(1).equals(tf[0].getText()))
					{
						tf[0].setBackground(Color.RED);
						c.gridx=0;
						c.gridy=200;
						c.insets=new Insets(20, 20, 0, 0);
						getContentPane().add(error1,c);
						revalidate();
						repaint();
						return;
					}
					if(rs.getString(2).equals(tf[1].getText()))
					{
						tf[1].setBackground(Color.RED);
						c.gridx=0;
						c.gridy=200;
						getContentPane().add(error2,c);
						revalidate();
						repaint();
						return;
					}
				}

Now, the problem is: whenever i enter a value (already existing in the excel) in tf[1] ie. for Access IP, the code runs perfectly and it displays the error as its supposed to.
But when i enter a value (which is new and doesn't exist in excel) it generates following error:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
Excel shows the error occurs at the { after the following line:

if(rs.getString(2).equals(tf[1].getText()))

Please help....

[Darryl Burke]

Break that up and add a debug sysout.

String two = rs.getString(2);
System.out.println(two);
if(two.equals(tf[1].getText())) {
...

[Paras Ahuja]

Thanks, but its still not working....
Do you know why the error is being generated?

[Maneesh Godbole]

Paras Ahuja wrote:Thanks, but its still not working....
Do you know why the error is being generated?

ItDoesntWorkIsUseless
Copy paste the full stack trace. The error indicates some variable is null.

[Rob Spoor]

Probably rs.getString(1) returns null.