Result Set not displaying data in JSP

Question

I am retrieving data from database in JSP in a result set. ResultSet in not empty but it is not displaying data in html tags, i.e. h3 is empty

ResultSet rs = null;
String sqlStr;

sqlStr = "SELECT * from IDEAS";
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sqlStr);

<% while (rs.next()) { %>
<h3> <% rs.getString("heading"); %></h3>
<% } %>

All other statements like insert , delete are working.

Ideally you shouldn't be doing that. JSP is definitely not a place to access Result Set. If you writing real code to be deployed somewhere in production, I will say this is a BIG BIG no. Read more about oops concept and segregate and modularize your code. — mawia
– mawia, Commented May 6, 2013 at 7:48

Community · Accepted Answer · 2017-05-23 12:18:56Z

3

It should be

<h3> <%= rs.getString("heading"); %></h3>

Note: putting java code in view is discouraged, put it in Servlet or Controller and use JSTL in view layer in jsp

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered May 6, 2013 at 7:45

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1700794 Over a year ago

I have used it , but for the question I wrote the code that way. Thanks for the help :)

Makky · Accepted Answer · 2013-05-06 07:57:45Z

0

Its a not a good practice to use that code in JSP layer . You should be using a backbean where you do your coding and just retrieve data to be viewed in JSP using JSTL.

answered May 6, 2013 at 7:57

Makky

17.6k18 gold badges66 silver badges91 bronze badges

Collectives™ on Stack Overflow

Result Set not displaying data in JSP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related