<%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <%@ include file="/db/dbconn.jsp" %> <% java.sql.Statement Rockstmt = conn.createStatement(); java.sql.ResultSet Rockrs = Rockstmt.executeQuery("Select top 18 * FROM tblTopic ORDER BY Topic_ID DESC"); while(Rockrs.next()) { String Topic_ID = Rockrs.getString("Topic_ID"); String Subject = Rockrs.getString("Subject"); String time = Rockrs.getString("Last_entry_date"); //String content_abstract = Rockrs.getString("content_abstract"); %>  <%=Subject%>

<% } Rockrs.close(); Rockstmt.close(); %>