Jdbc Java.lang.NullPointerException

Asked Apr 18 '18 at 18:35

Active Apr 18 '18 at 18:39

Viewed 30 times

Below is the part of code from my jsp page, when I am printing the rs.getString(1)is printing perfectly but as soon as i put the rs.getString(1) in if block it shows the null pointer exception. Please help

String nam=request.getParameter("n");
String query = "select name from ques where username='"+userid+"'";

Statement st=con.prepareStatement(query);

ResultSet rs = st.executeQuery(query);


while(rs.next()){

    out.println(rs.getString(1));

    if(rs.getString(1).equals(nam)){

        out.print("hello");

    }

}

edited Apr 18 '18 at 18:39

dave

50,635
4
62
77

asked Apr 18 '18 at 18:35

vikas Madaan

Do you mean if block or the while block? – dev8080 Apr 18 '18 at 18:42
3

The problem may be because of "nam" value. Can you try to print nam value? – grnc Apr 18 '18 at 18:42
1

Be careful! This code, as written, is a SQL Injection Attack waiting to happen. Read more at http://bobby-tables.com/ – Todd Apr 18 '18 at 18:51
I mean if block, yes i have printed nam value and it is accessible over there, the exception occurs if i put rs.getString in if() block – vikas Madaan Apr 18 '18 at 19:23

Jdbc Java.lang.NullPointerException

0 Answers0