Displaying data from mysql database.

guravharsha's Avatar, Join Date: Jun 2008
Newbie Member
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
XXxxImmortalxxXX's Avatar
Invasive contributor
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.