How do I keep proceeding

If there's a null in the table and when the resultset is returned.

And when we process the resultset, it throws a NullPointerException

like in the following piece of code.

pstmt=con.prepareStatement("SELECT * FROM product where p_id=?");

pstmt.setInt(1,id);

ResultSet rs=pstmt.executeQuery();

textfield.setText(rs.getString(1));

lets assume there's a table Products with a column that says description.

And it can be null.

The problem is that, it exits with a NullPointerException at that point.

What if I want to still keep processing the other data, even though a field is null. How do I do that?

[692 byte] By [ArcherKinga] at [2007-11-27 5:46:46]