Displaying data from mysql database.

Newbie Member
8Jul2008,19:18   #1
guravharsha's Avatar
Hi,
In main.jsp i wish to display the data from the database( user information stored in user table ). my codein main.jsp is:

<h2> description about user:</h2>
<% Statement st = null;
ResultSet rs = null;

rs = st.executeQuery("Select description from user ");
%>
<option value = "<%=rs.getString("description")%>" >
</option>
when i run the above code it shows the error:
java.lang.NullPointerException
org.apache.jsp.main_jsp._jspService(main_jsp.java: 72)
like at above red color line
can anybody have solution for above or any alternative code.
Thanks and regards
Haresh
Invasive contributor
10Jul2008,11:48   #2
XXxxImmortalxxXX's Avatar
well you are calling the method on an object (st) reference set to NULL doesnt make any sense to me
that code is going to throw a NullPointerException.